GilaMonster (12/8/2008)

---

herbiechin (12/8/2008)

---

It appears the action completes, but I get a list of errors. I have ran a checkdb (on the safe side) on the entire database and it...

Hi Perry,

As I said in my last post, I have run a DBCC CHECKDB on the entire database (just in case). It came back clean.

In more or less the same situation, I am trying to restore a backup of a database that was taken in SQL Server 2000 (Instance) onto SQL Server 2005. It...

Leo (10/16/2008)

---

Hi Gila,

According from 'dbcc checkdb (dbname) with no_infomsgs.' , you said run

that command before backup run. But my questions is, what do we do if I already setup a...

I agree with James - in fact will go beyond, I always make it a habit of naming the default constraints as this will help me a great deal in tracking them down...

Currently YES - same server but this can be moved to another server.

How could this change the situation? I thought keeping them on the same server will minimise network bottleneck...

Greg is correct - I would disable any constraints and triggers on the destination db before moving the all data/objects/SPs/views. Below is a starting point where you will need to...

SQL Server automatically rebuilds existing nonclustered indexes when any of the following occurs:

-An existing clustered index is dropped using the DROP INDEX statement.

-A clustered index is created.

-The...

HI,

I totally agree with Antares and Coach James - it is the programmers department to sort this out. I have a very similar situation with Sybase EAServer application where connections...

Hi,

I have recently installed Microsoft Backoffice 4.5 for some other reasons and believe to have come across one of the bundled "tool" in a form of an Excel spreadsheet which...

Hi,

This is an abstract from the BOL:

Recommendations for Good DBCC Performance

1. Run CHECKDB when the system usage is low.

2. Be sure that you are not performing other disk I/O...

Hi Gary,

Try the following:

--change the SA Password in the MSDE version 8.00.382

EXEC sp_password 'OldPass', 'NewPass', 'sa'

Good luck

Herb

If it was a user-db, I would normally use the following syntax running from QA. This does not require the db to be offline which is a plus.

--Replace the folder...

Hi Flavio,

Just in case you forget, please please check that there are no stored proc referencing this column before making the changes. If there is, you have to take this...

OK AngelaBut,

I totally agree on what you all are saying.

What if the table holds very few records despite the many columns? Should performance still become an issue?

Will appreciate any of...