sql server 2005

26 May 2006 8:05 AM

guy

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?

26 May 2006 10:11 AM

Cor Ligthert [MVP]

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

Show quoteHide quote

"guy" <g**@discussions.microsoft.com> schreef in bericht
news:3663C73F-2CC0-497E-AB3A-0D1344A13D29@microsoft.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?

26 May 2006 3:15 PM

AMDRIT

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.

Show quoteHide quote

"guy" <g**@discussions.microsoft.com> wrote in message
news:3663C73F-2CC0-497E-AB3A-0D1344A13D29@microsoft.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?