Thanks Gail Shaw for clarification, its clear my doubts.

GilaMonster (9/30/2010)

---

Yup. You can get the version of a database with this:

DBCC TRACEON(3604)

DBCC DBINFO

DBCC TRACEOFF(3604)

The field of interest is dbi_version. Run that against master on a 2008 instance and the...

I also tried the same but facing same type of issue. One of my machine has Win XP with SQL 2008 R2 - DTS designer is working fine in that...

Though I am right, I lose point 🙁

Nice article and good examples. Thanks

Whenever server face Memory crunch or performance issue then profiler skips some events because they require more resources to trace the event. If you want to capture all the events,...

Thanks for nice article.

But, BOL is also using "sp_detach_db" command to describe attach database command as below:

USE master;

GO

sp_detach_db Archive;

GO

CREATE DATABASE Archive

ON (FILENAME = 'D:\SalesData\archdat1.mdf')...

Good series of questions Nakul. Thanks

SQL Server provides lots of tools to administer the database.

SQL Server also provides facility to take backup with "Compress" option. So backup size is small.

You can take backup in compress...

I would also like to thanks SSC.

I have learned lots of new things from the articles, posts as well as forums posted on the sites.

Nice question and good explanation from Hugo. Thanks 🙂

Nice question. Thanks

If any service is connecting to your database on timely manner than stop that service. Because your database is currently in Single user mode, if that service is connecting the...

Trigger is for Insert operation. This trigger is not...

You have attached SQLPlan as per your old query. Use qualify names in the query and check performance & generate the execution plan.