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?

You could also try sjones@sqlservercentral.com (Steve Jones...the editor).

Contact WebMaster@SQLServerCentral.com and let them know.  They sometimes miss things.

Sorry for my slow reply.

I created the user from login. At the server and database level they are only in the public role and I can't see anything relevant...

Niiiicccceee!  I'm going to do some performance tests there because, although it's not a super common request, it's a request that has happened often enough...

The prompt was based on minimal code

this sql code omits a 2nd column with which we could order the rows.  Could you add a date...