"Why is Sql Server to damned rubbish at managing it's memory? "

SQL Server will use as much memory as possible to speed up queries by caching data in memory. Every...

Interesting. There are a number of changes to replication in SP3a. I wouldn't have thought they'd be the cause of you problems, but as always, having the latest service pack...

Maybe its your joining that is taking so long?

Do you other tables have indexes? Do you have relationships defined between these fields on these tables?

Using Query Analyzer, turn on "Show...

It depends on the size of your tables and the amount of change that occurs.

If you have tables that are rarely updated, snapshot is fine.

If you have tables that are...

I think that Sheilesh is trying to convert the non-clustered primary keys to clustered, and that they cannot be dropped because of foreign keys.

Yes, other non-clustered indexes need to...

Ouch! Snapshot doesn't need to be run that often. Snapshot takes an ENTIRE copy of your table, where as replication only copies over the changes. Really you only need a...

You might find that you need more changes to your tables then just Primary Keys.

I would suggest mannually replicating a few tables in development first. Just use the wizards...

Ah. I think what you are looking for is:

CREATE CLUSTERED .. INDEX index_name ...... WITH DROP_EXISTING

The index name specified must be the same as a currently existing index. SQL Server...

Really I would just use SQL Profiler. You'll find it under the Tools menu in SQL Enterprise Manager.

It hooks into SQL Server and collects all the actions that are...

Have you refreshed? The agents are like SQL Server Agent Jobs (actually they are) so they are updated as they run. The Snapshot Agent needs to be the first one...

If that's something you DONT want someone to do, why not set some DENY DELETE permissions?

This wont work if a stored procedure is doing the delete, but its a...

Hi Imran

I've been working on replication over the last couple of weeks, so have read a fair bit about it.

I see you have two main questions:

1. Which type of subscription...

To get a RecordCount, you must use a Client side cursor location (adUseClient), and a static cursor type (adOpenStatic). ADO then gets all the records back from the server so...

We have been using it for a number of months, and it seems to do ok.

Our backup routine is hand scripted, to handle a whole lot of potential clashes that...

The Database Administrator should put together the standards, then put them forward for discussion/review among those that will have to implement it. After all a standard is no good if...