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...

Have you checked if you have more than one instance of SQL installed? Also, are both IP's on the same server or different ones?

Not sure if product codes would be unique for same product installs on different servers... although reading a value from registry sounds interesting as well...

If you assume that you will not have 2 SQL server instances with the same servername, you could maybe use either the checksum or hasbytes function applied to the servername...