I showed magarity's horror to Bill (next cube). He says "Normalization level -1".

   Philip

As near as I can tell, the connection (SQL Agent or the query analyzer window) calls xp_sqlmaint, it does it's internal DLL thing, then tries and fails to connect to...

I think of this as the classic “what the data looks like” vs. “what the data is” situation. I advise thinking of it this way:

1) When SQL is working with...

If yours is the server and your friends' the client box, is the client box (or your friends login thereon) configured to have access rights to the server box? Will...

It's set to mixed.

I heard of a case once where every year "Mr. Database" would add 13 columns to the table, to account for the next twelve months + summary. That was, oh,...

Here's another stretch:

KeyVal   int    not null    IDENTITY(100000,1).

This would give you integer values of

   100001

   100002

   100003

   100004

   100005

and so forth. Convert to strong, lop off the first character with

    substring(cast(KeyVal as...

If I ever had to design a (sub)system like this, I'd maybe try to do something like "public" and "private" procedures:

 - The public ones are the interface to the outside world, and...

SET DATEFORMAT is what you're looking for--read the (sparse) details in BOL. This lets you change the date format "used" by the current connection. There's probably a server-wide date format...

Two more cents from left field:

1) A three-tier (or "N tier"?) technology can address this. You toss in a layer in the middle; the user interface (top tier, web browsers)...

I was just comparing notes and lambasting Microsoft some. And if one of the brave few who points out just what emperor XML is actually wearing wants to criticise me,...

nileshsane,

My understanding is that the only "physical" difference between Developer and Enterprise editions is the "Edition" value you get from @@Version and the like. ("Logical" differences include price and limitations...

In general, all that SQL Server has to differentiate once user from another is the login. If N different individuals connect to SQL Server and they all use the same login...

Adding another step to your backup job to perform the move might work as well. If I have it right:

 - You're creating t-log backups every 11 minutes [11? 10, 12, and...

Sound very convoluted... and like most things of that ilk, next to impossible to sort out after (worse, days after) the fact. It sounds like the deleted registry keys were...