Our IT Director will notice unlocked stations and send emails from that account such as "Lunch is on me today!" or if he's in a cranky mood "I'm so stupid,...

A big thanks for posting this. A client's recent 2000/32 - 2008/64 migration missed an application call to the blowfish dll's and this saved our bacon this morning.

Hi Roy,

I kinda figured that. Just covering my, er, bases...

Thanks,

Vik

Stephen,

I ended up abandoning the linked server approach because I ran into issues calling the MySQL sproc from SQL Server. It was a while ago so I can't precisely...

Thanks to Jim for this, it helped me out greatly.

And thanks to Wendy for her dynamic SQL example -- this solved a major problem for me as well, namely being...

I graduated from Ryerson Polytechnical Institute (now Ryerson University) in Toronto with a BSc in Applied Comp Sci. in 1989. While I do now live in Toronto (the most...

For a large pilot project at a previous job I travelled from Toronto to LA 8 times in about 4 months.  Flight out early Monday AM, back home in TO...

What kind of lock are you talking about?  SQL provides its own type of locking used to guarantee data integrity.  These locks are controlled by using lock hints in TSQL...

Right now:

Music Has The Right To Children - Boards Of Canada

The Soft Bulletin - Flaming Lips

Sung Tongs - Animal Collective

A self-made mix tape of Lee Scratch Perry's best.

Decade - Neil...

Most "tech" fiction just ain't -- throwing some techie-sounding jargon around with a lot of flashy action-movie type toys just doesn't do it for me.  Clancy and Crichton are overrated...

Have you tried using SQL profiler to attempt to capture the offending SQL statements?

Also, I would consider removing the existing composite index and adding separate ones for owner and lock_time. ...

3 words:

Ranch Dressing Hose.

Neil,

I'm with Richard: forget Access for any kind of "serious" application.  Once you get beyond a certain number of users, i.e. 1, it's not very robust.  And if the term...

Yep, been there, done that.  This morning.

Fortunately the client involved was pretty cool about it: "Geez, that's the most excitement we've had around here in weeks.  And it wasn't even...

Hey has anyone used ReCrystallize Pro to generate ASP pages for Crystal Reports?  Looks promising and a heck of a lot cheaper than Crystal Reports Server:

http://www.recrystallize.com/

Vik