there are multiple update statements (about 16) in 1 sp all updating the same table but all have different where clauses so cant be completed in 1 update. however at...

It isnt a joke the only option I have is Help when I Right Click on the old Subscriptions. Obviously if it was as simple as a Right Click Delete...

We have tried attaching the database through Enterprise Manager and using Query Analyser sp_attach_single_file_db 'WhatsUp','c:\temp\Whatsup.mdf'

This gives the same error message

Could not open new database 'WhatsUp'. CREATE DATABASE is aborted.

Device...

Hi,

SQL Prompts to create a Log File but when you click on ok it produces the following error message:

Error 1813: Could not open the new database 'WhatsUp' CREATE DATABASE is...

Hi,

I tried removing the ldf but then I get a Device activation error.

Thanks Zara