whats is CDONTS and it will send query result in mail?

Nice Script ...

I would like to know whats mean of XX in result.

i can not see last week's jobs result . like today tue morning i am running this script...

I was getting error because of timing conflict in sql server with ODBC Driver.

found the solution from http://support.microsoft.com/kb/175313 .

Thanks for reply BTW

This book is good for 70-433 Exam

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 Database Development

HI SQL RNNR

I was testing your script so just want to make sure little thing in result set session_id is the SPID right?

is there possibility with this script...

nice script found useful..

nice script ...amazing result which i want to see it.

thanks

Found this script its really nice.

DECLARE @name VARCHAR(50) -- database name

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @fileName VARCHAR(256) -- filename for backup ...

it works fine..pretty cool

thanks

Really Nice article ..looking forward for more...

good luck..

are you able to install SQL Server in your mac?

If yes which version did u install ? also 32 bit or 64 bit?

db_datareader is granted for only Select

check out this : http://msdn.microsoft.com/en-us/library/ms189612(v=SQL.105).aspx

Hope this helps you..this is nice article about memory usage in sql

http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html

Hi ,

Well only way to extend the date is buy a similar version and update it. There is no way to extend automatically . Or consult to your Manager as...

I am working on same Scenario let me know if you find any good solution...

I have T-sql script that i want to put in SQL Agent Job and i want...