You can have following options:

1. DML Trigger

2. C2 Auditing

3. Profiler to capture the desire DML transactions.

Before implementing the above options you need to understand the objective and find out why...

First of all find out the reason why you need to split the datafile?

One option is you add another datafile and sql server internally manage the same. You can also...

Instead of trying manythings and getting caught. I guess, do not panic and wait till the process rollback.

Check your rollback is not blocked.

Yes Brian(beezell), that was the reason I have opted for 0-24 correct answer. 😀

Hello,

My intention to post this question was to makes things clear.

I do agree 0-25 is correct Answer.

At the time of posting question I have executed

select * from sysmessages where...

Hello Atif,

Here you can find another controversial link which says that severity level of messages between 1 and 25.

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

Yes it's confusing. 🙁

Hello Kienway,

The impect on the production server will be downtime. During this activity nobody will be abot to access the database and Applications running on the respective database won't be...

Hello Grant,

Thank you for pointing event forwarding feature of SQL Server.

Just would like to know is it possible in event forwarding to filter the few or repetative errors or use...

It may not work and might give you the error message like "You can not drop the database XXXX as user are connected to the database."

You need to kill the...

Yes Brandie,

Nice suggestions!!!

It's of no use you are tunning the SPS' where DB designs changes often.

Also I understand that they do not have proper environment like Production, Staging and...

Hello DHeath,

Looks like challenging and time consuming process. If I understand it correctly you are planning a few 1 or two powerful server with SAN storage to remove or reduce...

Hello Kienway,

If your server is not production server just alot fixed memory of 2.0 GB to sql server and check if you are getting the same errors?

NOTE: Restart is required...

Hello Karan,

You need to first narrow down your needs like what you would like to monitor? how would you like to monitor?

There are also third party tool available to monitor...

Make sure blocking do not happen 🙂

Your location is different to resotre the filegroup backup. Check the existing backup location or use move option.