I had the same issue with SQl Server 2005. Could not buikd the sp.

Msg 139, Level 15, State 1, Procedure TableInfo, Line 0

Cannot assign a default value to a...

I did know that EXEC was the only way to evaluate the variable inline. Thanks. Now my complete scripts works as I wanted it to.

Oops. I spoke too soon. Boy, this is complicated. The synatx works for creating the table but not for checking its existence and deleting it. ...

That worked! Thank you all very much. I'm off and running now.

Okay. Now it reads:

use sworks

go

DECLARE @temporary varchar(32)

SET @temporary = 'tq_old_lib_ids_counter'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[' + @temporary + ']') AND type in (N'U'))

DROP TABLE...

Thanks. I tried that using the following:

use sworks

go

DECLARE @temporary varchar(32)

SET @temporary = 'tq_old_lib_ids_counter'

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[' + @temporary + ']') AND type...

SUPER!!!!! This is a great asset to me. I will be using it a lot to verify I have made changes to my production database that match my...

I am not an SQL expert. There are a lot of select statements and it is a complex script. Can you share the changes you made with the...

Although the results screen is basic, it is easy to determine the change to schemas in a test versus production settings, for example. It does not have to be...

I just tried it and it worked great. I used it on two databases where I had made changes (to the test version of the DB) to one. ...

Thanks. I already use that for a smaller script and it works great. This script I have been working on is now finished. Using JUST VBscript, I...

Thank you.

This is close. The row I want already exists. I can grab it with a select and then I have the pk_auto_id also. I understand I can...