thanks everyone,

I got it ...you can use this in a job to send mail, once database mail is configured in sql 2005!!

use msdb

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'test@test.com',

@body= 'Test Email Body',

@subject = 'Test...

thanks sandy!!

thanks!!

Thanks think I got it 🙂

Here’s a script, for killing a SPIDs against a particular database, here am using BIN as the database.

We have to change the name of...

Thanks think I got it 🙂

Here’s a script, for killing a SPIDs against a particular database, here am using BIN as the database.

We have to change the name of...

Thanks got it 🙂

Here’s a script, for killing a SPIDs against a particular database, here am using BIN as the database.

We have to change the name of the...

Hi,

thanks for the prompt response!

Its a test server, and the users are testing the data. So on a daily basis we need to restore.

From sysprocess? ok...but we just need to...

Hi,

ok thats good idea, but how do you identify the spid against the database and kill it?

Do you have any script for that?

thanks

🙂

Just a tip ::)

When SQL Server is installed the setup program creates tempdb database. Tempdb is a system database used by SQL Server to store temporary tables and temporary stored...

Hi,

I was about to automate a restore process though a job to be scheduled on a daily basis.

But I have a doubt in that, the job would be running...

thanks for the supporting info, let me try..

thanks, Wayne for the valuable information!!

most welcome;)

thank you..got your email and downloaded it..!!

thanks alot! let me search the web. Appreciate if you could also email it to: rinugp@gmail.com..:)