I get: " Incorrect syntax near ','

You have to specify a db name.

Edit:

Heheheh - I see several others have latched onto the incorrect correct answer conundrum too. Mgilchrist = bad...

Besides adding security review, I'd get another copy of the database running elsewhere and the app - space and resources permitting of course.

If you're following good change control practice -...

I think change is inevitable, And for the greater good of mankind.

To ignore change is to get mired in the past, not something I would like if I work in...

I'm a lefty. I also left click with my midde finger on my left hand, and when I swap the ambidextrous mouse to my right hand (2-4 times daily) I...

Real Steel gets my two thumbs up. My Fiance and son also enjoyed it and she normally avoids Sci-Fi movies like the plague.

Nasty, but great question. Tricked me! 😎

Hi Matt,

Thanks for the reply.

I'll get to work and build a rock-solid method of calculating Somersd and put the results here.

I have access to Quants and Analysts that thrive on...

I'm starting to think I should've labelled the thread: Anyone up for a challenge? 😀

Great, thanks for the answers so far.

I'd like to move to Windows Auth as there's less admin involved with extra passwords, users getting locked out, password policies, etc.

The IT Department...

Couldn't have explained it better myself.

From past experience cursors are okay if you're planning to get results in under a few hundred or thousands. Once you start looking at...

My two and a quarter cents:

Build an Encrypted Stored Proc thats used for logging in or checking prices (something that is used every session) build into it a delete from...

Great Job! Nicely explained too, although it looks like someone's got too much time on his hands

Thanks sswords. This machine is live so any changes are quite difficult. I will try other ram and let you know.

Hi Garrick,

First off I can answer point 1 from personal experience the rest I can only surmise (I'm not a Domino kind of DBA/Network specialist):

1. If the domain user account is used...