If you are using a VB application, then there is no need to use xp_cmdshell for this.

Did you test with telnet?

http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Your error indicates it's using named pipes and not TCP/IP. When you used IPAddress,PortNumber did you get a different error?

You don't need to use xp_cmdshell for this. Just run DBCC CHECKDB directly inside a query window in SSMS and select the option to output it to a file.

Or...

I don't think a DMV is going to help you. You'd have to query for the traces via fn_trace_gettable.

How often is your system hitting this high of CPU? ...

Dynamic SQL doesn't run in the same context as the trigger, so that's why it doesn't exist.

Why are you trying to do it this way? What is...

Where are you getting the 143GB number from? Have you included the free space that exists in each of the 6 files?

Agreed, didn't realize you could do that!

I guess I assumed that the dynamic SQL was being used for something that the OP wasn't showing us.

If you are using strong encryption, then a techie can not decrypt it.

There is no way to prevent users from connecting via Query Analyzer or any similar query...

Let's not go too far yet. I'm wondering if you need to replicate delete statements. If a delete happens at the publisher, do you need that same delete...

I would suspect that's the case for small companies that need more of a jack of all trades type person as they can't afford specialized people. But in large...

Yeah I see that now. I thought it was an issue with a table variable.

I think you're going to need to fake it out with OPENQUERY then. Or...

You would do it in the article properties. What I'm wondering though is if you need to replicate delete statements. If you need to, then you can't turn...

Could you turn off replicating deletes?

You need to use a temp table instead of a table variable.