I've never thought about this. However the diagram is stored in the dtproperties table so I would assume the user would at the very least need to have the ability...

Before adding a table I would make sure that you have all your subscriptions sync up. Then add the table. The reason for this is that you will have to...

the best way would be to add an identity column to the table so that when you import the data you can preserve the ordering. Then use an order by...

I'm changing to uniqueidentifiers because I'm tired of dealing with the managed identities. I have had to repair data every month since I started working on this database for the...

If you add the NOT FOR REPLICATION to the identity columns you can then create a script to run before the snapshot is applied that creates the schema. Then run...

If you are concerned with the way the data is ordered when you retrieve it then use an order by clause in the select statement. You can NEVER garantee that...

Yikes,

First you will need to create a script to script out the tables. Then you will need to rename all the tables to a new name, modify your script to...

In my experience I usually just drop the subscription and recreate it in EM. But then, I'm lazy when it comes to the Snapshot replication.

Or you can use EM...

Since you don't state what your PK is this is a little hard to do. But I would create a script that will set the rowcount to 1000 and then...

The best way I can think of is to check for the error before the insert and then manually roll back and then log the error.

Gary Johnson

Microsoft Natural Language Group

DBA,...

Can you check with Profiler what is going on? It sounds like you are having a problem with not getting the transaction committed.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

You need to take a look at SQL Server Books Online on the Restore command.

basically

Restore Database <dbname>

FROM DISK = 'filename'

WITH STATS, MOVE...

I don't have BOL here so I can't...

Check your ANSI_NULLS setting. Usually you will want to use the ISNULL function instead though. That way regardless of how the database is set up the code still works.

IE:...

I would simply create an error log table and put your errors in it (make sure to roll back transactions BEFORE writing to the log table!), use something like xp_cmdshell...

Here is a SP that I use quite a bit. Please use it with caution and make sure to double check the output text to verify that it's correct.

The...