What does the script look like?
What catalog is the script stored in?
How and from what catalog are you executing the script?
Does your user credentials have permission to execute the script?
Did you create the stored procudure during a transaction and not commit it,
and then attempt to execute it?
While there are many reasons that your issue has occured, it is not because
of the SQL Server, ADODB.Net, or VS'05.
"guy" <gu*@discussions.microsoft.com> wrote in message
news:36**********************************@microsof t.com...
ehnot really a vb.net question but...
i have just started using sqlserver 2005 in my current contract and task
one
was to clone a table - so i generated a script (easy) and then executed
it -
"stored procedure Tablename could not be found" ! rerun the script and it
completed, however the table did not appear despite doing a refresh. i had
to
close and restart sqlserver. I know from experience how non-robust studio
2005 is compared with vs2003, is this also true for sqlserver2005 cf 2000?