One more thing about this. I would like to pass in the entire file path to xp_fileexist like this:

EXEC master.dbo.xp_fileexist 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\' + @dbname + '_db_' +...

Your script works and helps me achieve my goal. Thanks for your help!

CK Bhatia,

Thanks for your reply. I like your suggestion but I am stuck on a couple things. Here is what I am trying:

CREATE TABLE #fileexist ([ID] int IDENTITY(1,1),...

Thanks for your reply. I'm going to try to use something like this:

CREATE TABLE #dir ([ID] int IDENTITY(1,1), [Dir] varchar(255) )

INSERT INTO #Dir([Dir])

EXEC master.dbo.xp_cmdshell 'DIR "C:\Program Files\Microsoft SQL...

I can't recall where I got these SPs but I've been using sp_help_revlogin to generate a script that can recreate logins on another SQL server.  You need to run both...

No, AD is not required.  Our IIS servers are on an AD domain but our SQL servers are in a workgroup.  Only local accounts are used so AD never comes...

It is possible to use Windows "passthrough" authentication between a web server and a SQL server.  To set it up you need to have identical local accounts on the web...

Thanks for your reply. Does anyone else have any experience with in-place upgrades to SQL 2005? What are the ups and downs of doing an in-place upgrade? ...

Yes, that's it. I overlooked that column. Thanks and sorry for such a basic question!

Great article.  I'm glad that I am not the only one who is missing these features.  I especially miss the ability to DTS objects, such as SPs, from one db...

To the novice DBA this definitely looks like something that would benefit our developers and to help a DBA get their feet wet with try/catch phrases.  However, as a novice,...

For the life of me I still have not been able to get the "Transfer SQL Objects Task" to work. I created a project to copy one stored procedure...

Thanks for your reply.  This definitely sets me in the right direction.  I was able to find the "Transfer SQL Server Objects Task" but I was unable to see how...

We will need to find a way at our organization to have the "Enable Identity Insert" checkbox ticked by default in the DTS wizard.  I suppose there is...

There are several lines in Alert.vbs that reference Microsoft's site. If my SQL server does not have HTTP access do the web what are my options here? Thanks.

objEmail.Configuration.Fields.Item...