Thanks for that.

You know, this code was submitted over 4 years ago. SQLServerCentral just published it again. 🙂

I'll correct this one and others I've submitted a few years ago...

Hi! Thanks for the info. Just had to remove the parenthesis on both sp_executesql statements. I've uploaded the correction.

Let me know if you'te all set. 🙂

Run it in query analyzer, or management studio, and browse over to the "messages" tab. Ther you have the DDL.

On your client machine try registering SQL-DMO dlls:

regsvr32 atl.dll

regsvr32 sqldmo.dll

And you're right, of course. I'll edit ASAP.

Thank you 😎

Already covered! 😀

usp_SecurCreation - 2k5[/url]

Hello, sorry for the delay.

Go right ahead, providing you give proper credit. Also, could you send me a link to that article when it's done?

Thank you

PL

Sorry all, i had noticed it and submited it together with the above changes, but forgot to mention them... Change all 'dba_database' with 'msdb' until the edited version is approved...

Looks like some of the indentation i made in the online editor when submiting broke the script. I resubmited it.

Look for:

SELECT @datestr = CONVERT(NVARCHAR(4), @year) + N''-'' +

CONVERT(NVARCHAR(2), @month)...