edit

Agree 100%

Although I'm currently...

dhamilton-905368 (1/25/2010)

---

...most stored procedures (which I won't personally do db CRUD without) should be prefixed with "sp".

...Additionally, to follow the lead of Microsoft, _I guess_, they prefixed...

thanks, that's pretty useful, even though we still need to do a bit of legwork to associate the logins with the linked servers

a "sp_linkedserverlogins" would be nice, just because i'm...

Apologies for digging this one up from the dead but just wondering why there wasn't any discussion on this previously... although I'm not sure if it is the most efficient...

dongadoy (12/12/2008)

---

How are you executing your simple TSQL to get the error? In an SSMS query window? I've seen this error when executing from a SQL Agent job because the...

FNS (12/11/2008)

---

I've seen this error when the account used for the...

SQLZ (10/31/2008)

---

I think the problem here might be that you're converting to varchar, and then SQL Server tries to implicitly convert that varchar values to datetimes.

Try and convert them to...

Thanks guys

Garadin/SQLZ - thanks, but the problem is (sorry, didn't mention this!) that using CONVERT does work ok on that field, but I can't use it in comparisons against...

Anirban Paul (10/21/2008)

---

As a new author I appreciate your article. But the article failed to provide a clear cut answer why we should upgrade to 2008 from 2005. Our company...

Thanks Michael - yeah I missed that out of my post but peer-to-peer transactional replication was my other thought - that's a great article there and, going by that and...

hug.newsletter (10/3/2008)

---

This is exactly the type of solution I come across every day in our organization and I absolutely hate it! I'm not criticize it from a technical point of...

Good article, thanks

Exactly....

I'm glad 60% of people were also wrong 😀