This isn't a best practice article. Instead, it says the "worst practice" is depending on the GUI, not using the GUI. I appreciate all the comments and most are valid....

Try here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_con05_8a9c.asp

Steve Jones

steve@dkranch.net

As far as I know, there is not name yet. Not sure if there will be a patch since you would have to scan all connections to SQL Server and...

I'd use ISNULL if you need this.

Steve Jones

steve@dkranch.net

Is this a user database? Which version of SQL? How are you getting the information that where are 3000 views? Did you create 900 views in this db?

Some more...

Sorry Tom, haven't heard of this. I will ask around.

Steve Jones

steve@dkranch.net

Use >> if you do it through a shell.

select @text = ColumnA from TableA

exec master..xp_cmdshell 'echo ' + @text + ' >> c:\test.txt'

Steve Jones

steve@dkranch.net

Do you mean new objects, or existing objects?

Existing ones will have to be changeed with sp_changeobjectowner

Steve Jones

steve@dkranch.net

Should workin both. Are you getting an error? Perhaps he still has a login in the db.

Steve Jones

steve@dkranch.net

Slow ass DMO coders!

BTW, as to the original question, do you ahve other tables that return quickly? Perhaps you are IO constrained.

Steve Jones

steve@dkranch.net

I'll give it a try, but I'm not sure a GUI is necessary. As a design tool, I'd agree, but for making changes, I think I'll stick with my scripts.

Steve...

probably beginner's luck . I'm sure it works, but if it fails, you are stuck holding pieces and may end up manually doing it instead. I like...

This is dangerous to do in a trigger. The insert will not complete until the write does and that could be an issue from the OS.

From a trigger, you could...

Can you just post all the column names? or generate a script for the creation of the table.

Steve Jones

steve@dkranch.net

can you post the script that is giving this error?

Steve Jones

steve@dkranch.net