Thank you all for the help and the "Captain Obvious" fly-by :-D. I did finally get some of it back and advised that backups and upgrades are the best options....

Hello again! I agree, using Linq with stored procedures, I believe would work quite nicely. I have no objection to that at all. I was only concerned regarding the request...

Hello, thank you all. To answer a couple of the comments: For the most part developers do NOT have access to the production environment and those that do, I am...

hello, thank you for the link. I had already read that article, but a second read is always good too.

I can feel a rant coming on 🙂

OK. So Microsoft...

Thank you! I am much clearer now on what is going to work. And I will watch for those tables that need more security and move them out of the...

Hello, I agree. I will evaluate my needs. Unfortunately I inherited this "thing" and am finally getting to review the non existent security on it and replace it with something...

Good Morning:

Ok, I read the articles you posted. I have one issue. In the article: http://www.databasejournal.com/features/mssql/article.php/10894_2246271_2/Managing-Users-Permissions-on-SQL-Server.htm

there was the following statement:

The DENY statement is used to deny a permission...

I will do as you suggest! And review the articles and your example and apply. Thank you for your assistance. Hopefully I have it all straight.

Hello again, and thank you for your reply. I see your point, however, there are also recommendations that data should only be accessible to users via parameterized stored procedures and...

Hello again 🙂 Some of them are hardcoded strings and others are coming from the database. However, I think I have found at least a temporary fix. I am testing...

Thanks for the quick reply. Yes, this is a script that is running through SSMS, however, the variable will truncate at 4000 and THEN it continues to pick up the...

The article may be short and short on detail, however, the really good thing was that it lead me to this discussion and the links here. Thank you!:-)

thank you everyone for your replies!! we are using the snapshot replication that is then distributed (is that the correct word?) to another database on another server. We have a...

thank you for your reply..i suspected, but was wishing. Is there anyway (i am not a dba, nor do i know much about replication), to find out why the snapshot...