No. I think they just need to find all objects such as views or sp's that contained the text Address.

Try this.

Select TOP 1 ID, coalesce(Name,'')+ ';' + Name

FROM Table1

Where ID = 1

Actually that will scan all databases. All you need is this.

select object_name(id) , [Text] from syscomments

where text like '%Address%'

Try this.

CREATE TABLE #Tmp

(DatabaseName varchar(100),

ObjectName varchar(100),

Txt varchar(4000)

)

INSERT INTO #Tmp

EXEC(

'sp_msforeachdb''

USE ?

select ''''?'''', object_name(id) , [Text] from syscomments

where text like ''''%Address%''''

'''

)

Select * from #Tmp

Drop Table #Tmp

In Enterprise Manager you have to highlight the column header by clicking the cell header.

The connection timeout is how long the app will wait to connect to sql. The command timeout is how long the command will wait for the query results.

The second part is not in quotes.

'Create Table' + @[User::newfile] + '(

[First] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Middle] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

...

You can increase your command timeout in the application.

dim cmd as sqlcommand

cmd.commandtimeout = 300

Or you can change it in the connection string.

data source=xxxx;initial catalog=xxxx;integrated security=SSPI;Connect Timeout=300;

Try this.

insert into Table1 (a,b,c)

(select a,b,

CASE c WHEN NULL THEN ' ' ELSE c END

from Table2)

Here is a sample of inserting from the table with the xml datatype to a parsed table.

INSERT INTO SERVERS(SerialNumber,Manufacturer,Model,SystemType)

Select

InventoryXML.value('(/Root/Server/SerialNumber)[1]','varchar(50)') SerialNumber,

InventoryXML.value('(/Root/Server/Manufacturer)[1]','varchar(50)') Manufacturer,

InventoryXML.value('(/Root/Server/Model)[1]','varchar(50)') Model,

InventoryXML.value('(/Root/Server/SystemType)[1]','varchar(50)')...

Here is a sample that loads an xml file to a table with an xml column.

INSERT INTO InventoryFeeds (InventoryXML)

SELECT InventoryXML

FROM ( SELECT * FROM OPENROWSET ...

I think this may do what you want.

http://www.mssqltips.com/tip.asp?tip=1487

I dont think you need the server variable since you are already connected to that instance. That is what is causing the syntax error. You can not put...

Create Table #Temp

(Script varchar(1000)

)

INSERT INTO #Temp

Exec sp_msforeachtable'

Select ''Alter Table '' + ''?'' + '' ADD CONSTRAINT '' + object_name(c.cdefault) + '' DEFAULT '' + t.text + '' FOR...

See if this helps.

Create Table #Temp

(TableName varchar(100),

ColumnName varchar(100),

DefaultName varchar(500),

DefaultText varchar(100)

)

INSERT INTO #Temp

Exec sp_msforeachtable'

Select ''?'' TableName ,c.Name, object_name(c.cdefault) DefaultName,

t.text

from dbo.syscolumns c

join dbo.syscomments t on t.id...