@carlo: you are right.

But as per the question, we should give answer for the question: What will you get executing this T-SQL code in Query Analizer (SQL2K) or Management...

I have executed the script - output is 1,2, 3, 4.

You can use sp_ExecuteSQL command with parameters that will help to avoid SQL injection as well as SQL Server can reuse the plan. Query engine needs to just replace the...

Good question.

Thanks 'Oleg Netchaev' for query & link.

jimmy.liew - you can use ALTER DATABASE set ... command as a try to back the database Online again. If SQL Server is doing recovery for any reason then you...

You can refer: http://msdn.microsoft.com/en-us/library/ms189799.aspx

praveen.gln1 (12/21/2010)

---

here is my issue

Am Produciton DBA and supporting 150+ servers(prod,DEv,UAT).i want to know about the users and database details who will create new databases on DEV machines.i require this...

can you please post what is the issue & which type of help do you require?

Create trigger related help is available at: http://msdn.microsoft.com/en-us/library/ms189799.aspx

You can use GROUP BY with ROLLUP.

You can refer: http://msdn.microsoft.com/en-us/library/ms177673.aspx

Nice question.

MSDN link for the same: http://msdn.microsoft.com/en-us/library/ms188385(v=SQL.105).aspx

Wildcat (12/17/2010)

---

Hardy21 (12/17/2010)

---

Thanks Henrico. I have already checked this link but this will not work for me....

Thanks Henrico. I have already checked this link but this will not work for me. Because we...

Really nice article, very well written. Thanks.

you can also use SET DATEFORMAT command to set the date format. Once your work is done, reset it whatever it was.

Suppose, your date format is dmy then below command...

Nice article.

I have checked STR() usage in my application but usage is safe because we are not dealing with more than 12 digit number.