Try going into your query analyzer and run sp_helpdevice against both you master and user db's.

I'll make a guess that SQL has/had attached your file(s) as a device. Therefore the...

My guess is that the DB went to single-user mode after the log/disk was full.

There are 2 ways to correct for this if the database is in full recovery mode...

Have you checked if the indexes are still there?

Also have you tried running EXEC sp_updatestats against the database?

Try something like this:

UPDATE TABLE_A TA
Set TA.op_datetime = (select TB.op_datetime
                    ...

IMHO, I would say that you should create a third "control" database. In the control database have a list of the required tables in the sub-database(s). Also include tables to...

I would suggest that you (or your network people) take a look at the TCP/IP settings, especially subnet masks, along with the DNS/DHCP, and if any routers/switches/hubs are blocking it...

That's all there is to it.

Check the BOL for "SET QUOTED_IDENTIFIER" as in:

When SET QUOTED_IDENTIFIER is OFF (default), literal strings in
expressions can be delimited by single or double quotation marks. If a
literal string is...

You need to change the SortId col to an Identity column with an increment of 1.

/** This assumes that the Table1 consists of

Conf_Num, Purch_Last_Name, ID_Col

and that you building the confirmation number from the same table. **/

CREATE TRIGGER Add_Confirmation_Num
 ON Table1
FOR UPDATE
AS IF INSERT...

I think (someone else jump in here) that if you create the userid in SQL and give them db_DataReader & db_DenyDataWriter and don't give them any other roles/permissions it should...

I know this is late in reply.....but I'm running into this problem now and found this old post.

One of the catches in

ALTER DATABASE %dbname% 
    ...

And if you want to be really sure, you can even go as far as naming the server such as

...

.

Note that if you are doing a link to a...

Just do a complete backup. Or is this DB that huge?

It will ask you where you want to backup and what filename.

I saw your post "Availability of SQL server when backup runs".

I have my maint plans do them daily, but do not check them to run before backups. They will...