AFAIK, this table is shipped with the product and subsequently updated by service packs (if required). That's the reason why I mentioned about checking if any service packs/hotfixes might have...

Rustman, I did not get your point. do you mean to say that using NOT IN or EXCEPT results in cartesian product? I have already specified that it results in...

"When we restore a database from production to a development environment, we get some erros."

>> what type of errors? does the database has replication turned on in production when you...

Maya,

unless you talk in detail about your replication setup, I am not sure how we can help. You haven't even written what kind (merge or tran) replication do you...

You're welcome!

well, you have not written anything else about your setup. If you want your subscription to be created from a backup instead of snapshot, please follow http://msdn.microsoft.com/en-us/library/ms151705.aspx.

If you want to...

2Tall,

When you add any login into a database as a user with db_datareader role, they automatically can see the metadata of the database as well. I.e. they can see "definition"...

If you are using a windows admin login (based on what I am reading from your notes), why do you need to specify the password and login information. Just add...

"Configure Distribution Wizard" is what I meant for setting up distribution (and distribution db). 😀

You can create distribution from scripts (sp_Adddistributor and sp_adddistributiondb) as well but if you are a...

(a) Windows Authentication (seems right to me) or

(b) "Anonymous"

What's the difference

>> This is while setting the mail accounts. This is asked to check if your SMTP requires authentication...

handle.exe will have to be used from command line on the box where you are finding the files to be locked. To get a GUI based interface, use process explorer...

Yes, the distribution database was restored onto the dev server.

>> This might explain the leftover things and the error messages you are getting.[p][/p]

Read the notes from CirquedeSoliel:

"Then start...

You're welcome, Appollo. By the way, the timestamp columns are replicated as binary data types by SQL Server replication (by default).

JoelyB,

I have a written a piece of code which I believe can help you get some directions:

[p][/p]

CREATE TABLE [dbo].[t1]([c1] [int] NOT NULL PRIMARY KEY,[c2] [varchar](10))

CREATE TABLE [dbo].[t11]([c1] [int] NOT NULL...

You will have to use handle.exe or process explorer from sysinternals to locate the process that has got a handle on those files. Then kill that process to release the...