i got the requirement exactly.. i have schema called dbo.table1,dbo.table2 that has to be copied (not transfer) dbonew.table1,dbonew.table2 (with in same db), this below script transfers the name since dbo...

so backup and restore SP will do

My objective is to move the contents of one db to another db

Yes i am trying to move all the DB objects from one schema to another schema using SP, using BCP will be right option??

Anyways to copy the DB objects with data from one schema to another using stored procedure.

problem, the script only creates the database, it deos not copying the table,data and SP's, please suggest some code changes alternate way to do this.

i expect the procedure to do following things

You shall also be able to send NULL in the order table and a new order shall be is created.

If the product already...

What i have to do if it is a clustered environment

Thanks HanShi and gracechristopher06

i am asking on MDF when it 75% full i want add the space to the DB

Step 1: if my MDF is 75% full then

Step 2: add some space

for any db when allocated disk size is 75% full, then we want to add space

need a script or an idea to create script when my db is full by 75% i want add some space to the db

But for each month i have 30 employees, how to maintain that in a single table

Ok,

thanks..almost done..i am in my last step merge of efficiency and shift...i am trying it for past 24 hrs without break i will complete it.Thanks once again