Thanks BME. The same was happening for me. In my case, I had disabled UAC on a Win2008 machine, but then cloned the machine and renamed it. Now, the UAC...

I've been working for about 5 years now and have been in three companies. The first company (about 100 people) that hired me out of university was a VERY...

Here's one I'm particularly proud of. It was originally conceived as an April Fools prank, but we missed the date, so we did it as a birthday prank instead....

Good points. I generally do a staged removal of objects. Then I think I'll go the revoke route when pulling the views out of production. That way,...

Ya, I suspected that I'd have to do a search in the code. That will be the safest, the view does have a unique name.

Thanks.

I vote for back to the way it was. I don't use the Users Needing Help section very often, but I glance at it if I've got a lighter...

Hi Steve,

The new newsletter looks good. I really like that you removed the giant advertisement between the "In this Issue" section and the content of the newsletter. ...

Hi everyone, sorry for keeping quiet for the past week on this topic.  I really appreciate all the advice.  Here is the status so far.

I'm working from Mr. Uddin's guidance...

Hi guys,

Sorry for the delay in replying.

1) Yes, I've tried DROPCLEANBUFFERS, I've even restarted the server. This didn't resolve the problem

2) I didn't use any switches when using...

I did try CHKDSK, but it didn't identify any data in bad sectors.  I'm not sure how this works on RAID volumes, but it didn't identify any problems. 

Also the...

The production server gives me

Error: 823, Severity: 24, State: 2

I/O error (bad page ID) detected during read at offset 0x0000015e3de000 in file 'D:\MSSQL2000\MSSQL\data\nyseg_main.mdf'.

I know the error is a result...

This is really a good script. But for those of us who are Spanish impared, there is an English version on Dimac's web site. Here is the URL.

Some specific feedback about the two marketing strategies that SSC used recently.  I don't mind the Page Peel advertisement at all.  It's unique and non-intrusive.  The Double Underline drove me...

Can xpweb70.dll be registered on an MSDE installation for testing?  If no, can someone provide instructions to do this?

Thanks

Paul

I know this is a really old thread, but I haven't found the answer anywhere else online. 

Here's how you programmatically change the autostart option for your SQL Server Agent.

EXEC...