Viewing 15 posts - 37,801 through 37,815 (of 39,498 total)
March 14, 2002 at 4:39 pm
Sorry, SQL 2k, SP1, W2K, SP2.
Interesting. On my SQL 7 server on NT 4, I think SP1 and SP6 respectively, I get a difference. I checked it a couple times...
March 14, 2002 at 11:06 am
I tend to agree with Antares. In Denver I constantly hear about these tech schools advertising you can get certified or trained and get a 60k/yr job. I'm sorry, but...
March 14, 2002 at 10:46 am
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
Viewing 15 posts - 37,801 through 37,815 (of 39,498 total)