not sure if it's applicable, as I'm not sure of the specific error you were getting, but you have a logging table dbo.changelog;;

your trigger could potentially fail if the...

Yes, The example I provided is probably more oriented to developers who need a proof of concept, and the ability to test.

You wouldn't use GMail in a corporate environment, youd...

definitely Gmail is possible, and very handy for forum examples here too!

here's a screenshot of my working Gmail settings for database mail to use as a model:

I've been haunting this place a while, and i never tripped...

I have an amazingly similar HTML report for all objects in a given database.

here's a link to teh sql file, it's kind of long, but creates similar output;

it's based off...

yes, but only with 2008 and above, and i'm not sure if this is an enterprise edition only option. partitioning is certainly Enterrise only, but i think compression is part...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:http://www.sqlservercentral.com/Forums/Topic1214220-392-1.aspx

you'll need to use the object_id instead of db_id at the table level.

why are you not saving the tablename? if you drop and recreate a table, it will ahve the...

see the post i follwoe dup with...if your destination table expects an int instead of the database name, you had to wrap it with db_id(''?'') instead of ''?''

you've never...

can we see the bcp command?

lets try to eliminate the simple things, like calling the proc without specifying the database.schema.procname, is it?

could a copy of the proc exist in the...

you just have to modify the script a bit: db_id() function , and 'll let you add your own WHERE statement to skip master/tempdb/model/msdb:

sp_MSForEachDB 'INSERT INTO SpecificDatabase.dbo.DBTables

( DatabaseID ,

TableName ,

ColumnCount...

it's not obvious.

the post, instead of having spaces, has CHAR(160)(which looks like a space, but isn't) in it, which prevents you from copy/paste/compile

i did a find/replace for you, and...

your snippet has the string hardcoded, isntead of substituting the variable.

something like this is what you are after, i think.

DECLARE @MyFileNametxt varchar(50)

DECLARE @cmd as varchar(1000)

set @MyFileNametxt = 'PASS_ASR_ALL_' + CAST(DATEPART(YYYY,...

with Org(Business_Line)

AS

( SELECT 'Blue' UNION ALL SELECT 'Orange' UNION ALL SELECT 'Others' UNION ALL

SELECT NULL UNION ALL SELECT 'Yellow' UNION ALL SELECT 'Green' UNION ALL

SELECT 'Red' UNION ALL SELECT ''...