sql server 2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Guy,

As you said, really not an vb.language question.

The ones who have to help you in this question are not the developers, but
the admins and endusers.

I have very bad expiriences in given answers on this by regular developers.

Just my thought,

Cor
 
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.
 
Back
Top