No DMV. You may be able to use a 3rd party log reader and read the info from the tran log, but that's not an ideal situation as the transaction...

Transcender and MeasureUp are both good. Not cheap though.

No idea. I never install client tools on a server.

maheshgilla (9/18/2008)

---

Gail Shaw-As it in Production, database is in Full recovery model, we can change it to Simpel while deleting. As you said Second option how can I delete 500,000...

And do a...

That will help if the delete is batched and a checkpoint is run between batches. If the deletes are happening all in one transaction, then the log will still run...

Is the table owned by dbo, or another user?

Via T-SQL or through management studio GUI? If the latter, try it via T-SQL. Management studio may be trying to query the DB before starting the restore.

If via T-SQL, what's...

Peter Rijs (9/18/2008)

---

To my surprise the exam only consisted of single questions, where the SQL 2005 exam had most case studies.

I'm not sure what is better, as the questions sometimes...

According to BoL

So, no it will not store 9223372036854775808, as that's 1 higher than the max value allowed.

Bert's 100% right with the cause. inserted and deleted are only visible in the scope of the trigger, not any procedures called from it or dynamic SQL.

You have another problem...

Check the SQL Server error log, see what it says. There should be reasons written into the log saying why things failed.

The log's just a text file and it's named...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic571477-146-1.aspx

Please run the following and post the results:

SELECT @@Version

Filestream requires that there's a column in the table or type ROWGUIDCOL. The rest of the table (as far as I know) doesn't matter.