We are initializing a large snapshot to our remote subscribers. This is a new publication and it's using an existing Distribution Agent. Will all...
All: Our 2000 servers use dashes in the hostname / instance name. Is this going to cause a problem for our 2005 servers? I remember having an issue...
Will restoring a publication database using the Keep_Replication option reinitialize the subscribers? I don't want this to happen. All subscribers...
Hi Satya, Fortunately, no issues lately. I'm slowly but surely getting it stablized. Lots of work still needs to be done though. I inherited a big...
Any issues switching to Simple recovery on a replicated database (transactional replication)? Thanks.
Are you able to register SQL Server 2000 instances within SQL Server 2005 Management Console? I would assume so but wanted to get some feedback...
Just curious: Does Alter Table physically drop the table and then re-create it?
Hello. I have a SP with an update statement that inner joins a linked table that returns the following error: The operation could not be performed...
Can you manually override the GetDate function using an Update statement? A user wants to change the dates in a column using a GetDate function. I'm...
We're getting this error and I'd like to brainstorm with a couple of you. Here's the scenerio: 1. We have a user who is using MS Access 2003 and...
It looks like the data file is damaged. I'm going to try to repair it with dbcc checkdb and then reintialize the subscription. Hope that works....
Transaction replication is failing with the following error "Communication Link Failure." The server is connected and is accessible. Does anybody...
What issues, if any, have been encountered installing SP4?
I would like to hear how others are managing and syncing their SQL users, roles and permissions across all of their servers. We have about 26 servers...
Unfortunately, there isn't a publication on this server to modify. That's the mystery. Any other thoughts? Thanks. quote:Originally posted by...
When I try to run: ALTER TABLE [dbo].[Table_Name] DROP COLUMN [Column)Name] I get this error: ALTER TABLE DROP COLUMN failed because...
I agree with you that a lot of people don't think about disk config in terms of performance. I know I didn't until receiving your last post about the...
I can see from a performance perspective how a large table that is primarily used for Selects and where the plurality is for multiple rows would...
I had a developer ask me this question: When would you decide to use a composite key instead of an identity key - PK? Is there a general rule of...
DBADave, that's what happened here as well. We had a DNS failure and problems with Exchange. This specific server is SQL Server 2000 EE on a Win...
Separate names with a comma.
