Try like this:

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TABLENAME]') AND type in (N'U'))

BEGIN

CREATE TABLE TABLENAME

(

COL1 INT,

COL2 VARCHAR(10)

)

END

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =...

Did you get a chance to check the destination table for default values or triggers? If you supply a number and the stored proc works, I would believe you...

I have experience this first hand and it is very annoying. I am interested to know if anyone has discovered a fix.

-Adam

Have you tried looking through the job history of the job that runs the maintenance plan? Do any of your steps continue on error?

You should be able to...

Check for the existence of the table for creating it

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TABLENAME]') AND type in (N'U'))

BEGIN

CREATE TABLE TABLENAME

(

COL1 INT,

COL2 VARCHAR(10)

)

END

GO

As Scott said, RESTORE DATABASE dbname WITH RECOVERY, this will remove the database from a recovering state. Delete the database. Then restore from backup.

Yeah, the price for 3rd party readers is precipitous. I wanted to play/test a log reader app and could never find one that met my budgeted price of FREE.

There is USUALLY no problem in overwriting FULL backups, unless something happens to that backup. If you lose the full backup and/or have a corrupt full backup, you will...

Steve,

Doesn't Log Rescue only work for SQL 2000?

-Adam

Did you right-click on the database choose properties and go to the "Mirroring" tab?

This should give you what you need. You first have to create a function to get the begining of the week. By default Microsoft sets this value to...

Does it support any other form of "if then logic", just curious? You could do this with a temp table, but then we wouldn't learn anything 🙂

Can you put this into a stored procedure and do a remote procedure call? Or can the ODBC not process CASE TSQL statements within stored procedures?

Sweet :hehe: I did not know about this, thanks Jeff !!

Are you trying to script database objects dynamically, for a specified database, or trying to avoid all the SSMS clicking to generate the scripts?

There are third party tools that will...