Viewing 15 posts - 39,181 through 39,195 (of 39,717 total)
The query plan will only be reused if it is in memory. These have a much lower priority than stored procedures and get phaased out relatively quickly.
Steve Jones
November 15, 2001 at 12:19 pm
November 15, 2001 at 7:11 am
shut down the Anti Virus before installing. It probably does not like you updating the MDAC files. That is a place where someone would place a virus or a backdoor.
Steve...
November 14, 2001 at 10:08 am
November 14, 2001 at 9:43 am
Should be no issue. Is this an install of the SQL Server or the Service Pack.
Steve Jones
November 14, 2001 at 9:43 am
I've got a series on this very subject that should be starting soon. Hopefully it will give you some ideas about keeping your production and development in synch.
Steve Jones
November 14, 2001 at 9:30 am
November 13, 2001 at 3:50 pm
I agree with the differences. I think that at some point, for at least some sections, there should be statutary regulations for computer professionals. Especially where life may be at...
November 13, 2001 at 1:57 pm
Agree with Andy. You would need to use filegorups (or add another file to the default group). Hopefully you are on RAID. If so, your raid controller may support...
November 13, 2001 at 1:50 pm
Sorry we couldn't help. Haven't seen this, but if you get in a bind, might be worth calling MS. It's $250, but how soon could you burn $250 of your...
November 13, 2001 at 10:26 am
You can search syscomments if you have rights using
select *
from syscomments
where text like '%sa= %'
Then kick the developers in the a**!
Steve Jones
November 13, 2001 at 10:25 am
It is a security problem. I believe the XP_trace procedures are limited to sysadmin role members. If you can get added, this should work.
If not, then you will have to...
November 13, 2001 at 10:23 am
Haven't read it, and I would agree that not everyone requires that level of expertise. But part of what the certification does is present to an employer some level of...
November 13, 2001 at 10:20 am
Can you provide more details? Your description only generally states the problem.
I.e. If you run a restore, what script do you use or what do you check in EM...
November 13, 2001 at 10:10 am
It should have created a text file on the c: drive of the server in the root called testjob.txt. It will not be on your local c: drive, so...
November 13, 2001 at 10:08 am
Viewing 15 posts - 39,181 through 39,195 (of 39,717 total)