SQL Express does not include the SQL Agent. it does nto get installed, and that's the reason for the error.

if you need agent, you need either the developer edition(~50 USD...

Powerpoint is a part of it, but its not the conductor for me.

At least in my case, its because only portion of the media is static prior to...

Eirikur no i never did;

i continued working with the vertical scroller in winforms application i had put together into myself, and toggled between powerpoint presentations and my scroller; i never...

mhorner 67968 (11/12/2015)

---

I'm using PowerShell as well but not with the CMS. How does that work? I'd be appreciative of that information and a copy of your script if you...

just installed it, and will report back what i think; very pleased to see a fire and forget solution.

my initial thoughts were that the jobs and schedules should be either...

if you go to http://sqlfiddle.com/ you can create and test a suite of commands, without having SQL installed; it's basically a syntax checker and pass through page that gets you...

could you be misinterpreting object_id as an identity column in sys.objects?

sysobjects get an id based on an increment of some weird number which i didn't remember but could find on...

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...