• Interests: Rock Music, surfing, kayaking, sailing, holidays, theatre, concerts, wine.

Technical Article

Analyse tables for replication ( sql 2000 )

I have a requirement deploy transactional replication for an existing database which wasn't designed with replication in mind. I need to script/deploy based upon PK's, identity columns and timestamp columns. This query allows me to gather and save the information enabling me to generate the various scripts to replicate my database, replication through T SQL […]

2007-07-12 (first published: )

744 reads

Blogs

Daily Coping 12 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My Toolbox - Greenshot

By

Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...

Daily Coping 11 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Groupinig using Lists in a report

By Jason

I am trying to create a list type report and can't seem to get...

SSMS: Remove highlight in current cell of grid output

By Aaron N. Cutshall

I'm trying to capture some screen shots of query results for documentation. I'd like...

Need to rollup some rows to columns

By sqlfriend

Hello, thanks in advance for any help. I have a query like this: select...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers