That's pretty much...

It's a telephone system.  They just wanted different ways to evaluate things like doing call duration analysis depending on which client someone was calling about (we handle the calls for...

how big is the table?

if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.

but for anything with volumes BCP or...

As a bit of a sidebar, it's a real shame...

Heh... and so it begins. 🙁

Oh, and the ChatGPT answer suggests using Profiler. That's flat out wrong, assuming SQL Server 2012 or greater....

I'm totally confused...

You must have VIEW DEFINITION permission and I bet I don't. I'm testing this on our cloud based DB from our app provider using my surface laptop and we...

The old article you found in a previous response to your question used sysdepends, which would sometimes miss things depending on the order of creation.  Take a look at the...

1.  I forgot about table partitioning.  That answers my question there.
2. If the database is in the FULL Recovery Model, I recommend temporarily shifting to the BULK LOGGED Recovery Model...

I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to perform the creation job.

CREATE CLUSTERED INDEX...

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.