Execute the rollback statement a few times until you get a message

The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

Being as SQl DBA is a high paying career . However becoming one is not easy.

I know that right now SQL DBA's are really hot , cause I keep getting...

I would first connect to the database engine and view the tables which were created as part of the ROLAP cube. If you open BIDS you should be able to...

Might want to add the state_desc & recovery model to the above list as well.

select * from sys.sysaltfiles

Gives you the size per database

http://msdn.microsoft.com/en-us/library/bb964743.aspx

Shows you how to execute...

First things first , who ever is preventing you from creating indexes need to be educated. Frankly you can do more damage writing a bad SQL query than by creating...

+1

In your example DISTINCT is used as a check to make sure that the output returns only a unique result , I have seen code where developers have put...

As a rule never bank of the advice of even a GURU without first trying it out yourself. Nobody know what your trying to achieve better than yourself. The rest...

I dont think there is something out of the box which will allow you to do this. You might want to use some kind of filewatcher application and use it...

Good luck with writing your own tool , MSSQL already has SMO which will help make your job easier.

The where clause applies to the underlying tables first the union happens only after that.

the order goes something like

Table scan or index seek with where clause

Merge the results...

Another option would be to rstore your backup on another instances and run a db compare tool. this would show differences in your current database vs the objects in the...

I am tempted to say yes because the spid -2 means its an orphaned process and the application needs to create a new connection anyway.

BinaryDigit (8/18/2011)

---

Sorry, What I'm looking to do (if it's possible) is to read through the transaction logs and get all the sql that is executed to create the specific log.

In...

your post is very vague and I think the terms your using do not actually reflect what your looking for.

By Log do you mean the transaction log or the event...

look up Ceiling and FLOORand get creative.