Hello,

First off all I would suggest to create a unique clustered index, on the column that is a primary key.

In Your case this would be the ROWID column.

Further...

Try this:

SELECT DIFF = (SELECT A FROM TEMP1) - (SELECT B FROM TEMP2)

I would suggest:

IF EXISTS (SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'[ABC_SCHEMA].[ABC_TABLE]') AND [Type] IN (N'U'))

DROP TABLE [ABC_SCHEMA].[ABC_TABLE]

Because:

1. It's safer to check the schema in witch the table...

Hi,

Sure you can. Just try it!

But first of all, you need to make a "FULL" backup, otherwise just a differential backup without a full base is useless.

Very nice script but it's not stable.

Check the following examples:

1. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274665)

2. select dbo.MyDistance(46.192131,21.274666,46.192131,21.274666)

Both examples will give the following error:

Msg 3623, Level 16, State 1, Line 1

An invalid floating point...

Have you installed the replication components?

CU = Cumulative Update package.

A new term introduced by the sql server servicing model similar to hotfixes, for details see:

http://support.microsoft.com/kb/935897

An up to date list of the latest CU-s...

Did you installed Sql 2008 SP1, and the latest CU ?

Hi

If case your firewall settings has no effect you have to:

1. Check again, your firewall settings, because they are too permissive.

2. If your firewall settings are enough restrictive,...

Unfortunately there is no way to hide or rename the "sa" ~ "dba" account on any sql server instance in mixed security mode.

This sql login account must exist o...

Thank you for indicating how to execute stored procedures as RPC calls from client application,

but what I want to know exactly is why should I chose to execute it as...

right!

Check this procedure in BOL: sp_changedistributor_property

MSzI.

Hi,

If the Distribution Agent is where you get this message, and the job schedule is set to continuous try to change the schedule to every xx min. You can choose...

Hi,

I try to answer for your questions:

1. Yes you can create as many replications/publications ( In fact the correct terminology is "Publications" in your case ) as you wish...

Hi Florian,

First of all congratulation, it's a nice work/script, end very useful for many of uss!

One thing that's missing, and I hope you will add to the script is the...