I have posted this again under SQL Server 2005 Integration Services.

I tried to delete this post, but it is not getting deleted.

RML51 (5/18/2009)

---

I ran the following and it did not enable our alerts for...

Thanks for responding.

I meant number of latencies. Not the time gap.

Many publications cross the 3 minutes threshold that we have set.

They cross the threshold many times in a day.

So...

Run sp_replmonitorchangepublicationthreshold

with @shouldalert = 1

A single Log files is sequential. But what...

Thanks Lynn Pettis for your quick reply.

By default 30 seconds is the threshold.

I have increased it to 3 minutes. Still sometimes I get latency.

Thanks

Hi Jason,

Size of the database need not match. Database has many other objects, not just tables.

Run sp_publication_validation to check.

Suresh

Yes, it is possible, with Database Diagram in SQL Server Management Studio.

Expand the database node. Right click on Database Diagram. Select New Diagram....

Jonathan Kehayias (5/11/2009)

---

There is no doubt that separating your logs and data files is a best practice. However, if you want to know if you are having bottlenecking/performance issues...

RPSql (5/11/2009)

---

read failure on backup device 'E:\Database File\abc.mdf'. Operating system error 23(Data error (cyclic redundancy check).).

quote]

Looks like .MDF file is currupted. Run DBCC CHECKDB.

ami.rstg (5/11/2009)

---

Can anybody provide me sql server 2000 & sql server 2005 enterprise edition CD to install at my laptop or from where I can get it in chennai?

Thx in...

No. Not without upgrading to SQL Server 2005.

Mansoor (5/8/2009)

---

Dear All,

Thanks for giving response.

I am sure that i m using SQL SERVER 2005, and i tryed to executed the scripts also in SQL SERVER 2005.

Ref: You can...

select [name], is_read_committed_snapshot_on,

snapshot_isolation_state, snapshot_isolation_state_desc

from sys.databases;

Jack Corbett (4/15/2009)

---

I think it is unlikely that the shutdown was caused by SQL Server and then SQL Server restarted without issues. Did you check the SQL Server error...