Yes I get this error in SQL Server log. I also get the following warring msg.

WARNING: EC 612b94d8, 0 waited 300 sec. on latch 50314bcc. Not a BUF latch.

Thanks...

Thanks Jeff,

The reason for the duplicated data in two tables coz by mistake I have updated that column while removing opostify from it.So I restore the specific data from the backup...

Thanks guys I have came up with the the same issue and ended up to run the server and its agent on the daomain admin account after that its fine.

Thanks...

Hi Karl,

Yes you are right I always take back up when doing any updates for safe side.

And thanks to solve my issue.

I am sure world has still good and helpfull...

Hi Karl,

Its data type is varchar 20.And its index also on same column PK_Items_1_10

I have one more worry, we have also around 40,000 rows in the same column without A, means

12345F.

Will...

Thanks guys I have done that by using temp table ...

Best regards

Zia Khan

Hi Daniela,

I have this query in which I am getting 2 results sets the second result is the compute values for the select statment.And my objective is to create a...

Yeah David,

It give me another set of result but only in QA.When I try to creat a web job for this its showing only the results of my select clause not not...

Hi Andy,

I tried that but the same results coming when I set web asst job.It showing me the select results and only the column name for compute value.

Yeah Ian you are right it was as simple as to forget, now I can get my data using between clause.e.g

tablename = mytransaction

columnname = date

datatype = datetime

select * from mytransaction...

We are connecting the server through ODBC and using a prog in dephy language for end user  to access to the server.

Any help will be greatly appriciated.

Thanks

Hi,

Rename the old data files for the suspeted DB and delete the suspected DB then create new DB with the same name.New DB will create the new data files for...

Hi,

I tried

SELECT * FROM OPENQUERY(metrosql, 'Exec metrofiledb.dbo.SP_opsstats')opsstats

but it came the below error msg

Could not process object 'Exec metrofiledb.dbo.SP_opsstats'. The OLE DB provider 'SQLOLEDB' indicates that the object has no...

Hi All,

I have 2 servers.

1) sqlbackup

2) metrosql

Both have same database and all the tabels and sp are same on both side.

I want to make a linke server which I have...

I tried that command and it gives me all the file numbers with small f.If i want to update the filenumber by upper case F,it is going through all the...