To me, this sounds like everything is working correctly. Snapshot replication is only intended to deliver the content of the tables as they were on the publishing database when...

So, at least one of the columns/databases uses a case sensitive collation. This does not mean that your comparisons (e.g. join conditions) need to be case sensitive as well....

Check the properties of the ole-db destination - by default it inserts row by row committing as it goes (i.e. a commit per record). Change the Data access...

For me, the reason not to make everything upper case is exactly the same reason that everything we write is a mixture of upper and lower case - it is...

If the database principal was related to a login that is a windows user, there is no need to "fix" them. The function of sp_change_user_login is to align users...

Active Directory associated a unique identifier with each user and group. This is stored by SQL Server with the login (in column SID of syslogins). In each user...

Sounds like you are using either Merge Replication . This requires a uniqueidentifier column and replication will add the column if needed.

If you need to have updates to records...

Are you sure that you can publish data from a SQL 2000 instance to a SQL 2008 instance ?

I haven't got a system with me to test with but the...

Normally, you shouldn't need to worry about setting permissions on the relevant registry keys. If you use the configuration tools that come with SQL Server to set/change the account...

sp_helpindex shows information about indexes

sp_help shows more information about indexes (and lots of other information about a table as well)

Check out "Alerts" (under SQL Server Agent). There are replication alerts that should do what you are after.

I agree with MaricopaJoe...RSScripter is a fantastic tool. You can script pretty much any of the Reporting Services objects from an existing installation and apply the scripts to another....

In report manager, go to the properties of the report. You should see an Edit link. Click on this. You can then save the RDL to somewhere...

You should update the definition of the dimension so that you have the dimension sorted as you want it. The 2 properties you need to change are "OrderBy"...

Have a look at sp_dropsubscription and sp_droparticle.

Better still, if you only have the one article that is out of sync, try sp_reinitsubscription

Check out Books Online for the details of...