sp_detachdb and sp_attachdb don't exist, it should be sp_detach_db and sp_attach_db.

D'OH - seems like I was the 5th or 6th person to make that point - should read the complete...

At my last job where I was the DBA Team Lead, I implemeneted a policy of unique, 12-character random passwords (from Password Safe), but we had a single set of...

To install a new clustered instance, set up a new Cluster Group, with a volume(s) allocated (and properly formatted for SQL, of course), dont add anything else to the Cluster...

So, I'm going to get my point for this - like others have said #3 is WRONG

Select EmpName, DateOfLeaving from Employees order by DateOfLeaving desc, EmpName asc would give you:

EmpName...

Thanks Johan.

I actually got my lazy self to go and do the research, and found this on MSDN

All database mirroring sessions support only one principal server and one mirror...

Thanks Al :smooooth:.

Actually, the app has multiple databases, which are spread across the two instances - its an email archiving app (for legal recovery) that covers that whole of North...

The security concern is the ad-hoc SQL being executed - i.e. not controlled code.

Badly worded question -

How do we define "Same Result" Same result as the other statement? Same result across...

Excellent, thanks.

Thanks Mohammed, at the risk of sounding dumb, is that just the job(s). I dont have access to my work SSMS right now.

This is a doc I had to create for our department recently, about SQL Installation on a cluster (the formatting looks better in Word!!):

---

SQL install on a cluster

This assumes that...

santhu (5/29/2008)

it is basically used as queue servce database..no user table/data resides here, as a result it is difficult to know how data would be there..moreover even i am not...

Thanks AL.

Sorry, it could be construed as misleading. My assumption was that everyone would understand that the discussion was about...

Aleksandr Furman (5/27/2008)

---

About size of nvarchar(max)

I tried this:

declare @C nvarchar(max)

set @C = N'hello' + replicate('-',8000)

print len(@c)

the result was still 4000. Can someone explain why it wasn't...