You code sample doesn't make sense to me. Begin try / end try are not always matched.

Try indenting your code, so that it flows naturally even from a "visual" standpoint.

BEGIN...

SQL_By_Chance (10/12/2011)

Gina, Can you please post me a Template for...

I know it's not exactly what you asked for, but I guess you are trying to do something that this stored procedure[/url] could solve quite easily.

C'mon guys, get back from the Summit!

The Thread is abnormally quiet without you.

Yep.

You don't need the USE statement:

CREATE PROC xyz

AS

BEGIN

DECLARE @sql NVARCHAR (100) = 'select db_name()'

DECLARE @dbname VARCHAR (100) = 'tempdb'

DECLARE @finalsql NVARCHAR(MAX) = @dbname + N'.dbo.sp_executesql @sql'

EXEC sp_executesql @finalsql,N'@sql...

Probably because you didn't set up database mail correctly and the trigger fails to execute.

Short answer: it can't...

What I posted is a DDL trigger, which is a trigger that captures DDL changes instead of data changes.

Whenever a new database is created, the trigger will fire and run...

Darn! I don't know why, but I checked "has a different value on each row".

Nice question, Tom.

You could create a DDL trigger for CREATE_DATABASE events and send a db mail with code similar to this:

CREATE TRIGGER databaseCreated

ON ALL SERVER

FOR CREATE_DATABASE

AS

BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'profile',

@recipients...

When posting a question you should provide:

A) Table definition

B) Sample data

C) Expected output based on sample data

You (sort-of) provided A and B: now we need C to be able to...

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1189017.aspx

Not exactly what you're asking for, but could be a starting point: http://sqlbackupandftp.com/

You can use my stored procedure code template from here[/url] and add the insert statements where you find "insert code here".

Given that you have a linked server in place for...