SAT_SQL (7/6/2009)

---

Hi All

as i am new to sql , please let me now weather i can upgrade sql200 to sql2005,

If it is possiable please send some links that ...

Apply the service pack firstly to your dev, test and staging servers. If there is no issue, apply it to the production server.

Applying SP3 needs server reboot. So inform the...

I have run the DBCC CHECKDB. It has not reported any error.

This is happening for tempdb.

Thanks Gail,

You are a genious!

Your solution worked.

Thanks.

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...