If you have Lightspeed or SQL Backup, be sure to check out my sp_ABBackup and sp_ABRestore utilities and the article that explains them, http://www.sqlservercentral.com/columnists/vIacoboni/moreintelligentbackupandrestore.asp.

They have saved my hide...

I'm alive! I just noticed your question now though, sorry! Did you personally email me? If not, fire away...

Not directly. My suggestion would be to use the @DryRun=1 parameter, which will generate the statements to restore the database but not execute them. You can then edit...

Yeah, that's just because we're installing it as a system function. Had to turn "allow updates" on to do that. You can safely ignore the spewage...

Well, I goofed. I used a similarly-named stored procedure that was meant for SQL 7, as you suspected. Thanks for finding this, Luis. Here's the proc I...

Luis,

If you give me a little more information on the error and the contents of syslogins and sysusers I'd be happy to look at it.

Vince

Ian,

Not more than a passing thought at this point, but I'll think about how to integrate it some more.

Vince

I'm a PERL convert and prefer it over any other high level non-SQL language. Perl's effortless handling of arrays and hashes mesh particular well with SQL's set-oriented abilities.

Brian, I...

Gabriela,

Interesting idea, but I don't see how it would be used when calling an existing stored procedure like sp_helpjob. Could you give an example of what you mean?

Vince

Add me to the pile. I read it -- saves me the trouble of searching out these sources myself.

Vince

Steve,

The answer is in general. As I stated, I'm aware that you can create the table first and then insert exec into it.

Sorry for the confusion caused...

OK, I think I solved this one. It appears that the dev box had different, domain account owners of the database. After loading the first time, I ran...

Kathi,

Thanks, but we aren't worried about the SQL accounts. Its the domain accounts that are the cause of the trouble. And, I've tried creating a new SQL account...

Chris Rose's point is important. I thought the point of this question was the default state of "NULL permitted" on a new table. If the author's intention of...

I hate "Me too!" posts, but...

Me too! I specifically chose my answer based on the fact that one would see the rows deleted if executed from the same...