Viewing 15 posts - 38,026 through 38,040 (of 39,720 total)
I agree. Disks are relatively cheap. you;ve probably wasted some serieous $$ in time trying to get around this.
Steve Jones
March 14, 2002 at 10:41 am
There is a Dell diagnostics disk that came with the DELL servers that will run testing against the box. A colleague had to stress the I/O system because he suspected...
March 14, 2002 at 10:30 am
The only way is to use a cmdshell.
See this:
select getdate()
exec xp_cmdshell 'time
'
it gets the time. To set or change the time, you'd have to pre=submit the time to the...
March 14, 2002 at 10:21 am
March 14, 2002 at 10:17 am
Are you having issues? If not, this is ok. The more memory SQL takes, the more data that is cached and the faster queries run.
I have 2GB in my server,...
March 14, 2002 at 10:16 am
The debugger works great, but if you want you can make the procedure a script and then you can go through it with lots of selects or prints to keep...
March 14, 2002 at 10:12 am
March 14, 2002 at 10:10 am
It's coming. I've got 2 more resource pages coming in the next few weeks and 4-5 more on the way. they will all get moved to resource pages eventually, but...
March 13, 2002 at 8:28 pm
only slightly. I have the book. It's not worth the money. Be better working with Andy's Articles.
Steve Jones
March 13, 2002 at 8:23 pm
Also, you cannot use EM when you do this because it is looking for more than one connection. Use Query Analyzer and have your restore scripted.
If you get stuck, "shutdown"...
March 13, 2002 at 6:56 pm
March 13, 2002 at 1:53 pm
be sure when you do this that you set the seed correctly to start with the next value you want to use.
Steve Jones
March 13, 2002 at 1:51 pm
March 13, 2002 at 12:34 pm
Viewing 15 posts - 38,026 through 38,040 (of 39,720 total)