SQL Sentry does basically what EdVassie is talking about.  Excellent scheduling software for SQL IMO.  And no I am not linked with the company in any way, just been very...

Not sure I am buying what theSQLGuru is saying, but assuming that it is....

You could select a count of how many would fullfill your criteria into a variable first, then...

Not sure what they have tried since I am not the developer of it.  But interrestingly enough that is what I told them to do

Looks to me like they are getting rid of nothing.  They are keeping the data, so all they are doing is change the acronym for the operrational program, most likely...

Mapped drives work in SQL, just doesn't work in Windows 2003.

File copy gets impractical though with large files... I've had more luck restoring directly from a remote drive than copying. ...

Well, I have to say that it is probably very similar to the SAP import files I have had to make.  Which incidentaly is the only time in my life I...

The code is there to produce it, just change the alter to a create.

Mine is just an easy way (for me) to look trough all the user databases for code,...

That's true Brandie, and is one of the reasons why the long term effects of outsourcing and international trade does not worry me.  Short term the effect can be devastating,...

LOL Rudy, I'm with you.  I think there is a SQL 2005 launch event shirt somewhere that I have never used though.  And have had a few over the years,...

Excellent read, and confirms a lot of what I have heard from my Indian developer friends over the years.

This smells like an SAP import file.... It's ugly.

XML should be great for this kind of stuff though

I use the following stored proc compiled in the master database.  Use at your own risk..

USE

[master]

GO

/****** Object: StoredProcedure [dbo].[sp_FindCode] Script Date: 08/24/2007 09:01:47 ******/