there is a function documented at

http://support.microsoft.com/kb/886839

if the clustering index key(s) is not unique , sqlserver will make it unique for you (by adding kind of guid).

All access to the datapages for a clustered table uses...

just a first glimps for a simple start

This select shows the values from within the same table...

Concept may be a good start..

select T1.[object_id], T1.[date], T1.data1 as T1_Data1, T1.data2 as T1_Data2

,...

Books online explains this very well !

The clustered index actually has the data in its leaf level !

A NCI is built aside from the table, based on the table and...

This prooves once again the world is round :w00t:

actually your full sp might be replaced by one dts package.

If you don't need things to be synchronized online-realtime, switch to DTS !

there is a DMV exposing this in sql2005, I'll have to do a little search on it.

this comes from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2892190&SiteID=1

(I don't have my own scripts available for the moment)

-- CREATE...

you can use DTS for this.

from EM in the table pane rightclick and select import/export data....

You can save the package and schedule it if needed.

Don't swap schema.

Just create a

create view dbo.myview

as

select a.col1, b.col1, ...

from dbo.table1 a

inner join dbo.table2 b

on a.key = b.fk4a

- if you add with check it checks the results of...

I knew your name did ring a bell 😀

the SSC-article http://www.sqlservercentral.com/articles/News/exceptionhandlinginsqlserver2005/2237/

introduces try-catch.

but I got to admit I like your art. more because it goes more in detail and has...

SQLserver only has a precision +-3ms

IMO if you'd enabled database owner chaining, things might have worked from the start on.

Post your clr-code and you have a good enough chance Jeff or someone else comes up...

there must be an art at SSC

but I found this one in my examples http://www.simple-talk.com/sql/t-sql-programming/sql-server-error-handling-workbench

BEGIN TRY

SELECT CONVERT(INT, 'XYZ')

END TRY

BEGIN CATCH

-- ERROR_...

your sqlstatement is returing a resultset !

What are you trying to do ?

Why are you using dynamic sql to fulfill this need ?

I'm not familiar with mysql :blush:

But hooking it op with sql2000 can be done using a linked server;

The code below works for msaccess

USE [master]

GO

-- EXEC master.dbo.sp_dropserver @server=N'LSTEST', @droplogins='droplogins'

EXEC master.dbo.sp_addlinkedserver...