there is a forum post on here somewhere where someone compared explicitly dropping a temp table created inside a proc, vs letting the system destroy it automatically when the...

ok, ASFAIK, ither than memory/disk constraints, there's no...

from my old notes, SQL2000 had these limits. 2005/2008 might be more now.

·UDF can have upto 1023 input parameters, Stored Procedure can have upto 2100 input parameters.

as long as the other instances are also SQL2008 R2, then yes.

the backup is stored in a specific format to teh SQL version; it's not specific to the instance type...

also a valid file name cannot have colons in it('D:\backup\AdventureWorks_22 Nov 2010 19:29:35:003.BAK'), so you need to make sure the string you are building is valid for a filename.

i usually...

if you take a proc, stick it in the master database, and mark it as a system object, then it will use the datasase reference of the calling SQL.(it also...

I believe the target schema is 2008; it worked just fine for me...the object id of my table was actually exactly the same as the article.

in 2005 Express, i get...

malik_nagel (11/21/2010)

---

I have a computer that is NOT a SQL server and that has only ODBC access to an external SQL server. What is the best way to execute...

gotta agree; clean fast code that takes into consideration everything wer've seen so...

depending on the data, for example if it was always N{quote}{three chars}{quote}{Comma}

you might just use STUFF and a tally table to for to the length of the variable

first, it's a creepy requirement to uppercase everything without reviewing the data.

do a backup before you run the results of this query. someone undoubtedly did not think this requirement...

that's work pretty well, except for those rare cases when a variable between quotes ends...

IMHO, it depends on the syntax you are more familiar with to soften the learning curve.

.

learning a "new" language is really more about two things: learning the basic syntax, and...

wow, that was my best guess, As I'm on a listserv for Watin(Web Application Testing in .NET...IE/firefox browser automation)

i don't have IE8 at work, but this website has a ton of screenshots that might help;

:

http://blogs.msdn.com/b/ie/archive/2008/08/27/introducing-compatibility-view.aspx