This is an old thread I know but I was looking for the same thing and came across this code which seems to work perfectly.

DECLARE @SQL NVARCHAR(72),

@jobID UNIQUEIDENTIFIER,

@jobName SYSNAME

SET @SQL = 'SET...

Hi

I would have the last step of your monthly job update a table somewhere with a success/failure flag. You can then schedule your other job to run a week later....

Hi

This information isn't stored in any tables or views. You're going to have to setup auditing or a profiler trace for a couple of weeks and see who logs in....

Thanks for the reply.

Forgot to mention though - it's SQL 2000 so copy only is not an option unfortunately.

thanks anyway.

I had to modify it slightly to:

SET @body = REPLACE('file://\\server\share with a space in it\', ' ', '%20')

This seems to work okay. Not sure why the first way worked for...

Hi Wilfred

SET @body = REPLACE('\\server\share with a space in it\', ' ', '%20')

EXEC msdb.dbo.sp_send_dbmail

@profile_name = @profile,

@recipients = @recipients,

@subject = 'Test',

@body = @body

The path now renders correctly but the link doesn't...

You can run the script straight into 2005 and it will produce drop and create statements for you. The drop statements should work straight away. The create statements may need...

This is the script that I use and it does most things for you.

http://www.databasejournal.com/scripts/article.php/1501031/spIndexKeyTextsql.htm

create the stored procedure in the database in question and then run:

"sp_IndexKeyText 26" to generate...

Generally there's no issue having different collations on your system database unless you're running queries between them and differently collated user databases. This usually comes about as a result of...

Same with me - anytime I need to change collations I have to drop all the indexes and constraints first and then recreate them afterwards. If you have a lot...

Watch out if you're using SSIS as well, as by default this will not be clustered and when you fail over to the second node packages will not execute from...

Hi

Thanks for your reply. Yes, I know of the deployment utility. Unfortunately my 20 packages are only stored in MSDB on the server. I do not have a BIDS solution...

Thank you. I've just successfully run a package with Integration Services installed but not running.

To me this seems a rather simple but effective solution to the problem of SSIS not...

Thanks for the replies guys and thank you for giving a prime example of my problem.

First reply:

"The SSIS service is designed to enable the management\monitoring of SSIS packages; it is...

Unfortunately it's the usual story of 3rd party apps still only offering mixed mode authentication. In this case it's one of the market leaders in its field and we've only...