Viewing 15 posts - 44,431 through 44,445 (of 49,571 total)
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...
September 18, 2008 at 9:48 am
Transcender and MeasureUp are both good. Not cheap though.
September 18, 2008 at 9:45 am
No idea. I never install client tools on a server.
September 18, 2008 at 9:44 am
maheshgilla (9/18/2008)
September 18, 2008 at 9:39 am
vyas (9/18/2008)
If your recovery mode is full/bulk logged theBefore deleting record set database to simple mode
And after deletion is over
set database to full/bulk logged.
And do a...
September 18, 2008 at 6:54 am
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...
September 18, 2008 at 6:53 am
Is the table owned by dbo, or another user?
September 18, 2008 at 6:51 am
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...
September 18, 2008 at 5:56 am
Peter Rijs (9/18/2008)
I'm not sure what is better, as the questions sometimes...
September 18, 2008 at 5:52 am
According to BoL
2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
So, no it will not store 9223372036854775808, as that's 1 higher than the max value allowed.
September 18, 2008 at 5:49 am
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...
September 18, 2008 at 5:46 am
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...
September 18, 2008 at 5:41 am
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
September 18, 2008 at 4:44 am
Please run the following and post the results:
SELECT @@Version
September 18, 2008 at 4:42 am
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.
September 18, 2008 at 4:40 am
Viewing 15 posts - 44,431 through 44,445 (of 49,571 total)