Search results for query: *

Hi folks, I wanted to implement a policy at our workplace where users cannot submit a select query directly but should execute a procedure with the query text as parameter and the procedure in turn will execute the query. The users should be denied all rights except to execute this procedure...

I was wondering if one could configure a specific user to have a specific transaction isolation level as default whenever the user logs in. For example, if I have 5 logins (say A,B,C,D & E). Logins A,B,C &D have Insert/Update/Delete rights whereas login E has only read permissions on tables...

I was reading through a problem where it was required that one should be able to find out whether some triggers are enabled or disabled. The suggested solution was to do a bitwise and of status field of sysobjects (with 2048 - 12th bit should be on) for record type = 'TR'. Now that will require...

Hi, We are on SQL 7 and have been facing a peculiar problem. We have a table which contains approx .5 million records. We perform all 3 kinds of operation on the table Insert/Update and Delete but the steady state size is .5 million records only. As per the table size calculations, it should...

I have a code something like this for li_ctr = 1 to dw_0.RowCount() dw_0.object.dw_1[li_ctr].object.cust_cd.Background.Color = '255 ~t If('+string(65000 - li_ctr*4000)+' > 60000, 255, 0)' dw_0.object.dw_1[li_ctr].object.cust_cd.Background.Mode = 0 next dw_1 is a nested report object (in...