Changing the compatability level does not maintain the databases structure as that of a 2000 db. It does allow the db to...

Works well. there are not any extra steps, but it is important to remember that you cannot take the 2008 database back to 2000.

Add another to the incorrect correct answer. Again, how can a question such as this be multiple choice:w00t:

Yes, you can shrink the PRIMARY, but I would ask first does this database grow? Will you shrink the file and then later need to have it expand? Doing this...

Nice toy. I did something similiar for same reasons - have been 4-wheeling ever since.

We have a startup SP that notifies us of the startup as well as the status of each database. We have a 2nd SP to notify us of an outage...

Scary, I remember saying that as well. I had a choice of 512KB or 640KB for a computer. I wanted to make sure that...

This is true, these are normally factors you wouldn't consider in a question of this nature... except that the additional factor of file system was made part of the answer...

Good way to return from vacation. Good question, but reading the answers was a new experience in eyeball manipulation:crazy:

Mike,

I have the exact same situation and setup. Are you using a T1 between your location and the stores? T1 is a major bottleneck when it comes to this type...

A good article on a very complex subject. My question though is why would you have articles that can be reinitialized in a matter of seconds or minutes to an...

Set up full text search on mytable/mycolumn and change your select from a like to a contains.

Using a wildcard at the front of the...

You may also look at the length of time you have set for subscriptions to expire. Increasing the amount of time for expiratin will not necessarily fix whatever caused your...

Nice question - almost missed it. Re-Review of code caused me to change my answer at the last minute. 🙂

Mandip

I am experiencing high latency issue on distributor to subscriber in transactional replication setup. sometimes for particular artcile "A"(single object) the latency can be as high as 3 hours where...