cor_perlee (11/11/2015)

---

When I run

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Rapportage',

@recipients = 'dba@unit4.com',

@query = 'select * from UNIT4_BEHEER.DBO.ClusterActiveNode',

@query_result_header = 0,

@exclude_query_output...

you are missing required parameters, i think.

if you declare a query is going to be attached, you have to have a file name.

EXEC msdb.dbo.sp_send_dbmail @recipients='SQL@SQL.COM',

@subject =...

ok i see what you are talking about now;Test/QA/Prod are all on the same box, it looks like.

let me throw some ideas;

can you modify the temp table to have...

I saw your other thread where your global temp table was intermittently getting dropped....

i would suggest simply creating a real, permanent table. maybe in your production db to avoid permissions...

since it's not physically attached, you have to jump through some hoops.

if you search for "map network drive for all users" you'll see the issue: shared drives ar eper user,...

the script provided just generates the commands, soy uo can review them easily.

you'd want to run the results of the commands, or stick them into a variable as a stack...

is your server clustered?

In that case, SQL can only see shared clustered drives.

if it's a plain old vanilla server, are you using a mapped drive? could the drive mapping be...

chuck i'm not a login on any server, i inherit from a group called mydomain\SQL-DBA, nad my name appears in the results of the script i provided.

you should be able...

it looks to me that you are merging into GiftCard, and not GiftCard_Transactions. the balance does not belong int he Gift Card table.

there's only one card, heck i'd think it...

what you are looking for is a SUM(CASE construct like this:

/*

Cust TotalCount TrueCount FalseCount

Na 2 2 ...

that is correct. there are no tests related to 2008-related certifications to take anymore, but there's it's new successors for the 2012 level platform.

they were superceded and replaced by...

i seem to remember that xp_cmdshell is limited to a single set of double quotes, right?

so "\path with spaces\oldname" "\path with spacesewname" might return an error?

global temp tables still get dropped when there are no more sessions at all, i believe.

from msdn i think, in my notes but not attributed:

a global temp table exists for...

a lot of the time, the GUI might not show you all possible datasets...you sometimes have to "KNOW" that a database exists.

you can run sp_tables_ex in SSMS to get details...

Thanks Anthony! I added that to my snippets; damn i love the teamwork here!