Linux

Technical Article

How to copy identity column in Enterprise Manager

  • Topic

Whenever I export a table to my local database using Enterprise Manager it removes the Identity from the column and shows it as a normal column.  I always have to go into Design mode and change it to an identity column again.  Is there a way to force Enterprise Manger to export the table along […]

You rated this post out of 5. Change rating

2004-12-19

10 reads

Technical Article

Counting and grouping

  • Topic

First post here so I hope I've got the right forum. I'm trying to accomplish something in one query rather than use two and I wonder if it's possible. Two tables. a (multiple records for each account) account event b event classification Here's what I'm trying to do. Pull the classification for the event in […]

2004-11-15

Technical Article

RE: DTS Global Variables

  • Reply

Place your SQL statement as normal, but where you want to use the global variable use the following:  (?) For example:  select * from where id=(?)Then select the "parameters" button and assign the global variable by parameter.  This will go in order if you have more than one global variable to assign in your sql statement.

You rated this post out of 5. Change rating

2004-11-10

Technical Article

RE: Clustering two MS SQL 2000 serveres

  • Reply

I'm not sure if i understood your question correctly but if you are trying to make active/active out of two existing servers having sql installed, you can follow the steps below1) You need a shared disk. configure your server with a shared disk.2) you will also need a heart-beat cable. A cross-over cable. You will also need two […]

You rated this post out of 5. Change rating

2004-09-24

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers