Viewing 4 posts - 1 through 4 (of 4 total)
For the record: the problem was with the 3rd party application. I restarted it and the problem is gone. But it's curious that SQL Server throws such error on these...
September 14, 2011 at 8:24 am
I ran into the same error and google brought me here. Just to contribute to the knowledge base: my solution was using three-part name (DATABASE.dbo.TABLE) in all objects referenced in...
September 8, 2011 at 7:23 am
Answered by Herr Uwe Ricken at MSDN with the following script:
DECLARE@stmtnvarchar(255)
DECLAREc CURSOR
FOR
SELECT'ALTER LOGIN ' + QUOTENAME(name) + ' WITH CHECK_POLICY = OFF'
FROMsys.sql_logins
WHEREis_policy_checked = 1 AND
name not LIKE '##%' AND
name !=...
September 2, 2011 at 9:06 am
sys.database_files and SP_SPACEUSED both give me correct numbers.
The error is only is at {right-click on the database in SSMS} -> [tasks] -> [shrink] -> [files]
The numbers there are different.
July 26, 2011 at 1:08 pm
Viewing 4 posts - 1 through 4 (of 4 total)