Jason Selburg (12/6/2007)

Well it's about...

Heh... that makes a pretty cool sounding acronymn, too... "SbS" 😀

Yeaup.... that's...

Thanks for the feedback and...

Heh... lost leader for one or two articles coming up... forgot to mention that in the article... sorry about that.

Does 1.txt exist in the same directory as where you are running the command from? You'd be better off using a full path name or, if not on the...

I'd recommend a separate process to go get the data instead of trying to do reporting through a linked server. Setup a staging area to hold the data locally/temporarily.

It's easier to find missing ID's... this test code shows you how... last paragraph of code is the code that does the work... everything else is just test setup...

--===== Setup...

Go into Enterprise Manager and using the Import/Export capabilites of "Data Transformation Services" to copy the tables with or without data. Will give you the opportunity to copy keys,...

Unless you're using it to make a wholesale change to all the tables in a database, renaming columns in a proc is usually a bad idea...

... why are you renaming...

The problem is that you should not use parenthesis around parameters for stored procedures. 😉

After taking a longer look at this, you could turn it into a stored proc and pass parameters.

Of course it'll slow down during the day... more locks present on the tables and the query must create an execution plan each time the app generates the code... it's...

Ya beat me to it, Ramesh!

Keep in mind that both the estimated and actual execution plans can lie like a rug... if you have any form of a loop in your code or, sometimes, a...