Yes, I did that. Iright click user, user mappings, clik on database, giving read access

OPC, am reading at the link

Perry,

1. The tables which we need to move doesnt have any index on them. How to move then?

2. Can you please explain which one...

Perry, OPC,

now the db is in one drive. We do have 4 drives. My database is already populate, its 523gb now.

1. Can I create new files in new drive but...

My database files are in 1 drive. My database has grown huge andwill keep on increasing in size. To better utilise the disk space and to manage the db, we...

Do we need to run Data Purity check?

Anthony

trying out sp_update_jobschedule. How to get schedule name of an job.

I would get all job names, schedule name and use the above stored proc to disable all schedule

Got below error:

Cannot enable the Service Broker in database "msdb" because the Service Broker GUID in the database (XXXXX....) does not match the one in sys.databases (YYYYY.......).

I dont have an...

Yes, i didnt want to update the systables directly. thats why wanted to find the best way to do this.

Running the sp_update_job is the best method and no other "Accepted"...

Thanks Roopesh,

As Gail said, been long time since i posted the issue. I resolved it, but dont rememeber how i did it then. In any case, will remember all the...

Do you guys foresee any problem with

[Taking backup of db and restoring the same db and changing the file location while restoring]

Example:

Database: Inventory

Backup Inventory

Restore Inventory (replace existing Inventory DB),...

Anthony,

Thanks. Let me try both the ways and get back to you on how it went.

arunyadav, thanks for the confirmation.

Thanks again "the ever dependable Anthony"

Again need a clarification.

If SSIS packages are run from jobs, while setting up job,

Can i give SSIS as the Type in job step. Is this correct?

or should i have...

Thanks much Anthony for the thorough explanation and immediate replies. Appreciate your help.