Does the Cognos catalog is using your Login Id?. The error message clearly says that the Login doesn't have access to the Database.

Ther server where it ran with out any problem is due to quoted_identifier is set off.

Run SET QUOTED_IDENTIFIER OFF before running your query.

The DB will not be in recovery state even though if you restart the services.

DTS is not supported in 64 bit. Check the below link to open the DTS in 32 bit mode

http://msdn.microsoft.com/en-us/library/bb500440.aspx

Is your Server is configured to mixed mode authentication?

Thank you for you replies.

I will try to download ApexSQL Log and will check. Thanks!

Thank you.Great stuff.

Indexes are rebuilt by constructing a new copy of the index and then deleting the old one.

This means that essentially there are two copies of the index for a...

Did not get anything in google.

Try to check the number of open transactions first. Check if there any Long running queries. Run SP_WHO2 Active.

Atul,Schadenfreude-Mei and Jason are right. The time to grow in % takes more time if the database is huge and it leads to performance issues.We use autogrow MB.

Atul is correct. First create the space for the tempdb. Then check for the reason it grown and then try shrink the files during offpeak hours.In the worst case you...

What SQL Server Version you are using?Is it SQL Server 2005. I faced similar in issue in 2005 in one of our production server. I tried to shrink the file...

Retore the database using T-SQL commands. You will learn more if you use T-SQL instead of GUI

One of the member truncated large tables data in one of the environment without intimating the concerned team due to space issues in the server. Team member thought that its...