Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: homebrew01
- Content: Threads
- Order by date
-
un-flag reinitialization for trans subscription
Here's my predicament. I changed the filter on an article within a subscription, but not in a meaningful way. I just added "database.dbo." before a column name, but now my subscription is flagged for reinitialization, and won't replicate any transactions unless I start over with a new...- homebrew01
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Setup and Administration
-
Transfer Database vs Restore DB
Every few weeks we need to copy our production database (call it PROD_DB ) on Server#1 and overlay our test database with current data (call it TEST_DB) on Server#2. We've been restoring from a SQL Agent tape backup to the test database ..... works fine, but I'm dependant on the Network Admin...- homebrew01
- Thread
- Replies: 8
- Forum: Microsoft SQL Server: Setup and Administration
-
Replication - Column filtering confusion
I'm learning replication (snapshot for now) and was trying filtering & got strange results. (SQL 2K sp2) Publisher: Table1 FieldA FieldB FieldC Subscriber: Table1 FieldA FieldB FieldC But now, I decide after the fact to filter FieldC. The subscriber Table still has 3 fields, but the...- homebrew01
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Replication error 14294
When running the create publication wizard, I get: "Error 14294 - Supply either @Job_id or @Job_Name to identify the job" I had pubs & subs set up, but things were erroring, so I tried deleting everything and wanted to start from scratch, but the last step in the wizard gets me...- homebrew01
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
