I guess you can skip the entire "proxy" part only.

You can create a job and assign the ownership [run as] of that job step to different domain users as per...

Thanks Yoel.. Yes.. I am now getting good support from them

Thanks for the guidence

Regards

Utsab Chattopadhyay

Hi Lee,

Please follow the below steps:

Sql server agent --> jobs --> select the desired job --> right click and select properties --> select general tab...

Yes Lee. Each job can be owned and executed by different domain accounts with required privilage.

Regards

Utsab Chattopadhyay

Hi Rob,

Plz try the below steps:

1. Script out your original database

2. Create a new database with new name using that script. This will ensure that all objects are present under...

Hi

To battle this issue.. I have decided to move the problematic table to SQL 2005 and then using SQLCompress.net for a column level compression. [www.sqlcompress.net].

In...

Hi All

Thanks all for your analysis and sorry for the slow response. I am planning...

Nope!!! There is no built in account named SYSTEM

If u created db after logging in as  a domain user.. it must show the domain account as the db owner. So may be the db u r referring is...

Thank you guys for the helps… I got the issue resolved with moving some tables and adding a new .ndf

Regards

Utsab Chattopadhyay

Hi

Thanks for the helps. One more small question ..

What will happen to the existing tables in the .mdf when I will add data to them? As .mdf is capped,...

Thanks a lot.. I used the script and the system is working perfectly now...

Regards

Utsab Chattopadhyay

Thanks guys.. but I am not looking for xp_fixeddrives.. As it cannt return the total space. I am designing an alert system which will monitor the server's hard disc from...

How about scheduling the job restart using Task Scheduler of Windows itself? I am just wondering. May be there is a better solution than this.

Regards

Utsab Chattopadhyay

Pl refer to SQL Server Books Online. It's a good resource.