Here is what I think. Even if you could, should you? This is one of those things that I think should be left alone. There is a...

I have to agree with...

rjv_rnjn (8/17/2009)

---

GSquared (8/17/2009)

---

While this was beginning to feel like the credits for Monty Python's Quest for the Holy Grail ("those responsible for sacking the people responsible for the credits have...

Just...

To be honest, I think I'm underpaid. I work hard, get things done. I don't have any MS Certififications, though I'd like to get the SQL Server certs,...

Using the schema name in a query is preferred. It helps the system determine what table/view/procedure/etc is being accessed or executed without having to go through default schemas and...

jamie (8/17/2009)

---

it's supposed to be UTC time (by design) I believe for consistency between servers in different timezones, etc. So I'd check the timezone on your server to start....

ta.bu.shi.da.yu (8/17/2009)

---

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier (how do...

Based on the error message, I'd say you have a user accessing the database. You may want to run an SP_WHO2 and see who is using the database.

rambilla4 (8/16/2009)

---

Hi,

I have configured Log shipping in Sql server 2005. I'm confused with date format that the transaction log backups showing. The transaction log backup ran through the backup jobs...

anam (8/16/2009)

---

Sorry for any confusion. I agree with you on your following points

YES

The problem...

oo sure, but is this what you are looking for?

select

db.[name] as DatabaseName,

db.[create_date] as CreateDate,

mf.[name] as LogicalName,

...

anam (8/16/2009)

---

As masters above have mentioned, it wont break the logshipping process until Enable the Explicit Log backups. Any log backup done will have different (next) LSN and the destination...

Garadin (8/16/2009)

---

I think this is the longest thread I have ever seen. I read page 1 and page 248.

As to whether or not the posts have gotten...

Not much that can be done until you resolve the problem with the destination decimal(1,0) or tell us what you want done with...