So the user object is a group and not an individual user? By any chance do they have a secondary login which is just their user account.

What edition of SQL server?

2012 runs SQL Data Tools which is built on VS20120

2008+R2 runs BIDS2008 which is built on VS2008

2005 runs BIDS2005 which is built on VS2005

I always ensure...

Whats the default schema of the user?

If its the username that would be why as it creates everything under that context unless you tell it otherwise. A simple change...

Wait for the transaction to finish.

The datasource is missing a username and password to connect to SQL as. If it is not provided in the data source it trys to use the unattended execution...

There is an active transaction going on in MSDB.

Jobs updating sysjob..... tables, database mail updating sysmail.... tables etc, could be a whole range of things.

The easier option might be to go down the sp_send_dbmail route, as a mail task in SSIS will require you to export the data to a file, then attach the...

Yes looks fine to me.

Sounds like a running totals solution

http://www.sqlservercentral.com/articles/T-SQL/68467/

Look sp_addrolemember for script way of doing it

Or just use SSMS to alter the user in the security folder and grant db_owner on the user in the database,

But are you...

What should be the outcome of the query?

Thanks Lowell, one to add to the tool repository, will take a look at them.

Just tested this and cant get it to pop up the new job dialog box, it always opens the Job Properties for that particular job.

You have to remember that to...

It will be the data from the table where ever the two columns live, more than likely AXV5_SYSUSERLOG or baanloginshist if you are looping the join back to itself.

If you...

BETWEEN is another way of doing >= and <=

So its instead of

ON

bl.LogDateTime >= CREATEDDATETIME

AND

bl.LogDateTime <= LOGOUTDATETIME

http://msdn.microsoft.com/en-us/library/ms187922.aspx