Viewing 10 posts - 16 through 25 (of 25 total)
Is this by chance running on a cluster?
June 28, 2006 at 9:48 am
Remove the GO from this line:
ON [inherfrom] = grantee INNER JOIN sysobjects ON GO sysobjects.[id] = syspermissions.[id] ORDER BY
However I still get an empty list from running this query.
May 26, 2006 at 12:48 pm
Make sure to kill any transactions using TEMPDB or wait until they're finished.
Then run this:
use TEMPDB
dbcc shrinkfile (TEMPDEV, 1000)
March 24, 2006 at 7:40 am
You could disable all network protocols but of course then you couldn't access your databases over the network. But it would be hidden!
March 20, 2006 at 9:30 am
From your original post, it doesn't appear that you specified the domain name with the account? ie., domain name\account
Or did you?
January 20, 2006 at 8:26 am
Pendragon999 you are reading it right! I have checked the SQL 2000 Sys Admin. book and it does say that Advanced Server only supports two nodes. So now I will...
November 28, 2005 at 3:23 pm
The entry "Extent Scan Fragmentation ...................: 26.56%" indicates external fragmentation (gaps between extents). This percentage should be close to 0%.
August 23, 2005 at 9:20 am
What size is the log? The log would not be included in the DB backup.
August 12, 2005 at 9:40 am
You might want to check that the Master database has the property "automatically grow file" turned on. The service packs add objects to the Master database and cause the Master to...
August 1, 2005 at 8:37 am
February 11, 2005 at 9:02 am
Viewing 10 posts - 16 through 25 (of 25 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy