Viewing 15 posts - 1 through 15 (of 23 total)
Robert,
The limitation of xp_fixeddrives is that it doesnt return the size of the drive.
I use srvinfo -ns. Its in the Resource Kit. The command returns lots of data but with some tsql,...
January 5, 2004 at 8:42 am
mom - I did create the function using domain\username. This username belongs to the 'system administrators' server role so I don't think permissions is the problem
DavidT - I think you...
November 25, 2003 at 10:09 am
If you are using SQL2000, you could try the new table datatype. Check out 'Using Special Data' in BOL for an example.
October 23, 2003 at 8:11 am
This may depend on what version of SQL Server you are using. On SQL2000, spids 1-50 are reserved for system processes.
Having said that, I've just looked on a server here...
July 2, 2003 at 5:30 am
You could place the table into its own filegroup. SQL2000 allows the restore of individual filegroups.
Make sure you restore the table and its indexes and consider any referential integrity/foreign key...
July 2, 2003 at 5:10 am
Thats a hard question to answer. I think you need to look at the criticality of each system and what level of recovery your users would expect in the event...
July 2, 2003 at 4:45 am
I agree with the above comments. No test or standby server is very short-sighted.
To get back to the original question. If you cant restore your backup, you could try
"RESTORE...
June 27, 2003 at 3:24 am
How about
xp_cmdshell 'net view \\server_name'
or
xp_cmdshell 'ping server_name'
Direct the output to a file and search for a string in the file
June 25, 2003 at 5:20 am
Have you considered the practical issues ? For example
1. If a server is accessed 24/7, what happens during downtime ? Can you warn all users in advance ?
2. Are your...
June 13, 2003 at 8:03 am
To help isolate why the restore is taking over 6 hours, copy the database dump file to disk and then re-try the restore. Note the time this restore takes. The...
June 12, 2003 at 5:13 am
Try
execute master..xp_cmdshell 'srvinfo -ns'
which gives you disk capacity, used and free
(Thanks to Bill from Walmart for this)
June 12, 2003 at 4:06 am
We have an intermittent problem on one production server which leads to very slow response times for users. It happens 1-2 times per week so Black Box monitoring looked like...
April 28, 2003 at 5:28 am
Sreeni - Good to read that you have a solution. My upgrades are also working with SP2 + security fix
February 20, 2003 at 10:18 am
Success !! The upgrade worked first time with SP2 + security fix applied.
February 20, 2003 at 9:41 am
Viewing 15 posts - 1 through 15 (of 23 total)