Viewing 15 posts - 451 through 465 (of 1,157 total)
Here are some good documentation.
http://msdn.microsoft.com/en-us/library/ms345108(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms166049.aspx
http://www.developer.com/article.php/3640771
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 7, 2010 at 12:46 am
This article explains the permissions that the SQL Server service account needs to have.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 4, 2010 at 5:47 am
This has lot of options listed.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 3, 2010 at 11:34 pm
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....
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 2, 2010 at 11:00 pm
I usually run ROBOCOPY as a SQL Agent Job Step.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 2, 2010 at 9:22 pm
Please don't cross post.
All replies be made at http://www.sqlservercentral.com/Forums/Topic1014815-391-1.aspx
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 2, 2010 at 1:45 pm
I was able to download the file from that link
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
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.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 2, 2010 at 1:02 pm
Viewing 15 posts - 451 through 465 (of 1,157 total)