I'm thinking, based on what you've said, I convert the Id field to VARCHAR, looking something like LON1_X, or CDF1_X where X is the actual id, and LON1 or CDF1...

Identity columns and replication are a dangerous combination for the central subscriber model, specifically because you can have a PK conflict when...

Subscribe to publisher #1 with initialization which will create the schema and snapshot the data. Subscribe to publishers #2-X without initialization.

Will new inserts into your publishers occur on only one...

Is this a push subscription or a pull subscription? At what step in trying to create the subscription does the error occur? Have you tried scripting out the new subscription...

I feel better telling people who are just starting NEVER EVER. If I start equivocating, they'll use it inappropriately. Of course, if you really understand what it's doing, the way...

Where I work everyone has their own office. We each have name cards on our windows that can be turned around to display "In The Zone, Do Not Disturb". The...

I am trying to trace database to find out what other transactions are taking place while this XYZ application making request and I am just worried about my production performance...

I think it's a bit harsh and perhaps even a bit academic to say never ever run profiler against a production server. Yes, it can create problems when used incorrectly,...

I Performed full Reindex on Database 2 weeks ago, Last night I explicitly ran the on-line index on 5 tables ..

Database is big its nearly 1 TB and used...

I started tracing on DB server from my desk top @ 10:50 AM but I received mail saying that they have not connecting to DB and their application server failed...

Gift Peddie (3/27/2009)

---

I have told you to get a copy of developer and profile the code in a test box and yes your users error maybe related to the profiler...

It sounds like the OP is saying he's going to run Profiler on his desktop\laptop and point it at his production server.

The impact on the server depends on how many events you're capturing and what kind of filters you put in place. Generally speaking traces should be configured to capture only...

Forgot to mention that you can also run DBCC SHOWFILESTATS to see extent usage and allocation for each data file.

If the three tables are part of the same publication, yes.