Not knowing what you are actually trying to accomplish, hard to say. I don't want to just take shots in the dark and hope it solves your problem.

Misread the question, read it that the OP wanted to rename db_datareader.

Anything in SQL Server error log?

Just trying to make sure that the following error is the complete and only error message you are getting:

Error 1053: The service did not respond to the start or control...

Going out on a limb here and will say no.

Can you tell us anything more regarding the error? Is there more in the error logs that could help us help you?

Really can't help you based on what you have posted so far. We can't see from here what you see there. Please post the code you are working...

Follow this lmgtfy link. Look at the first result returned. It may be a good starting point.

Start here:

http://msdn.microsoft.com/en-us/library/ms141821(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms141775(v=sql.90).aspx

If your servers are using mixed authentication you should also change the sa password, unless this will break any of your applications. If the latter is the case, look...

I am curious why you are formating the output in the SQL code. What you are asking for should really be done in the UI.

Yes, there is. Use DELETE FROM yourtable.

Krtyknm (3/26/2012)

---

Hi Jeff,

Nice Article, Keep going.

I have a question on sys tables, most of them using the Sys.tables for generating random numbers. Assume that developers don't have an access to...

Hard to tell you anything with as little information you have provided. We can't see from here what you see there. You really need to provide more information,...

Be sure to check all the log files. You may find something in one that points to the problem.