Search Results

Search found 28930 results on 1158 pages for 'sql ce'.

Page 477/1158 | < Previous Page | 473 474 475 476 477 478 479 480 481 482 483 484  | Next Page >

• Partition 500gb of database stored in SQL Server

  - by Devendra

  Hello I have 500GB of database stored in SQL Server. Because it has too big a database, it takes time to update and insert data. Now the case is that I want to partition the data. So which partitioning techniques should I use? Or is there any other technique which will improve my performance?

  Read the article

• how to write batchfile/storeproc for cheking the mail in the inbox using jobmanager [closed]

  - by ganesh

  Possible Duplicate: How can I handle emailed job control files for SQL Server? how to write batchfile/storeproc for cheking the mail in the inbox using jobmanager

  Read the article

• Any specific issues found running HP Quality Center 10.0 on SQL Server 2008

  - by BrianP

  Has anyone successfully gotten HP Quality Center 10.0 installed and running using the as-yet unsupported Microsoft SQL server 2008? Have you hit a specific issue? e.g. any issues with full text search etc.

  Read the article

• Capabilities and pricing of Amazon's cloud computing platform?

  - by inspirednow

  I'm finding it very hard to estimate how much my web application might cost running in Amazon's cloud? My app is similar to stackoverflow.com - asp.net, ajaz, sql database. Can anyone estimate how much it might cost to run stackoverflow in Amazon's cloud?

  Read the article

• why restoring database never finishes?

  - by LingAi

  Hi all, I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone know what's the problem? Thanks, Ling

  Read the article

• Setting Low Disk Space Alerts on Windows Server 2008

  - by rmwetmore

  I was wondering if there is an easy way to trigger an e-mail alert on Windows Server 2008 when any logical disk partitions become low on space. I have 2 SQL servers that have come close to running out of disk space because of the DB log files. Thanks, Ryan

  Read the article

• Distributed transaction aborted by MSDTC

  - by aarsh thakur

  How to resolve the error 8522 in SQL Server 2005? I'm getting this error while I'm loading data from the remote server.

  Read the article

• Sharepoint and SSRS Native Integration - Not seeing web parts after cabinet file install

  - by Greg_the_Ant

  I followed the steps here to set up Sharepoint integration with reporting services (SSRS) using native mode. (i.e., get a report explorer and viewer web parts) However after adding the cabinet file e.g., STSADM.EXE -o addwppack -filename "C:\ Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall I still don't see report explorer in the web parts list. I'm very stuck and confused :-(

  Read the article

• Which SQL database should I run?

  - by Chris Salij

  I'm creating my first website from hand-coded scratch (just used WordPress and Drupal before) and I'm at the point where I'm setting up my database for the site. However my host has given me 4 options to choose from in the database department. MS SQL Server 2005 MySQL PostgreSQL MySQL 5 Which should I go for? From what I understand PostgreSQL is meant for smaller databases with high access times. Though to be honost I'm not quite sure.

  Read the article

• Basic requirements in a laptop for running VS2010 and SQL Server 2008 smoothly

  - by Yajuvendra

  Planning to buy a laptop(reasonable budget). I want to know the basic requirement to run VS2010 and SQL Server 2008 smoothly with Adobe Photoshop CS4 and Dreamweaver CS4 in Windows 7 Home. Can Pentium Processor do the job? If not please Suggest me. Thank you.

  Read the article

• Administrator can run a application but produces error while a administrator previllaged user can run without error

  - by tough

  I have an application which can run as admin prevailed user without error but while administrator runs it it produces error. The input string was not in correct format-application error. I tried to figure it out but not possible, since most of the people are looking for admin privilege to run it, me looking why can't a admin run the program without errors? The program is related to mssql-2008 r2. The SQL log-in settings are same for both the users.

  Read the article

• How to show the "Home" folder for SSRS 2008 in SQL Management Studio

  - by kd7iwp

  I just installed SSRS 2008 on a development server and when I connect to it with SQL Management Studio I do not have all of the items in Object Explorer that I had with our SSRS 2005 installation. For example, we are missing the "Home" folder which lists all the reports. When we browse to our /ReportServer URL we can view and run our reports, so I know they are on the server. Does anyone know if this is a permissions issue or something else?

  Read the article

• How to show the "Home" folder for SSRS 2008 in SQL Management Studio

  - by kd7iwp

  I just installed SSRS 2008 on a development server and when I connect to it with SQL Management Studio I do not have all of the items in Object Explorer that I had with our SSRS 2005 installation. For example, we are missing the "Home" folder which lists all the reports. When we browse to our /ReportServer URL we can view and run our reports, so I know they are on the server. Does anyone know if this is a permissions issue or something else?

  Read the article

• What perfmon counters should I track for improvements to the query plan cache?

  - by Bill Paetzke

  I am parameterizing my web app's ad hoc sql. As a result, I expect the query plan cache to reduce in size and have a higher hit ratio. What should I track in perfmon regarding this? How could I report on this change? (I'd also accept an answer that queries the DMV tables or whatever else to report on the change).

  Read the article

• Add second ip address to an existing SQl 2008 failover clustering

  - by Cédric Boivin

  Hello, I got actually a failover cluster on Windows Server 2008, with sql server 2008. On each server i got two network card, with two different network one are on 10.10.10.x and other are on 192.168.99.x I want my sqlserver cluster listen on the two network. Is it possible and how i add new ip address. When i add a new ip address directly in the cluster, and i do a telnet on the 1433 port with the new cluster ip address it's not working. Thanks

  Read the article

• Realtime MS SQL Database transfer

  - by user34402

  Hello, I have MS SQL 2005 Standard that is used actively (new data is added every minute). I need to transfer it to another server (new hosting provider), without losing the data and without downtime. Is there any way to do it?

  Read the article

• How do you find all dependencies of a database table?

  - by Carlos

  In MS SQL 2005, is it possible to find out which tables/columns are being used either as keys in another table, or as part of a stored procedure? The reason is I'm trying to clean up some old stored procs and tables, some of which can be removed, some of which can have columns pruned. But obviously I don't want to remove stuff which is being used.

  Read the article

• Corrupt Database

  - by user250545

  I am Looking For Best Way or Software To Recover Corrupt Database in SQL 2000/2005/2008 . looking for Ur help .......................................

  Read the article

• How to set Standby server

  - by lasko

  I have an application that connects to SQL Server 2008. What I want is to make a standby server (this standby server should be a mirror of the primary one). So that when the connection fails, the primary server should automatically switch to standby server without modifying my application. If there is way, please tell me in detail or even if there is third party product. Note that I need to set the connection in my application to one server only.

  Read the article

• Disable SQL Server at windows startup (VS 2010)

  - by ile

  After I installed Windows 7, booting lasted for about 40 seconds. Then I installed VS2010 and booting is 20 seconds longer. In task manager I see SQL Server process running. Is there a way to disable these programs at startup and fasten booting?

  Read the article

• Access SSIS Projects Stored in MSDB Database in BIDS?

  - by dmackey

  I have a database server (db1) that has SSIS installed and configured (SQL 2008). I have configured it so I can remotely connect to SSIS through SSMS. Now I am trying to open one of these SSIS projects that is in the MSDB database? I know in SSRS it is easy to deploy to the server reports, but I'm not seeing a way to open or deploy SSIS projects? Dave.

  Read the article

• Problems with Apache Mod_Proxy and Microsoft's ReportViewer's Reserved.ReportViewerWebControl.axd

  - by ActionJack

  I've configured an Apache httpd server (v2.2) as a reverse proxy (with SSL) to a Microsoft IIS website running an ASP.NET application with SQL Server Report Services. The proxy mostly works but Report Viewer reports aren't being proxied, all I get is a square window in Chrome and in IE I get the following error: This page contains both secure and nonsecure items. Do you want to display the non secure items? I click yes then I get the following: Unable to locate control: ReportFrame_ctl0_plchldrMainContent_1_ReportViewer1.

  Read the article

• How see the converted sql from ActiveRecord method in view, etc

  - by Jak

  Hi All, I will be happy if someone clear doubt, i can see objects in view by using <%= debug @object % and lot of methods is there apart from view like .to_yml, etc Is there any method available for seeing the converted sql from ActiveRecord method in view, etc. Although I can find it in console but it will confuse when we run multiple queries.. example: User.find :all it will produce "SELECT * FROM users;" in output console But i want it in view are any other specific point like yml , etc ? Thanks, Jak

  Read the article

• Connecting mySQL to MSSQL

  - by user180198

  I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives on a NAS on the same network: Local: DB Engine on server, named, server\sqlexpress and IP = 10.0.0.201 Target: DB on NAS, named, CISCO-NAS and IP = 10.0.0.182 Will need for this to sync every few mins... I really don't know how to start.

  Read the article

• Run a MySQL server in a self-contained folder

  - by codersarepeople

  I've seen many questions about how to run multiple sql servers on one server, but I would like to run mysqld as a user-level process and completely self contained in a folder (I have no permissions outside my user folder). I spent some time using the --defaults-file=my.cnf, but it still seems to conflict with the system-level mysql server that's running. Does anybody know how to do this? Thanks in advance!

  Read the article

< Previous Page | 473 474 475 476 477 478 479 480 481 482 483 484  | Next Page >