No worries, and feel free to debate it in another thread. I'd like to try and keep this more on the topic of long hours, or avoiding them. Please feel...

Just be careful you aren't using any alias like

select as.*

from AppleSales [as]

You need a WHERE clause.

select x

from mytable

where somedate > @begdate and somedate < @enddate

Yes, you don't use TRUNCATE in 2008. Just set to simple mode.

Lowell's summarized things well. You need a parsing application to strip out the HTML and get the data.

SAN snapshots are good for speed, if you need to quickly debug things. We used to use them to get Customer support people a quick look at a current db,...

Pizza/bike shop, interesting. I'd come by!

I always wanted a book store/coffee shop, though having a liquor license at night would be fun.

Interesting. I'd be curious if 6 worked better. If I remember, 5 was a big change, but if you want someone to help you dig through the issue, I can...

A device or client CAL should give you the right to install client tools, but if you are unsure, call MS licensing and ask.

Good luck. If you figure out what happened, or use code to clean things up, post back. I'm sure someone else will need the help later

In the other thread.

http://www.sqlservercentral.com/Forums/Topic929745-359-1.aspx

What I would do is get the scripts of all your objects. I assume you have these in source control, but you could generate a script using SSMS that has...

Completely understand. Try tracing things down. I have had similar issues in the past with master/target servers in SQL 2000 and had to update system tables to clean things up.

What...

I'm not sure what you can do legally against companies just hiring people overseas. What you'll get is the movement more wholesale of work overseas. The company will open an...

Use a cursor to encrypt things, but if these people are copying your code, they could probably decrypt them quickly.

What you are doing with the lawyer is right, but...