sql2005 64 Bit i had same problem...and i did the

'lock pages in memory' plus i set 8196 for min memory and 50 GIG for Max (only go to your max...

The latest cumulative 6 service pack for SQL 2005.

Im going off memory here but i do recall something that if the license for the SQL is not for say 4 processors and only 2 it will only use...

How do you get the kpid from here? Do you mean sql profiler?

Fire up Perfmon, select the Thread object, % Processor Time counter and all instances of sqlservr. ...

To see the code running you can do right click on servername, reports, standard reports, activity all sessions and then click throught these to get to the SQL Code being...

The software requires this on each laptop.........hmmm

Have you thought of using a CITRIX Farm - we use this and have one version of SQL Studio on here for all...

For SOX Click on server properties, Security and you can do the options...enable c2 audit tracing...this will become very large as it records a lot of details.

Interesting...Tell the department you are a DBA and needs administration rights on the servers....I had same issue they kept taking it away...I told them i have to read every log...

Can't you give them their own DATABASE ?

Totally agree - thats why its really important to ensure security per Groups. We now have one group per each database then even down to role level within the...

That was greatly explained....I got it.

If user is not the dbo they will be mydeveloper.table which is what happens in development then i change this back to dbo.table and tell...

Suppose still trying to understanding. owner vs db_owner

Owner of database (this allows them to do everything like drop db etc).

But adding a user and then giving them db_owner...

For the user do not give any options in the sql logins.

Then on Database set up a Role.

In here you give the tables you want select rights to.

This way they...

For the user do not give any options in the sql logins.

Then on Database set up a Role.

In here you give the tables you want select rights to.

This way they...

We just implementing this in our SQL....that we have AD Groups and people are assigned into this group. This is great saves having tom, dick and jerry in the...