usually I use tamarack.com .vs fulltextsearch.com and I have

not found an answer yet.

Did you set your Action to SQLDMOBackup_Database?

How would I also ignore tables that have an IMAGE type field?

I can't quite get it.

Nevermind, I figured it out on my own...

IF NOT EXISTS (select * from dbo.sysxlogins where [name]='SW')
BEGIN
  EXEC Master..sp_addlogin 'SW', 'SWPWD', 'MASTER', 'us_english', 0x5CE521831B15A3928B66002DCC774486
END

IF EXISTS (select * from dbo.sysdatabases where...

I don't have a SW user is syslogins. I also don't know where to find out if/any role has been granted to the table for that login.

In fact, I don't...

According to KB Article Q300965:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q300965

We have been 'registering' the TSWSQLXP.DLL wrongly for ages.

We have experienced loads of trouble trying to get a new

version installed and...

Well, that's what "DBCC TSWSQLXP (FREE)" is supposed to do.

From BOL:

DBCC dllname (FREE)

Unloads the specified extended stored procedure dynamic-link library (DLL) from memory.

After careful inspection of the offending script, we have found that

the problem was occuring because a SP was referencing a view that

had referenced a table that had been dropped....

Thanks a lot, Jeff, that is just what I needed.

Hrishikesh - That won't create the procedure if it already exists, it'll just drop it.

I'm working on trying out some other costructs this morning and will fill you in...

We have decided to use: PRINT 'Updating DB_Update_Num to 61'

instead of the select you are showing.

Is there a references anywhere that would tell us how to port DMO to SMO?

Using OSQL, if you use the -E switch, it uses a trusted login.

We use it to add other logins to our DB like that.

I know that, that's what we're using. I just wanted to insert extra things into the output file kind of like progress desscriptions.