sp_change_users_login, sp_password, sp_addlogin, sp_droplogin, sp_grantlogin, sp_revokelogin

etc.

1. I do not understand why do you need to change a collation level on server, since it is not changing collation level on existing databases anyway.

2. You do not...

Sql Server 2008 Express: 1CPU; 1GB of RAM; 4...

SPN is a service principle name. SPN problem is indicating a problem with registering SPN in AD.

The article I referenced giving you (your network manager) a step by step instructions...

rob,

that is where I suggested to "load balance" updates based on some "range values".

In other words

IF SOMECRITERIA IS TRUE AND SERVER1 IS ONLINE UPDATE SERVER1

IF SOMECRITERIA IS TRUE UPDATE...

Marios,

Format() does not change the field value. If instead of 615 you are receieving 615615, you made an error in expression.

With this scenario you do not need MSMQ. You will have all three servers being the same (from end user prospective of view).

Each server will publish to two other.

If...

How about running it from the server where the bigger table is located?

rob,

I am assuming that here there is a mix of two problems.

From one you are trying to achieve a load balancing between three servers. From another you want to add...

There is one more scenario. It is using synonyms in SQL 2005.

In this case this is "granted by design". You need to recreate synonym if the table on which synonym...

replace(b.[Name],'''','''''')

Arpan,

the problem with your script is in the fact that Registry location is changing for every version of SQL server. I.E. For SQL 2000; for SQL 2005 and named instance...

Any chance you are using firewall on your local machine?

And if yes, can you please try turning it off and then trying to reconnect?

Search BOL for encryption.

= "$" & Format(Fields!Field1.value,"##,###,##0.00")