I too had a heck of problems with xp_sendmail and the after testing on different servers, I implemented sp_send_cdosysmail on most of the servers and as of now doesnot have...

MANU (5/6/2008)

---

Hi,

I want to track the jobs that are running for more than one hour. Any job which is executing from last one hour needs to send me an alert.

Please...

First I did...

Good example Torsten. Only change ROWTERMINATOR = ' \ n 'should be read without spaces

joseph george (5/6/2008)

---

I have a production 2000 box and a dev 2005 box.Business want t-log shipping to be done between these two boxes.Is it possible?They also want to use the...

Or try this. Add a role something like DTS_RunGroup to msdb database and grant the following permissions to the role:

GRANT EXECUTE ON [dbo].[sp_get_dtsversion] TO [DTS_RunGroup]

GO

GRANT EXECUTE...

kalyan_tkc (5/6/2008)

---

Hi

I need to give permission to a user to just run a dts package(He should not be able to do anything else).

Can somebody tell me whats the best...

Ooops........I didn't see ALZDBA reply. Its doing the...

USE [databasename]

GO

SELECT * INTO trace_table FROM ::fn_trace_gettable ('c:\my_trace.trc', default)

This statement will just load trace file data into trace_table you want.

Right click server properties and then in security -> check SQL Server and windows and select OK.

Basically, change server to mixed authentication mode.

Great question. I always had hard time reading value of NULL's. No wonder I got it wrong today.

I took backup with both compress backup and do not compress backup. I was able to restore database with backup (do not compress backup) with out any issue....

Can some one please post a script, if you have one. Thanks.

Please read other post. Some how this got duplicated. My apologies.

http://thesystemadministrator.com/The_System_Administrator/Knowledge_Base/How_to_move_SQL_Server_databases_to_a_new_location_by_using_Detach_and_Attach_functions_in_SQL_Serve/