The following link may give you some ideas:

http://www.eggheadcafe.com/community/aspnet/2/10074732/upload-a-word-or-pdf-file.aspx

I wrote DTS & SSIS Packages to Backup the Production Database, copy it, write a SQL Script to create the Database if it does not exist.

I did this to refresh...

Powershell is a very powerful tool, however there is a bit of a learning curve to master the capabilities of it.

I did not send you the link listed below. I...

Basically what you are doing when you change the default POrt is change a registry entry.

WHen you create an alias you are modifying the registry as well.

THis can be performed...

Have you looked at the Powershell Utility?

Have you gone into debug mode and set breakpoints?

Have you tried altering the package or query so that it only inserts 1 record?

It would appear that you have a mapping...

I suggest that you reproduce the problem.

You can run a variation of the script that you initially ran.

Going through the GUI will not assist you in reproducing the problem.

Then I...

You can disable a user account via a Group policy.

Anyone who is a local admin, domain admin or enterprise admin inherits the SQL Server Fixed Server Role.

If you run a...

Could you share the T-SQL Script that you used?

Are the logins diabled as well as the user accounts?

How long after you created the accounts did you notice that they were...

Yes, you can do this, please refer to the following links:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

http://msdn.microsoft.com/en-us/library/ms141724.aspx

I hope this helps...

Try the following links. I got a few other hits so let me know if this works for you.

http://dbaspot.com/forums/sqlserver-programming/391006-bcp-out-including-column-question.html

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/812b8eec-5b77-42a2-bd23-965558ece5b9

Could it be that the record in the master table has not been committed?

What about batch size?

Try going into debug mode, set break points and after the Insert into the...

Nicholas Cain (3/5/2010)

--------------------------------------------------------------------------------

It could be any number of things.

You need to take a look at the way memory and cpu are being handled, whether it's the page draw that's causing...

No worries.

I was not being critical.

Have a nice day!

Please look into perfmon as was suggested to you.

That is a biggie.

You can Goggle of you have one of the DBA Books they all have sections on performance.

You are doing...