When migrating databases from SQL Server 2000 to 2005 using backup and restore, How do I verify that auto update statistics is turned on AND it is necessary...

The errors are being posted to the SQL Log as well as the Application Event log. I have no agent jobs running but I did check with the...

The errors are being posted to the SQL Log as well as the Application Event log. I have no agent jobs running but I did check with the...

I checked the Windows authenticated login that is being used to connect to the database.. It is NOT set up to enforce Domain password Policy.

This...

Select @@Version

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2...

on the advanced tab of the select datasource step, I made the first column DT_Data datatype and the rest of the columns DT_STR (50) .. I received the...

Marvin,

I stopped and restarted the instance. it complained alot but it finally came down and back up again. The DB came up suspect but I...

ran the query you posted and it ran successfully but returned NO results.

The database is still in a 'restoring' state. I attempted to rerun the...

the 'stuck in restore' state? will that eventually roll back or is there a way to kill it completely?

Thank you! yes, for day to day operations I need to be able to do point in time recovery so I am in Full recovery mode. ...

any suggestions on this? Full recovery with frequent TLOG backups? Bulk logged recovery mode? simple?

and sqlservercentral.com

quick follow up question..

I have SQL Server 2005 Enterprise edition on a Windows 32bit Advanced Server 2003.

I recently added 12 GB to the Server bringing the memory...

There are 3 triggers but I cannot view them because the application vendor has them encrypted!

Thanks everyone. I poked around and found a generate script option under tasks in Management Studio. Right\Click on the database and choose option\generte script... from...