Search results for query: *

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...

I just had the exact same need (using snapshot repl), and couldn't find a way to just drop 1 "article" (table) from the publication so I could change one of the fields. After a little poking around, I came up with this plan to drop a table from a publication so it can be modified...

The network admin does the restores because he controls the network backups & tape devices. I can work with my own backups to drives, but don't have disk space to store a backup of the production database. We're using Veritas ........ I'm sure it has scheduling capability. We don't do these...

I don't have any reliable downtime for the production database .... (there are night jobs that run on various schedules) so I can't detach it and copy the MDF or LDF. The test server is generally used only 9-5. I thought the Transfer DB option would allow a refresh without having to bother...

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...

What kind of mainframe ? AS/400 has SQL, but it's not really a mainframe

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...

Create a step that creates the table. If it fails, do the next step anyway

In your scheduled job, edit the step, choose "advanced" , then make a log file..... the logs often give more info

Could be that you have invalid data in your Excel file, such as a month GT 12, or day GT 31 ....... SQL verifies that your data is "legal" if it's going into a date field. Maybe if you first import into a work table with a character field, then you can do clean-up, then DTS to your...

What type of file ? You can use DTS to import text, csv ... type files directly into an SQL database

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...