Andy has the right idea, but why can you not just grant db_owner to a user as a role. This is the same as dbo.

They certainly need to evolve. They've been mismanaged for years, counting on cheap oil, big, expensive cars that they want people to buy every few years, a bad model. Not...

http://www.sqlservercentral.com/articles/Security/freeencryption/1980/

I'm not sure what you mean here. You haven't provided info that would help us write a query. Is this the salesman field? What should the result look like?

Also, why...

Yes and no. SP3 is a rollup of hotfixes, but because of the delays in testing it, there were fixes that got into CU 10 and CU 11 that didn't...

Hey, JOIN was capitalized. That should have been easy. Sounds like perhaps too much egg nog over there before answering the question 😛

Sure. Well, industry might be a strong term, but there sure are lots of used cart lots, parts dealers, insurance companies, etc. 😛

At least this wasn't my question!

I did think it was cute.

Viji, this question is not about permissions to packages, but permissions for a task in a package that needs to execute.

Please start a new thread in this forum for your...

Barry, good idea. I'll add that one in for a few weeks out.

Thanks and enjoy yourself today. No work allowed!

Look for my hat tomorrow!

SP3, CU1 is out, but it's mainly fixes from SP2 CUs 10 and 11 that didn't get into the SP3 rollup.

Thanks and Merry Christmas again to everyone.

And don't execute any last statements. Save them for Friday.

I'm sure Jeff will Airmail you a few, $23 apiece, dry ice included :hehe: