Every company has its own way of handling security for developers. Some are very strict and other very lax. In our case it is very strict. Developers do not have...

insert into @temptab

Select 'Test1', col2, col3 from tableA a

where col7 = Some value

if (@@rowcount = 0)

insert into @temptab

Select 'Test1', tabcol2, Tabcol3 from tableB a

where tabcol7 = Some value

I am not...

You can just check for @@rowcount

That is after the first select (it is actually an insert into the temptable) do a

If @@rowcount = 0

do the next select

I think this...

Take a look at this thread. This could be the issue. you are facing.

I have not seen blocking caused by a select when doing uncommitted reads unless the other stored procs are doing something with the Schema like Gail mentioned. You can still...

They can just be normal users with no high privilege. For example the service account should be a least privileged user in the domain but that user is a SYSAdmin...

Cross post. Please do not reply here. Use this thread instead. http://www.sqlservercentral.com/Forums/Topic1168783-391-1.aspx

As per BOL xp_sendmail "Requires membership in the sysadmin fixed server role, but EXECUTE permissions can be granted to other users. However, for security reasons, we recommend that permissions for...

You should be able to figure out what kind of replication it is by looking at the scripts. Take a look at this blog. It might help you with identifying...

I am not sure what the issue is. What kind of replication? How are you initializing it?

Wish you the very best on your Move to Colorado

awp (9/1/2011)

---

the web application contains fair amount of controls as you suggested, but I guess having a control on the DB gives additional security, for example, in the case of...

If you have control over the front end, why would you even bother giving permission to individual table? You could make all access go through Stored procs and give rights...

With the details you have provided, the best way to do it would be to get rid of the cursor. Like you stated, it is taking way too much time...

It is a start. What I see are complications that can arise at a later point. What happens when a new table is added to the DB that has very...