caojunhe24 (11/19/2015)

---

everyone has access permission on that folder and if I create a job then will use my account credential to run that job anyway I guess. And like I...

the error is fairly straightforward, tempdb ran out of space.

Typically this is because tempdb auto expanded until it literally fill up the disk is is on.

That assumes you have one...

sounds like every user is in the db_owner role, so that's most likely the issue.

remove all permissions assigned to an existing user, and start fresh.

something like this is what you...

if the script task is counting files on some file share like \\servername\sharename, does the account[MEDASSURANT\BPA_UAT_DS] have access to that share? is that a domain account?

when you run it locally,...

caojunhe24 (11/19/2015)

---

I have a script task in my SSIS package and count file numbers in the folder but always return mecount = 1 even if there is no file placed...

doesn't a modificiation featuring these three constraints satisfy the requirement?

i read "but VhID and PrID can be the same in one row so long as ExtID is different" as unique...

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