Why would you want to do that? You can't.... turn off the SQL services and you'll have access to them.... but careful, messing with them can render an unusable SQL...

Idera's SQL Diagnostic Manager includes the SQL Mobile Manager that lets you do that and much more. Of course, it is a steep price if only or that product.... plus...

Now, with Gail's explanation and what the OP did (take out of read only, Full backup, back to read only), the LSN for the Full backup registered would the one...

I guess that being in read only mode, some things just don't get logged/updated (not even in the master db) hence the "refusal" to do a log backup no matter...

Just curious. If it is a Read_Only DB, why changing it from Simple to Full recovery? You would need Full Recovery if you need to do a point in time...

Jeff Moden (3/17/2010)

---

ramyours2003 (3/17/2010)

---

iam facing problem in my production system that the jobs are taking longtime from past days to complete , even backup jobs are...

You can't shrink it if there are open transactions.

You might want to try:

DBCC OpenTran (LogFileName)

to find out what SPID is the offending one and take proper action on it.

As far as I now you can't change the subject on those mails. You will have to include another step(s) in the job that does send the e-mail depending on...

subbarayudu, you seem to have an awful lot of "simple questions" that can easily be found by using the SEARCH feature on this site.... Besides that, BOL has a wealth...

There is no difference in pricing between 32 and 64 bit, only between different editions of SQL Server.

I believe you can't buy SQL 2005 license anymore. All licenses purchased now...

Good question. As a matter of fact I was just researching this yesterday. A good link ti that is here.

Both SQL Diagnostic Manager and Spotlight offer that functionality you are looking for. There might be some other tools, maybe from Red-gate that have simplified functionality for that.

We decided to go with Idera's SQL Diagnostic Manager[/url]. It is pretty similar in functionality as Spotlight from Quest[/url]. It didn't require any module or service installed on the DB...

Brnbngls (2/12/2010)

---

If not for the fact that for the last week or so I've been messing with sp_Tables_ex and sp_columns_ex on Linked Oracle servers, I wouldn't have known about sysname...

Indeed, but what I don't get is that about 33% of respondents think it is a...