I believe that Yukon is included, but SA is for a time period. Yukon is probably a year away, so if youthink you might want it and SA covers it,...

I'll add this to the list. That's a good one!

We're still looking at this. Requires some coding to get on one page.

We'll get to it. Kind of busy right now, but we should be able to add the last post...

I'm not sure one if better than the other. I like osql or isql since scripting it pretty simple to use and I can always launch outside of another tool...

Are you asking which type of tool or which type of client language? Your questions point to both. The tool wouldn't have a runtime. Unless you are looking for something...

What does the proc do? How is the web server connecting?

I'd ask you "how would you find out?" and see what you said. Personally I think honesty, including "I don't know" is the best policy. I've been doing this for...

maybe change to specifically mention "inner join" in the query?

Not sure, this is a strange one.

you can script the length of fields with len() and then add these all up. In your query, you can use this in the where clause (where len(fielda) + len(fieldb)...

You can change the db owner if you need to. sp_changedbowner.

I'd script out the permissions from the old db and this should run fine on the new db. The scripting...

sysjobhistory.run_status. A 4 indicates it is running.

Good suggestion. We'll see about implementing that.

Prior to VB.NET, I think VFP was the best. I used v1 to rewrite a Fox for Windows app with SQL as the back end and after a year of...

Allen's suggestions are the only way. There really is no other method and SQL does not track this.

I've actually used VMWare as well (http://www.sqlservercentral.com/columnists/sjones/buildingademosystempart3.asp) and it is great. I've got a better solution than that for high end corporations, and one that works extremely well.

Using customer's...