Thanks for the additional info. PK clustered on a varchar() column (a GUID no less) and 12 non-clustered index.

There are probably some FKs in the table as...

can you provide the table and index definitions?

Is there a trigger on the table?

gmac 41947 (2/21/2013)

---

If I insert variable in SQL JOB Step, the JOB exec stopped with error.

When I insert throughout code (variables, bcp command...) in .bat file, and I reference this...

Once your data is on someone's computer your data is no longer protected from others.

I would recommend encrypting the important data items and develop a key management scheme that would...

add those minutes to a date @ 00:00:00 hrs then format as a time. As an example:

declare @mins int

set @mins = 150

select convert(char(5),dateadd(minute,@mins,'01/01/2013'),108)

You should use bcp utility. It is included as apart of every SQL Server installation. It is a command line utility, you specify what data is to be exported...

brad.blackburn (2/20/2013)

---

I would like to add to this question. I have something similar (except for all the joins). A program on this one computer shows that a single...

The chances of you seeing other processes in "runnable" state is quite high since your process (sp_who2 or something) is currently consuming CPU time.

Remember the old adage: "A watched pot...

yes I can, but from what you are describing, scripting out the roles and permissions from production and executing it on the dev server will not give you what you...

didling with...

I have proc that will script out all the users, roles and their permissions if you want it.

But I would make two other suggestion which would be simpler:

1) import the...

insert into testing

select '16456456456456456456456456456456546546456456456456456456'

union select '2'

union select '11'

union select '1'

select * from testing

order by len(big_number), big_number

you are running bcp from a shell, so get the current date (M/D/Y) part into a variable:

set DATEVAR=%DATE:~4,10%

as part of a filename you probably want to change the / ...

push another copy of the file over for SSIS to use.... or push another copy over for users to look at.

I would use -N option (native mode) for what you are doing instead of -c