i think you'll want to search a bit more here on SSC for a better example of auditing changes.

first, your example table is missing a primary key...so for your example,...

he means you have to run the full path: something like this instead:...this is the path on my specific machine:

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\bcp.exe

no i was thinking that you should run monitoring tools against your live server and gather statistics that help identify your bottlenecks;

there's a link on this thread that has a...

the identity() columns themselves are not a problem; I read an

article years ago where SQL2000 could handle 400 new identity values per second in a table...and that was given...

by using the row_number() function,a nd a subquery to limit the results ot the row number, you'll get one(max) record for each account...that's because of the partition by.

try this:

SELECT AccountNbr,...

one of the options in SSMS is that you can script out any command you are doing in the GUI...

the way to do it is as follows:

1. create a...

another option is to use the IDENTITY() function, which is allowed when you use the SELECT INTO format to create an identity column in the dynamically created table:

SELECT

identity(int,1,1) as...

to use openrowset or openquery, adhoc would need to be enabled; if that is not possible, then linked servers, or using a login that has access to both databases would...

I think linked servers would allow you to change authentication information, but you didn't want to do that...

The openrowset command lets you specify the connection information, you might roll both...

even worse, i believe the UPDATE() and COLUMNS_UPDATED() returns which columns were REFERENCED in the update statement, not which ones actually changed their value...since a lot of datalayers would send...

so correct me if i'm wrong, but you might want a sampling, like a random top 3 per group, right?

if that is the case, it's deceptively simple...a CTE and newid...

can you check the version of the instance you are connecting to? it might be that that instance is, say RTM, but your client tools are using SP4 or something,...

i haven't tried Azure yet, but why can't you create a permanent Tally table and use that?

Looks like the server name in @REMSServer has TWO slashes in it, the way C languages tend to escape the slashes.

can you PRINT @REMSServer and confirm the value is NYSQL004\NYSQL004...

doh rereading based on getoffmyfoot's comments, you are definitely looking for a running total kind of solution.