Thanks a lot,

I can run the code you have provided but the point is why I am getting this error. The reason I have to fix it because I...

I get this error when I try to create it.

Sure, here is the procedure. if tried creating this procedure in small segment but it is failing at following area but I can create this table without any problem.

...

You can put a shrinking log file as your maintenance plan but never put shrinking database in your maintenance plan.

I checked the compatability level and it's SQL Server 2005(90). I don't think code have some issue because it's working on other database. Only one database it is giving error...

I don't think that is the case because if that is the case then it should not get created in master database. when I create this store procedure on master...

Copy and paste these following three stored procedure and you will get everything. make sure these SP's should be in master database. after pasting these stored procedure you can run...

Raju..

You are missing back slash in the path folder. just add back slash and you will be fine. It should be like this.

EXEC dbo.SP_GENERATE_TABLE_SCRIPT 'TESTDB','C\TempTest\'

Thanks for the info. I am using SQL - DMO script method which is much better. here is the code.

This procedure will create individual table scripts.

you can also create...

Thanks Sam, I figured it out. You need admin right on the server and also need access to MSDB database.

Thanks for your reply but this does not work on SQL 2000. Sorry, I did not mentioned ver.

Is there a similar command on sql 2000 server.

I created indexes on the tables and works fine.

Here you go.

Good way is to deny and grant permission to logins.

Create a two SQL JOB

In one JOB called this SP by issue parameter DENY if denying

other job...

My recommendation is to go for a Hyperbac Backup which is great. Compression rate is 75 to 80% and have lots of features like object recovery , means that you...

I found another thing.

If I use following query it is taking forever.

insert into table name

SELECT DISTINCT field 1,field 2,field 3

FROM dbo.TBL_ANAL_CLMS_SMG

but when I remove DISTINCT from the command, it...