They have returned nothing.

when I ran step1 it gave NULL

when I ran step2 it gave The object '##temptablename' does not exist in database 'master' or is invalid for this...

I created a maintenance plan with check Integrity option selected. It is failing at that point. And it is not backing up the databases.

Hi,

I did all the steps that you have mentioned. However it didn't delete the global temp table. Please let me know what I might be missing.

Thanks,

sridhar.

we have created that table probably 2 or 3 years back. And we have restarted our sql server several times after that. when i try to drop that table using...

If I run sql server 2005 at compatability level 80 then can I detach a database from sql server 2005 and re-attach it to sql server 2000? do I have...

Thank you. It worked.

Thank you.

I am not getting any dialog that can install the server stuff. When i start install, it is saying that "cannot install sql server 2000 standard edition server components. can...

It is working...It is my fault with the syntax

Hi,

I just need to create the Stored Procedures and Functions that does not exist. So I was thinking to write code to do that instead of buying...

Thanks!

Hi,

For the first stored procedure I am not using dynamic sql. I have created two stored procedures named sp_CreateTable and sp_InsertTable in master...

In that case I need to pass database name and execute the insert statement using Dynamic sql which is not a better option. Is that right? Are there any other...

Thanks peter.

Hi Kenneth,

Thanks for the reply. I have written a stored procedure that suits each case. I thought that there might be some generic way...