That is it, I was missing the one part. THanks !

I use the Windows defrag utility on our SQL Servers. I will run it before I install SQL Server as well because Windows and all of the software that...

Something I always do before any patches or SP. I shutdown SQL Server and make a cold backup of the master, model, msdb, dist and mssqlresource mdf and ldf...

Apply to a non prod SQL Server first that is at the same SQL Server build set as your production.. meaning same service pack level and if you have any...

Thats it ! Thanks... I knew I was missing something. (Brain Cramp) It is one of those trying this and that and just needed someone else to look...

Sorry, I posted under SQL 2005 and also under SQL 2000 thinking that maybe there are different ways to do this under either version.

I found the answer:

use master

deny execute on...

I found the answer....

use master

deny execute on sp_replwritetovarbin to public

Thanks. I found that. I guess in 2005 they removed the simple I have a SQL statement staring me in the face in Query Analyzer and want to analyze...

In the Query tool run this select @@version.

I have seen this issue here a few times. Odd thing is the Drive has tons of space, TEMP DB is set to autogrow but does not grow to...

I saw that. I have never liked percentage growth increments. Too small at the beginning and too big when it file is large. From day one I change all...

Will do. Thanks to all !

Interesting thought. I have never seen this error message before in any of our many SQL Servers over the years. In researching this error it is interesting that...

Good article ! I guess I did not realize all of those goodie features in SQL 2008 were in Enterprise Edition. Yikes ! Your article was an eye...

The MDF file is 2.3 gig. I manually increased the ldf file to 500mg. What I don't get is it is set to auto grow and there is 2 gig...