Viewing 15 posts - 181 through 195 (of 1,247 total)
What information would you like to include in your reports?
If you would like to get the number of rows in each table only, you may try to use the system...
August 11, 2008 at 12:30 pm
Where did you want to install your SQL 2005? In your desktop? You can only install Express Edition to your desktop, in my memory. Please check microsoft website.
August 11, 2008 at 10:39 am
Many sources can cause this error. I would like to check SQL error logs first if I were you. Here are some links. May they help.
http://www.webmasterworld.com/forum47/3167.htm
August 11, 2008 at 9:40 am
May the following link help.
August 11, 2008 at 9:25 am
Deadlocks are generated by queries. If there are many SELECT queries, you may try to use NOLOCK clause (or change the isolation level) to reduce the deadlock rate. But you...
August 11, 2008 at 8:42 am
Just rerun it. If it happens again, check what causes this deadlock.
August 8, 2008 at 11:02 am
What did you do in using xp_cmdshell?
I would like to recommend that you separate your trigger and xp_cmdshell to test where the problem is.
Run your xp_cmdshell command and see whether...
August 8, 2008 at 10:12 am
SQL Server reports is a new function in SQL 2005. You need to develop your own scripts or use the third party tool to generate reports in SQL 2000.
August 8, 2008 at 10:09 am
Did you run your program from your active node?
Your program should be on your active node or your shared drive in a cluster.
August 8, 2008 at 10:07 am
ybol:
I have used clusters and virtual machines for years. I have not had any problems so far. The disavantages in using cluster is its difficulty in recovery.
Would you like to...
August 8, 2008 at 10:00 am
It seems that you were applying patch from a remote site. There are two possibilities causing the error.
1. You do not have authority to access the remote site;
2. The server...
August 8, 2008 at 9:19 am
There is a medicine curing all. Your log file increases because of heavy activities there. You cannot set a limit for it. You may try to use BULK_LOGGED to reduce...
August 7, 2008 at 2:53 pm
Did you check the SQL Server Properties and see what you could do under the Memory tab?
August 7, 2008 at 2:28 pm
For tgh:
ShrinkDB shrinks a database.
Shrinkfile shrinks a specific database file. A database may have many files.
August 6, 2008 at 10:10 am
Viewing 15 posts - 181 through 195 (of 1,247 total)