Viewing 15 posts - 1,996 through 2,010 (of 7,498 total)
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...
June 8, 2011 at 2:14 pm
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...
June 8, 2011 at 12:51 pm
if sqlserver is running and the database is open, you cannot delete the file on the operating system.
June 8, 2011 at 6:54 am
Yes
Keep in mind your Witness server doesn't need to be EntEdtn. fwiw it can be an express edtn.
June 7, 2011 at 2:52 pm
mister.magoo (6/7/2011)
ALZDBA (6/7/2011)
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see it...
June 7, 2011 at 2:50 pm
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
June 7, 2011 at 2:45 pm
Digs (6/7/2011)
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...
June 7, 2011 at 1:41 pm
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...
June 7, 2011 at 1:33 pm
SQLRNNR (6/7/2011)
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
Where do you see this watermark?
I get to see it in the...
June 7, 2011 at 1:23 pm
GilaMonster (6/7/2011)
The client-from-hell is no more.
Congratulations !:w00t:
June 7, 2011 at 1:21 pm
What's with the watermark on our SSC ??
Is it webmaster fun, or is SSC changing logo ?
June 7, 2011 at 10:29 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
June 6, 2011 at 5:51 am
It is best to always post your exact question documented with your actual code.
The more actual info we get, the better advise we can give you.
If you would have posted...
June 5, 2011 at 10:55 am
Seems to me to be the way to use a clr fn just to actually use one.
Why don't you use a regular tsql derived column ?
June 5, 2011 at 9:59 am
Once you have the script, you can use SQLCMD to deploy it to all your environments, or if you can group connect to the required instances ( SSMS registered servers...
June 5, 2011 at 9:57 am
Viewing 15 posts - 1,996 through 2,010 (of 7,498 total)