CORRECTION:

In trying to simplify the code down, I left out some stuff, but you should have been able to work it out, but for completeness sake, here is the correct...

You obviously haven't met Jeff...

What is your trigger doing that makes it require CLR over standard TSQL? Triggers in TSQL can be problemattic enough for performance and troubleshooting problems, and often are not...

The best reference for answering your question is the BOL topics for each of them:

OPENROWSET

http://msdn.microsoft.com/en-us/library/ms190312.aspx

OPENDATASOURCE

http://msdn.microsoft.com/en-us/library/ms179856.aspx

From personal experience OPENROWSET can do what OPENDATASOURCE can, but it can also read text files...

Here is a VbScript I have used a number of times with great success:

How to Get the Scripts for SQL Server Objects - SQLServerCentral

Your first step would be to query the DMV mentioned above, and see what is in the cache. Another thing would be to look at what activity might be...

Generally speaking you would have a VPN connection that allows you to securely connect to the remote network which would then allow you to access the server using a remote...

This is letting you know that the C drive which is where your Windows Page file is located is running high utilization that is not associated with the Page file...

That can be one sign of memory pressure, but it could also be a sign of a ad-hoc workload where parametrization is not being used in the queries submitted to...

jmuldoon (4/15/2009)

---

Admittedly, the encryption in Sql2000 was very easy to break for most programmer types, but I believe that I've read that MS made this encryption much better in 2005...

Your biggest problem is that you have misused SQLCLR here. This is a standard TSQL stored procedure operation since you are doing a simple update using TSQL anyway. ...

latina.washington (3/3/2009)

---

I have a similar question as already asked...the code that is included, does it have to be executed within the master database? Can the assembly/key generation be done...

Steve Jones - Editor (3/6/2009)

---

For those of you that have asked questions of Jonathan (the author), be aware that he went to Marine Corps Boot Camp last week as part...

UMG Developer (3/3/2009)

---

How about a SQLCLR method to execute a DTS or SSIS package on the server instead of using xp_cmdshell and calling DTEXEC.EXE? (Or is there another way to...

jmanly (3/5/2009)

---

I currently use xp_cmdshell to help with dynamic restores, where a common backup directory (on a file server on the network) is passed to a restore stored procedure and...