Are you in desperate need for coffee 😉

You provided the perfect answer for him...

It was my pleasure to get a first glimps of your article.

This is a lesser known topic, but definately has its place in SQL instance management topics.

Great job !

Please post the full ddl of your object tcsINVTB00026_AttribAsgn

(i.e. script its create statement including all indexes and constraints )

You need to check this constraint 'AK3tcsINVTB00026_AttribAsgn'

Figure out what it is ( obviously a unique key ) and for which column(s) it goes and figure out what is wrong with...

If you mean adding the db name to the result rows ...

SELECT @@servername as ServerName, getdate() - S.login_time as SQLServer_UpDateTime_1900_01_01

, D.name as DbName

FROM sys.dm_exec_sessions S

cross apply sys.databases D

WHERE...

if sqlserver is running and the database is open, you cannot delete the file on the operating system.

Yes

Keep in mind your Witness server doesn't need to be EntEdtn. fwiw it can be an express edtn.

mister.magoo (6/7/2011)

---

ALZDBA (6/7/2011)

---

I get to see it...

apparently you have declared a unique alternate key (i.e. a unique index)

Double check you are checking all your unique constraints (pk/ak) before qualifying a row for insert

Digs (6/7/2011)

---

Hi,

I have two large tables that get updated daily or (added to).

I want to run this TSQL daily.

ALTER INDEX ALL ON DIM_Data REORGANIZE

and

DBCC SHRINKDATABASE (MyDB,10);

Say I have...

That will only work of the errorlog file hasn't been rolled over ( more than your number of kept files )

If your database has "autoclose off" - which I hope...

I get to see it in the...

Congratulations !:w00t:

What's with the watermark on our SSC ??

Is it webmaster fun, or is SSC changing logo ?

Lynn Pettis (6/4/2011)

---

Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.

I am going to be grandfather![/i]

Looks like I'll need...