It would help if you could provide sample data in the form of INSERT statements, together with what results you would expect to see based on that data. Also,...

Priyank

Check what permissions have been given to the public role.

John

It's a long time since I used DTS, and I don't even have it installed any more, but I think you can use something called dynamic properties to achieve what...

Ah yes - you're right. If you can't be sure that all names appear in both tables then an inner join won't work.

John

Almost... you need an INNER JOIN on the Name column.

John

This is a simple JOIN and SUM query. Please will you show us what you've tried so far?

John

Be careful about standardising your users in this way. Although it simplifies administration, it's a security risk since it means that giving someone (or something) access to one thing...

Without seeing the script you used in your job, it's difficult to comment.

John

Group by CartesisRU, CartesisBU and HFMEntity and use a HAVING clause.

John

OK, you've got an NTFS permission issue. You need to make sure your SQL Server and SQL Server Agent account have read-write access to that folder on your X...

Dan

Although I suspect it won't make any difference to performance, I don't think you need the ISNULL, since SUM ignores NULLs.

John

You're quite right - I said active-passive but I meant to say active-active. I'll amend my...

Be aware that if you go active-active then your licensing costs double, since you have to pay for a licence for each node that SQL Server runs on.

John

Putting performance aside for a moment, creating a separate instance for Sharepoint would provide a couple of benefits. The first is that you can perform maintenance on your Sharepoint...

You can use the Derived Column transformation.

John