when u right click on my computer u will see manage there u can create user....right click on user u will find properties there add it to administrators...

create one account on ur machine right click my computer go to manage create user give name SQL_proxy..

now add that user to administrator gr over there

now create same user in...

Link given is script level...

You can do this by...

Do run services on that proxy account.

Nikhil (3/13/2009)

---

simon.letts (3/13/2009)

---

Hi thanks, but my question was whether I can remove it. I appreciate what its for but dont understand the point in removing accounts from sysadmin only...

simon.letts (3/13/2009)

---

Hi thanks, but my question was whether I can remove it. I appreciate what its for but dont understand the point in removing accounts from sysadmin only to...

iainthepitman (3/4/2009)

---

yep. as far as i'm aware, the differntial backup only records data changes since the last differential. so if you need to restore to the 29th differential,...

Thanks all for your valuable reply.!

Problem was with dump.May be dump was corrupt

when i install from CD it worked. sorry for wasting your valuable time!

I am installing client tools.

It allows client tool.

ya thanks!!!!!!!

it is working fine now with temp table

Brandie Tarvin (2/16/2009)

---

You can accomplish this output in two ways. The first way, as earlier suggested, is to write a stored procedure and put everything in a temp table, then...

Ramesh (2/14/2009)

---

I don't know why it's not working in EXCEL, but I know this task can be done without cursors. Well, in fact, it is just a simple SELECT...

SELECT...

chandramohann (2/15/2009)

---

Hi Nikhil,

You have to first understand first sp_msforeachdb works. It initially executes for master database and sends the output and goes for next database and...

DavidB (2/13/2009)

---

My guess is that this is due to the way the sp_MSForeachdb actually works in that it runs the statement in the database then moves on with each statement...

Thak you all !!!!!!!!!

sorry rajesh but query is working fine in all databases.

dont know wht happened with you..

Also guys i got the solution..

it is resolved now.

All i needed to do...