I just use BCP OUT using the Native format and then either BCP or BULK INSERT to import it on the target.  Obviously, there needs to be a folder somewhere...

You can if you hold its head underwater and hook a shop-vac up...

As a bit of a sidebar and without knowing the particulars, it's pretty much a worse practice to make calls within a stored procedure to an actual IP address.  If...

Awesome.  Looking forward to it.

Thanks, Michael.

You've let Paul P. know, correct?

I know what you were looking for but there's actually no correct answer because of the VARCHAR(20) thing.  The correct format of the correct answer is 23 characters long and...

To be honest, though, the tool seems to be based only on column names.  It doesn't actually look for columns that, for example, look for 9 digit number or strings...

That’s the thing about tempdb, it’s true to it’s name. Nothing you put there is truly permanent. By using normal create commands in tempdb you don’t have to worry...

I would say... don't make it a permanent table in TempDB.  It may be justification for them to commit homicide and hide the body.

If you use INSERT/SELECT FROM (VALUES)x(somecol1, somecoletc...), there appears to be no limit.  I've done 50,000 rows as a one-off.

You could make a temporary Linked Server to your machine.  You...

I'd love to come see that Jeff,  but with other commitments I will not be able to attend.  I hope that there will be a recording that we might...

Good morning

I have a local sql server 2000 database with an old application, and I would like to make a copy of this database on sql server 2019 which...

Did you previously try Grant Fritchey's solution at your previous very similar post?

https://www.sqlservercentral.com/forums/topic/how-to-record-the-command-or-stored-produre-called-by-linked-server#post-4099148

This will sound a bit stupid or as a shot in the dark but, when you select @@ServerName, does it return the instance name or something else?