Viewing 15 posts - 766 through 780 (of 1,222 total)
None that I can think of - in fact, not being able to replicate them has been a problem in the past.
May 27, 2009 at 7:06 am
I suspect that the topic_id column is an identity column on the old server and when you transferred the definitions/data to the new server the identity property was not on...
May 27, 2009 at 7:03 am
Normally, I would not be too concerned about SSIS and RBAR. SSIS is pretty good at handling that sort of thing. You may well find that the way...
May 27, 2009 at 6:43 am
Like I said the location of the snapshot is stored with the definition of the publication. The subscriber uses that definition to find the snapshot folder.
May 27, 2009 at 6:36 am
The location of snapshot folder is included with the definition of the publication.
May 26, 2009 at 11:19 pm
Firstly, I think that your information on clustering is not quite right. There is no loss of transactions that have been committed. Transactions that are in progress when...
May 26, 2009 at 11:18 pm
From memory (and it been a while for this type of question), you need a couple things in place for multiple CPUs/Cores to be used...Enterprise Edition and multiple partitions in...
May 26, 2009 at 6:48 am
The error message pretty much says it all - Workgroup Edition is restricted to accessing local SQL Server databases only.
Developer Edition does not have this restriction which is why you...
May 26, 2009 at 6:42 am
Cluster Resources are used to define everything required for the service to work correctly. The clustering software monitors the availability of everything in the cluster resource and when something...
May 26, 2009 at 6:35 am
If you have a column with the value you are after, you can use the advanced tab in the Lookup task to apply a filter to the SQL statement. ...
May 24, 2009 at 10:43 pm
With SQL 2000, you have limitation on what you can change.
For tables, you can add or remove columns PROVIDED THAT you use the stored proc sp_repladdcolumn and sp_repldropcolumn....
May 24, 2009 at 10:19 pm
Looking at the log file - there are no user databases mentioned. This suggests to me that SQL Server has not gotten to point where it is ready for...
May 21, 2009 at 10:07 pm
As the error message states, you need to supply a filter that can be used in a WHERE statement.
You can re-write your statement as
SELECT * FROM [dbo].[TableA] TA...
May 17, 2009 at 10:30 pm
It been a long time since I last used SQL 6.5. but...
The information you need will be in a table with a name something like syssubscription in the database that...
May 14, 2009 at 10:20 pm
You can schedule transactional replication to be continuous or on a schedule. If you use a schedule you cannot go to less than a minute. However, if you...
May 14, 2009 at 10:08 pm
Viewing 15 posts - 766 through 780 (of 1,222 total)