Viewing 15 posts - 451 through 465 (of 1,161 total)
Here are some good documentation.
http://msdn.microsoft.com/en-us/library/ms345108(SQL.90).aspx
November 7, 2010 at 12:46 am
This article explains the permissions that the SQL Server service account needs to have.
November 4, 2010 at 7:49 am
Check if the SQL Server services are running.
Check you are connecting to the correct instance
Check if Remote Connections are enabled
November 4, 2010 at 5:47 am
For backing up the database, the login must be part of db_backupoperator fixed database role. More here
For restoring the database, the login must be part of sysadmin fixed server role....
November 3, 2010 at 7:18 am
Nothing much to be done from DBA. Once the cards are installed, DBA needs to ensure that the SQL Service is on the right IP (even though this going wrong...
November 3, 2010 at 7:10 am
While trying to upgrade to SQL Server 2005, the "Upgrade Advisor" is failing. Check if this discussion helps.
November 3, 2010 at 6:42 am
Open Task Manager and check what is the CPU and Memory usage on the box. Also check which process on the system is utilizing more CPU/memory on the system
November 3, 2010 at 1:52 am
If an index is not used, the fragmentation on that does not matter as far as the performance of a query is considered. It would be better to target the...
November 2, 2010 at 11:05 pm
The output of RESTORE VERIFYONLY is not logged in the SQL Server Error Log. If you are executing the custom stored procedure through a job, the job step output file...
November 2, 2010 at 11:00 pm
Please don't cross post.
All replies be made at http://www.sqlservercentral.com/Forums/Topic1014815-391-1.aspx
November 2, 2010 at 1:48 pm
The installation seems to have failed because of the previous installation. You may find this article useful to manual cleanup SQL Server installations.
November 2, 2010 at 1:45 pm
I was able to download the file from that link
November 2, 2010 at 1:08 pm
I am not aware of the restrictions on the number of Save points. This article states that there can be "multiple" save points in a transaction.
November 2, 2010 at 1:02 pm
Viewing 15 posts - 451 through 465 (of 1,161 total)