Jeff

How would I encrypt existing data? I would need to write a tool to read each record, then encrypt it and update the record back in the table which will...

Interesting find. Fortunately we dont have computed columns..The replication has gone through a major improvement in SQL 2005. We are currently upgrading to 2005 and I am testing the new...

What is the criteria for the results? do you want to break it up for every 3 days? stay away from cursors.

Before you do a SELECT INTO its a good idea to check if the table exists in the tempdb and drop it first. You prbly have an object left out...

I agree. But thats not my call. But this is a one time ordeal for encrypting existing data. For any new data it will be encrypted through the application layer.

We are encrypting some of our columns in the table. The encrypting tool needs a fixed width file. So I need to create multiple smaller fixed width files which will...

Get the "Results to Text" and set the width to at least 1200. The stored proc gets trimmed off under normal results.

replace with your server name (SELECT @@servername)

and with the db you want to create thes cripts for (SELECT DB_Name())

Hey John

why do you even need to script out the articles when you are restoring the PUB db on the SUB? You can just restore the db on subscriber and...

If you are having issues with updating rows that have IDENTITY columns here's something you can do:

•Get the script from MASTER db for the stored proc sp_scriptdynamicupdproc

•Compile the stored proc...

The view idea seems more feasible. I have tables with 200 mil rows. Need to see how it works out when I batch the bcp util. Thanks for the suggestion.

I...

You prlby need to initialize the @NewForumUserID to NULL before the insert.

The text files I create have to be passed through some 3rd party ETL tool for encryption. So the files should be readable. If I use native format, the files...

When you create your tables create them with dbo as owner.

CREATE TABLE dbo.mytable

instead of

CREATE TABLE mytable

If you dont use the prefix dbo the table will created within the scope...

When you are setting up the replication, you need to select the list of objects you want to be replicated. By default only views are selected. Perhaps you overlooked that...