Same thing just happened to me, I pressed preview & it vanished!

So I'm typing this into an editor & I'll paste it...

Thanks for the response, at least I know I'm not alone 🙂

On the issue of testing DR failure, what is your experience with Testing it? Specifically, flipping from ServerA...

Any one there? I can't believe no one has done this! Am I posting in the right forum?

Dave J

I sent this to one of our developers recently:

--to select all records dated 9th January 2004 in myTable_T use

select * from myTable_T

where dateQueued Between '09 Jan 2004' and '10 Jan...

Thanks for the input. I will give it a go tomorrow as everyone is logging in...

Dave

Try unregistering the DLL in system32 (regsvr32 /u <path\filename> ) and registering the correct one. (regsvr32.exe <full path to correct file> )

HTH

Dave

DOuglas

thanks for your response, I have just ran the DBCC commands you sugggest.  I must be honest & say I haven't seen that one before.  Is it undocumented?

Thanks for the feedback.  I have done some further research & come up with:

From this article, http://support.microsoft.com/default.aspx?scid=kb;en-us;828339

Note You may or may not see errors from...

I posted a very simliar question last week and got the v.useful answer use sp_setnetname.  see; http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=123539 for the full details

Jacko

That sounds ideal.  Thanks for the suggestion.  I'll try it out as soon as I can

thanks again

Dave

You can Query Jobs via DMO, and Users, so we could extend the script to include them.  AFAIK, you can't get DTS pacakges.  They have their own Object Model,...

sounds good but the download link

http://www.sqlservercentral.com/products/bwunder/archiveutility/Setup.msi

is broken.

A little late, but I have just updated the comments at the top & took out passwords etc.

I'll post this into the script section in a mo' (my first

I'll clean it up (remover server, user names etc.) & post tonight. Promise

I have a VB Script that scripts out all the objects in a db, checks them against the sourceSafe version, and checks the new script if it finds a difference. ...