I'm a database guy and don't work on the client side, so my knowledge is thin on exactly what products that are out there. I guess could google around, but...

First of all, you should think twice if this is something you really should do in the database. This is for presentional matters, so the presentation layer is the best...

I'm tempted to say that none of them are good. If you really have reason to put this exceptional command in a stored procedure, you should add a comment that...

To be able to help you further we need more information. Here is a question that you need to find the answer to: Say that is is not possible to...

If you run

xp_cmdshell 'TIME /T'

what do you see?

Have you tried restarting SQL Server?

For a question like this, you help yourself quite a bit if you post CREATE TABLE statements for your table(s), INSERT statements with sample data and the desired result from...

Basically anytime when a new record  is inserted into the specific table\column , it grab the record  and bring it over in some way for use in another system.

we...

Yes, you can create an INSTEAD OF trigger on a view. That is, a trigger that fires if an INSERT statement (or which action the view is defined) attempted on...

I don't think dropping the queue helps. Rather it makes things worse.

But the best start may be to ask around. There must be someone who knows what this database is...

If Service Broker is disabled, does anyone care about the conversations? If memory serves, you can do ALTER DATABASE db SET NEW_BROKER and it will clear up everything. And I...

<li style="list-style-type: none;">

1. Set up a stored procedure to produce the output that you want to send to the the other machine in a file.

<li style="list-style-type: none;">

...

I'm not particularly good at XSDs, but as I understand it there...

But, OK, if you open the shaft to the hammer, there is actually a screwdriver inside. That is, if you really want to do this inside SQL Server, you can...

But that still leaves the issue at the receiving end: SQLServer can READ files, can it not? The problem there is it needs to be fully dynamic. I could...

And SQL Server cannot write files.

You can escape to the command line to call programs that write files, but don't you hear how akward that sounds? You could just as...