That's an extremely bad idea if the users can...

rajeev_vandakar-782919 (1/8/2010)

---

Oh. I remember, when I worked with SQL 2005 version for first time, (some 2 years before), there was an option in SQL 2005 to restore the database as...

SQL does not log anywhere the execution date of stored procs. You can run a server-side trace or you can add your own tracking to the procs.

I'd be wary about...

If you really do need to get distinct rows out of a table with duplicates, you have few options. Distinct is the most likely one to work. Honestly, I'd look...

In what sense? The word 'truncate' is used in more than one place with more than one meaning.

If you're referring to the transaction log, please read through this -...

Well if you don't, I sure as hell don't know what your problem is or how to help you. I...

I don't know what the issue could be with, because, as I said, I see nothing wrong with the errorlog, and there's not really enough info here to work with.

Once...

Because the OP asked a question about syntax from that standard so that he could convert the view...

Restore your last good backup and any transaction log backups you have. Once you've done that, do some root-cause analysis. Look in the event logs for hardware (specifically IO) related...

There are no errors in that list of messages. That's just SQL's startup routine.

Can you open query analyser and try to query one of those databases?

Error message please, and a more detailed description of what, exactly, you did.

Only if it's holding locks. That's the SQL definition of 'using a table'. Check sys.dm_tran_locks. Also, if you know what application name it's set (if it has set one) you...

Books Online does. Look for an example of moving TempDB. Same script works for user database. You just have to take offline and move files afterwards

Reminds me of an incident...

Also, you said Process1 is an executable. Does it open its own connections to the database server? If so, any locks acquired will have to be acquired by the executable...