Yikes, don't monitor those.

Thanks for the followup.

Steve Jones

steve@dkranch.net

do you have a key that includes data about where the data was entered? If you have the same key for both sources, you will have problems. You should have...

If you want to use DTS, I'd use andy's suggestion of FSO.

Either way, I'd get it out of the trigger and use some other process to move data often.

Steve Jones

steve@dkranch.net

np on the long post, but it doesn't make sense.

This is one table that gets a bunch of information, but what does the table look like? What columns?

Then something calls...

2000 of them?

Steve Jones

steve@dkranch.net

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