Here's another question: after doing the SELECT .. INTO and adding the PK identity column, I have a table with the PK column as the last column in the table....

The 800,000 row table that I mentioned is part of an active transactional database that is supplied by a vendor as part of an application that also uses a mainframe-type...

Now, if you go to the Users under the new database, what Login Name do you see for user 'dbo'?

I don't believe that is possible. 'sa' is a special login for the system administrator, and 'dbo' is the username for that login.

You can re-create the database under a different...

Melody,

A couple of thoughts:

You could sort the data in the XLS file so that the WC column has some alphanumeric data in the first few rows, and then import it.

Another...

My findings so far:

Using DTS to copy the table into an identical table with no indexes, and using WITH (NOLOCK) and 5000 records at a time, it takes 12 minutes...

I should add that I tried DTS to copy the table into an existing table of the same structure but with an added identity PK column. It was running very...

Good article. I'll have to check out SED.

Regarding the bad record: if the record was embarassed, you could call it a rouge record. But I think you meant rogue.

That works just fine.. no problems at all.

Don't know if this may be a factor, but the server I'm trying to link to has a dash in the name.. like...

Same behavior. I also get the same behavior if I put in completely bogus info (server that doesn't exist, etc.)

What's happening is Enterprise Mangler and Query Analyzationer are still hanging....

Here's an example query that I've tried:

SELECT * FROM OPENQUERY(Bugzilla,'SELECT * FROM bugs')

or

SELECT * FROM OPENQUERY(Bugzilla,'SELECT * FROM profiles')

Bugzilla is the name I assigned to the linked server, bugs...

Well, I'm stumped.

Brian, thanks for your input.

Haven't tried the MySQL command line client..

We're trying out Bugzilla as an issue-tracking system.. this is why we're using MySQL - it's required for Bugzilla.

Bugzilla (web application using Perl and...

It's on both.

Further developments: mostly what's happening now is that Enterprise Manager hangs (wait cursor) when I try to look at a table.. as does Query Analyzer when I query...

The SQL Server machine is Windows Server 2003 with this version of SQL Server:

1)

Microsoft SQL Server 2000 - 8.00.878 (Intel X86) Nov 11 2003 13:37:42 ...