Thanks Paul , can you please tell me why these error has come , secondly how much data will be lost . I check the last backup that is also...

Hi ,

My database on running DBCC checkDB with noinfomsg , shows me the below error , please help what next to do ....

Msg 8928, Level 16, State 1, Line 2

Object...

I was looking at your problem and what i found out was heavy utilization of the server . Here is something from pinal dev and Amit Pandey , please see...

Try

SELECT Replace(REplace(REplace(Phone_number,'(',''),')','.'),'-','.')

It will solve your replace issue of Phone_number

First you need to check your database consistency and allocation , run DBCC CheckDB command for the particular database and do post what it shows.

Regards

Ashish Gupta

HI Gail , Thanks for the reply,

Msg 211, Level 23, State 51, Line 1

Possible schema corruption. Run DBCC CHECKCATALOG.

Msg 0, Level 20, State 0, Line 0

A severe error occurred...

Hi , Me too facing the same error , have tried everything , DBCC checkDB shows ""Msg 211, Level 23, State 51, Line 1

Possible schema corruption. Run DBCC CHECKCATALOG.

Msg 0,...

You need to set Database Auditing using DDL trigger in sql server 2005 ...

for checking data (crud operation) you can use a free tool called SSMS TOOLS 7.0...

one small thing what is the log file size and are you using replication (merge) , Do check the server name , some days before faced a problem in a...

Hi,

Dont know these will help or not , but try to create more tempdb database, anyhow that is good on bases of performance issue ... ,Can say just give...

Hi,

it wont be used much and setting clustered index on such column is of use as per mine thought , need to know how your...

Hi , Just select in profiler->event Selection -> TSQL

SQL:STMTStarting , and STMTCompleted.

Regards

Ashish Gupta

Just Execute SP_WHO2 Active and figure out if something is blocking your process, if blocking process is there the check for it using DBCC inputBUFFER(SPID) .

Check for CPU and RAM...

You can open more then one connection , as per i have tested it does not affect much on the resources of sql server, SQL SERVER 2005 by default provides...

Hi ,

Just in profiler go to the column filter and set your objectID , name ,or host whatever is required . you can even create a template if required...