Having fun with more dynamic dynamic sql
DECLARE @stmt NCHAR(1000)
SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13) +
'SET @stmt = ''CREATE TABLE Second (col_a int)''' + CHAR (13) +
'EXEC sp_executesql @stmt'
EXEC sp_executesql @stmt
Do I need to add the reference to Erland Sommarskog again?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]