Againa when i tried with another database of 250GB its the same. IS there any reason why database size is not same when i am restoring a sam copy from...

any idea how to drop and re-create indexes only on few partitions of a table.

As my tables are partitioned, i dont want to drop indexes on all partitions, i just want to do only on those partiotns where i am inserting data, how wud...

the 1st one scripts out all tables including indexes on system tables which i dont need. I just need to drop and recreate user tables.

and how do i drop all...

yes i am checking by sp_spaceused and i see the unallocated space is still the same only the db size has gone down.

Also I would like to verify if am rebuilding the indexes on the databases does the soze of the database go low.

Here is what i did...

Backed up databse Emp (...

could you please let me know how i would configure a sql login to access another server through link server and how wud i set what kind of access sql...

I do have all windows authenticated Link servers between the server.

OK. I was going through the post here and has a question.

If i run a long insert statement in bathces of 10k records then when i kill the job after...

is this somethin like...

select R.* into

from Budget..Hrbg as R , Revenue..BudHrbg as BD

where R.BudID= BD.BudID and R.servcdate between BD.startDate and BD.endDate

how do i do this insert in batches just in case to improve performance.

yes i update only data in my stage as and when i get new data and then mvoe them to production.

our production databases are enabled only to read the data...

I dont think database file location will be taken from model, its a server level setting.

anywyas my model database points c drive where sql server is installed.

I still have this problem, i do have same kind of previlages on other servers, it works Ok, non sysadmin can edit his jobs there but for the new server...

can i use

WIT HEXECUTE AS 'sysadmin'