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...
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...
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...
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 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...
Does anyone know if SQL Server stores a history log of transaction id's or SPID's? I'm reviewing a trace file from a couple of days ago and I need...
Hi all: We've had the FKs in the majority of the tables lose their FKs somehow. I have to remove the tables from replication in order to alter the...
We have suddenly had all of the FK and Triggers on all of the tables in one of our databases disappear. Has any experienced this before? Any ideas...
I don't have any idea. The service stopped and will not restart. Any ideas? How would I bring it back up if it won't restart? This is urgent and I...
I have a snapshot on one that is sending a large table and I keep getting the following error: The process could not bulk copy out of table...
xp_sendmail has started hanging. When I hit the 'test' button on SQL Mail or issue an xp_sendmail it just hangs until I cancel it. It's not the...
Separate names with a comma.
