Try the below url:

http://support.microsoft.com/kb/224071

in the above article he mentioned about a trace flag like –c –m T3608.

Here we need to just enable the –T3608 only, not whole –c –m...

I have faced this question in an interview.

let me explain it.....

if we fire a query from QA or any other apllication against a database, first of all where it goes...

🙂

Thanks A Lot,

This topic came accorss to me while I was discussing with my friends, they are working in other technologies, like oracle, mysql etc..

They are able to tell the...

Just for the sake of Knowledge.

Ok, can I know any other applications like SAP which uses SQL Server, and also the companies or organisations using the SQL server.

ok, Thank You,

But I have got a error when I am trying to do modifications on a table when backup of that database is in progress. Error is something like...

I have tried different version of SQL Server 2005. i..e Standard Version but it also failed with the same reason. dont know why I am unable to install.

When I tried...

Looks like whole issue is with SQL Server 2008.

Before installing SQL Server 2008, every thing was working fine and no issues.

Once after installing SQL Server 2008, my IE is not...

Actually I have already installed SQL Server 2005 EE, but due some problems I have uninstalled it and tried to install it again but failing.

Previously I was having SQL Server...

Its Enterprise Edition.

And my OS is Windows XP with SP3.

Actually first I have installed the SQL 2000, 2005 and 2008.

Due to some problems I have uninstalled all of them.

Now I...

I have attached some of the logs here.

I think the only solution is, restart the SQL Server Services. otherwise if you have space in your disk increase the logfile size of tempdb.

Thanks Suresh.

It was due to space issue only.

Yes,

C2 auditing is enabled.

is that the cause for SQL Server shutdown ?

Thank you for your help.

Now I am able to do it.

Thanks For your Help.