Depends how segregated you need the data to be, but most of those situations are using multiple instances of SQL.  One per customer.

I would be inclined to use Profiler for this.  I think that would be the fastest way you can get this set up, and normally these type of situation getting...

Just what I was looking for today!  SOOO simple when you know how!

I've not seen this error since I went from RTM to SP2

Sounds strange, not run into that one before.  Have you tried to update the statistics on the child table after the delete of the records in it but before you...

I'm actually having Toshiba come and repair my TV this Friday!  So I guess even the TV repairman is still around.  And yes, I was shocked when they told me...

It depends...

sorry, someone had to say it.

I started out as a farm hand (growing up on a farm, but got paid for all the work, last couple of years in...

I can definatly see a need for them, but I also think they need to be clearly defined before you look at a background check what will disqualify a person.

I...

I don't see you putting the record into a variable when you do fetch next.

i.e. Fetch Next from cursorname into @Variable

Your cursor itself will only have the distinct months in...

I just checked with SQLSentry, you can do the following with it regarding missed jobs:

Notify you abuot missed runs

And "Run missed" jobs when connection is offline. 

I've had similar problem in the past and solved it by writing my own.  Basically what I did was assemble a list of "must run jobs" that I scanned and...

Look up xp_cmdshell in Books Online.

For UNC:

http://compnetworking.about.com/od/windowsnetworking/l/bldef_unc.htm

Could use a trigger too, although not sure I would recommend it...

create

table t (

C1 int...

UNC names work great.

\\servername\share\exename.exe

Permissions need to be set appropriately for that share.

There are a multitude of books on the subject of writing queries.  But for a start use the Books Online that comes with SQL, for all it;s faults it is...