No, there's no way to do this. The hack would be to call a script that changed the context and executed something. However it would need to be some sort...

SQL server has nothing to do with this. It will send data to whatever disk or tape system that Windows can see. If Windows supports it, SQL will.

The easiest way I think do to this is use something like SQL Compare (or any compare tool) and have it sync the procs in all databases on a regular...

Also, indexes are on tables, not generic in the database. If I have an index on the CustomerID in the Orders table and an index on the CustomerID in the...

I'd keep things the way they are. Then use VBScript (FileSystemObject) or Powershell to find the latest backup (not hard to do, loop files, find last one) and copy that...

Ethics ought to be a core course for everyone.

It is hard to know what you'd do, but you ought to at least document your case, and not go along.

You can have two fields in a primary key, but not two primary keys, as Elliot mentioned.

It also makes me wonder if you understand what you need. Does every table...

Congrats, Josef, and looking forward to giving you the award at the PASS Summit!

Unix has viruses, you don't hear about them as often. The problem is viruses is not a Microsoft issue, it's an OS issue.

R2 keeps things moving forward. I'm not sure...

I think you're confused.

You log in as a user, that's the user you use for execution. That's what clients will use.

If you want to test that user, open another...

C'mon, you won't get tossed......far

I think I said they sometimes do. I'll pick on developers as a group, but they are like DBAs, some good, some bad.

I'm not sure supportability matters here. Most applications...

I have to say I haven't looked at it much. This version is coming too quickly, and it's a lot of BI stuff, which I don't use much (yet)

I'd agree that right now I don't see much difference. I have SS2K8 Dev on both here, can't really tell the difference.

The problem is that someone likely will not find it, or won't read it. Most people just post their question.

I'll look at a page that gathers together some links that...