Many thanks for the great, concise introduction to SSIS Andy!

I've inhereted a very complex operation with tons of existing SSIS packages. While I have had a little bit of...

I hadn't realized that all of the components of these SSIS packages were XML files...I thought only the designer-related jazz was kept in XML. I guess I've got some...

Different spots each time it fails.

I learned in examing a function call that is being used to generate a CustOrderNumber, that the function call refers to db called 'PortalReports'. ...

Hmmm...

I began working on your first suggested solution G, and I created a view against the LK_Users and LK_UserAuth tables.

But when I considered how I had to address the creation...

Thanks for the response G.

uh-oh...if you are out of answers on how to do this,then I'm hosed...

I was thinking that I might be able to get away with some...

We use it for very low-level permission checking. Every object has a bit-mask with permission levels of READ/WRITE/CREATE/DELETE/ASSOCIATE established as numerical values equating to a specific bit.

The T-SQL stored...

In trying to use this article to tailor a solution for my organization, I have encountered a bit of a snag.

Our "user" information is kept in two tables which we...

I'm not sure what you are asking for Sanjay.

We've got all of the pieces working in production now to store and retrieve FILESTREAM data into and out of the database.

A...

Adam,

Thank you very much for this article. I have been searching around for a more intelligent way to handle massive, bulk-loaded datasets of user information. We have customers...

Many thanks for the tips and pointers STurner!

Defining the #temp table as a table variable instead did the trick!

Here is the snippet of modified T-SQL code from my Check_User_Permission( )...

Yep...I'm looking into that right now. I haven't created a table variable before, so I've got to do some homework first.

...and the code runs on the SQL...

Yeah Ralph, I wondered about that too, but apparently it works between SQL Server 2008 R2 Enterprise edition and SQL Server 2008 R2 Data Center edition. It has allowed...

It looks like setting the Mirror configuration to use the "sa" account under the service account settings in the Mirror Wizard seemed to do the trick. I believe that...

I live in Houston. There isn't any public transportation to speak of... When I took my current job, I knew that it would be a 25 mile commute...

Many thanks for your advice folks!

Steve: Your response just begs this question: What is the difference between DENY and REVOKE then?