When using the 4 part identifiers, sql query optimizer handles it behind the scenes, so to speak using DTS and passing table results. It's just when using openquery or designing...

I like that!!!!!

I thought of something else. At times when writing files out from SQL, I've encountered issues from spaces and such in the path. By enclosing the full path and filename...

As far as getting the parameters, that's easy, grab the text from the system table containing the stored proc, and using the structure of Create Proc Name param1,param2,param3 AS you...

I use UNC paths all the time to import text files. Your format is fine, and like jaybmehta said, you need the correct permissions to the share. I just wanted...

Since OPENQUERY passes a string through as it does, I don't believe you can get around that part. However, you can do a lot by creating a stored proc on...

No problems that I know of....

The three most widely used tools of reporting from what I've seen, have been Crystal reports (Most widely functional and since version 8.1, getting decent but still a programmer's tool),...

I agree with mromm.

I also would suggest using sp_sqlexec instead of exec if you stay with dynamic sql. It generates a much more reusable execution plan, and has the added...

This is kinda a kludge, but a quick workaround to get something in excel format is to simply write the data as a tab delimited format, and save it with...

I think I agree with mromm. One of my previous jobs was dealing with documents uploaded by end users, converted to adobe pdf, and stored on the system. The end...

Union All works the same in Sql. Just create it using a script rather than the EM, as that's one of the limits of EM.

When you say you script them, have you applied the script to a different server? One without UDT's defined on it already? And it worked?

And when you say,

"Frankly if...

Even though some of us were aware, It's always great to see. In my case, I haven't though of it in years that I can remember. It's not something that's...

I agree with both paulhumphris posts. I've seen the drops in performance myself in particular situations, but with a little work, you can set the level for considering a...