I don't think you can do that in SQL Server QA.

Try alter view.

Even after setting the text size it does not give the complete text of the stored procedure,I chops off the text in a single row after certain limit.For example if...

Try putting the Insert's into one transaction.

Begin Transaction

Your Code

End Transaction

To the extent I know about SQL server we cannot execute the VB app. inside a trigger.

I don't think you can pass the variable values into the DTS task from the trigger.But try taking the values into the global variables and using those variables in the...

With the standard addition it does not give us the choice to specify the location.with the personal addition if you are trying to install than it will give the choice...

I think you can execute a DTS package when a Insert trigger fires Using DTSRUN Utility.

Is that disk space getting filled up when you are trying to insert the data into the database.Check the transaction log size.

I Think it is doable,have you tested it?

Which edition are you trying to install?

I Would say bulk insert.If there are indexes on the table the inserts will become slow.

How much disk space is available?

with aliased columns

DECLARE @LAST_FIRST VARCHAR(50)

SET @LAST_FIRST = 'BORRELLI, ANDY'

SELECT SUBSTRING(@LAST_FIRST,1,CHARINDEX(',',@LAST_FIRST)-1) LAST,

SUBSTRING(@LAST_FIRST,CHARINDEX(',',@LAST_FIRST)+1,LEN(@LAST_FIRST)) FIRST,

@LAST_FIRST

DECLARE @LAST_FIRST VARCHAR(50)

SET @LAST_FIRST = 'BORRELLI, ANDY'

SELECT SUBSTRING(@LAST_FIRST,1,CHARINDEX(',',@LAST_FIRST)-1),

SUBSTRING(@LAST_FIRST,CHARINDEX(',',@LAST_FIRST)+1,LEN(@LAST_FIRST)),

@LAST_FIRST