Hi,

Normal domain user Id does not able to browsing SSRS Report at clinet machine. that same domain user Id added into Administrator group at server side after that domain...

1. “SQLServer2008ReportingServiceWebServiceUser$MachineName$InstanceName” -Local User group not available

2. “SQL2008ReportServerUser$MachineName$InstanceName” - this is available in Local user group. (here I added domain...

Hi ChrisM,

In SQL SERVER 2000.

Blocked process not clear after restarting SQL SERVICES, please tell me what could be reason? once restart the service all transaction will be terminated automatically...

Hi ChrisM, Thanks for your valuable replay..

I should asking s/w Dev team to modify all the procedure based on your suggestion. but all the procedure ( begin transaction and...

SQL server compatibility...

Thanks for reply... Can we possible PK index on other filegroup?

1. Total CPU physical and logical

4 CPU

2. Total RAM

4GB

3. Total Drives

5...

Thanks for your valuable information. now I understood these configuration between SAN and same physical HD on same server.

one of the production database server as below, already I had done...

Thanks for reply...

1. All the 5 vloumes on created same 6 physical disk and single Array controler RAID 5, on same server

2. Not attached in SAN storage box.

rgds

ananda

Thanks GilaMonster for reply...

I received call from one of the client site, they did delete huge records for last 3 yrs records. It has taken long time for completed transaction....

Hi Ysaias Portes,

Thank you so much, It is working fine....

ananda

Hi,

Thanks for your information, it is very useful.

I' ve found one script for counting total lines of procedure and function but this is not working. please give me any alternative...

Hi yousaf Khan ,

I am not using Trigger based auditing level for each tables.

Just configured 1. Server Level Audit, 2. Database Level Audit only

Server level

--------------

FAILED_LOGIN_GROUP

DATABASE_OBJECT_CHANGE_GROUP

SCHEMA_OBJECT_CHANGE_GROUP

Database Level

--------------

DELETE, INSERT, UPDATE, SELECT, EXECUTE.

Both...

Hi yousaf Khan ,

Thanks for your reply..

Can you suggestion me, Is there maintainence required if once deploy at production database level for purging audit details weekly or monthly basis.?

thanks

ananda

Please tell me, SQL Profiler trace data duration column is Mi.Sec or Sec?

thanks

Thanks for yours reply ....