MSSQLTips

I had a similar problem, and recently submitted an article on row-oriented security using triggers that will appear in sqlservercentral.com in late Feb 2010. This model automatically updates each person's security whenever the data (or filters) used to define that security changes. R Glen Cooper

Thanks for the very informative article on fixed database roles. I'd just like to add that the db_datareader and db_datawriter are generally both required in tandem since virtually no one updates without first selecting data. Also, it would be nice to have a fixed database role for executing procedures...

Brian, I think the use cases for this tip could be significant. I also think this could help to secure many SQL Servers. I know many customers have linked servers across many servers and do not even realize it. They also do not realize what someone can do with them, either intentionally or mistakenly...

If you use Windows security to grant permissions to your databases, how do you then prevent users from accessing the database and its objects when the users use something other than the intended application? For example, let's say you have a custom application and that has a SQL backend. And you...

We are having problem with ASPState database, which have one ASPState_Startup proc which suppose to create 2 temp table in tempdb whenever SQL server start. Somehow this proc does not create those tables. I checked "scan for startup" and it is configured 1, also make sure that "ASPState_Startup"...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

How to write stored procedures in SQL Server? Please Send the Description with examples of stored procedures. How many types of stored procedures are there in SQL Server for INSERT,UPDATE,DELETE? How to call procedures?

what is the diffrence in DBMS and RDBMS?

If you are using standard logins to connect to SQL Server these items are lost when you save and deploy the package. You need to change the settings for the package security level. This can be done on the Properties for the package under Security | ProtectionLevel. One option is to use DontSaveSenstive...

This post is related to this tip: Natively Encrypting Social Security Numbers - SQL Server 2005 http://www.mssqltips.com/tip.asp?tip=1383