hey, can you annotate what the code is supposed to be doing because I am failing to understand  notes like [/*drop table test ;*/]

where are you running this script...

you might want to consider using

• a batch file
• script file
• dts package (overkill)

can you post you stored proc code?

have you checked the code outside of a stored proc

might be best for you to post to a vb developer forum, but nonetheless is it possible for you to post your code

1. dumb question but did you check whether the user has is added to the sql users? what do you get if you run this command

EXEC

master

check your transform to see what data type the column is being converted FROM and TO

if you want to get the working days between two dates, you can have a look at this thread

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=211734

and see if helps, if not then let us know, and...

putting users into db_datareader and db_datawriter is a definite start. On the Live server users should not have the All Mighty rights.

Make sure developers stay away from the production servers...

i managed to run your script in sql 2005 express without a problem

can you post the webservice parameter definition

e.g. ws.addTwoNumber(int a, int b)

befaore you migrate you might need to check if the schema owner was not used in queries.

e.g. select * from dbo.SomeTable

DROP CREDENTIAL mycredential

you can not delete the folder

on database A, run this statement

grant

execute on 'ABC_Zakazka' to public