What is the output of this code (change the database name):SELECT state_desc
FROM sys.databases
where name = 'DatabaseName'
Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate
Forum Etiquette: How to post data/code on a forum to get the best help[/url]