Steve, if you can, I'd go with a separate database for each client, single SQL Server installation. If there are some issues between installations, this should protect you.

If you have...

Stupid avatars, not stupid question. It's some very strange security issue that I have not figured out. Send your picture and registered email to sjones @ sqlservercentral.com and I'll upload...

There's been quite a few bypasses over the years, geletin moldsd and more.

Whoever posted about the storage in AD, that makes sense. However the problem is still we take these...

Checked system monitor for anything eating up IO/Memory/CPU?

Strange. Not sure why it would be slow. You running to new files or the same file over and over? Or appending?

What's the...

For Dev/test, it's fantastic. We used to create images of a setup, then shut down VMWare and back up the file. Start it and run testing. Need to restart? Shut...

OK, it's been changed to say a budget of $1500.

And great debate and points raised (other than about my choice of words )

Duane

Thanks for posting and glad I could get you to think

I thought SSIS was supposed to be much faster than DTS, though to...

I was kind of surprised at the response, but nice to see everything thinking about their career. And I'm glad that I'm not the only one that likes the relatively...

The only way is through network/firewall or an OS firewall limit. The IP coming through to SQL Server is submitted by the client and not necessarily the real IP. By...

The original poster is talking about logins. Database access is through USERS, not logins. There is a mapping, but if you call them both logins you'll get confused.

If a user...

I didn't think we had orphaned transactions in SQL. You can use dbcc opentran to find open transactions, but I thought that if the client dropped the server would rollback.

Looks like one of the tasks if failing. Can you provide details on this task? Are you sure it's configured correctly?

Great list from Antares above and while I agree life is easier for the Windows team, it still needs to work for you and your clients. The hardware resource issues...

You could report it to MS. AFAIK, this should never happen. My suspicion is the data got put there, possibly without your knowledge. The backup stream processes pages from only...

I do think Microsoft has done a great job and I think their pricing is actually fairly low. Doesn't seem that way for a monopoly in places, but I remember...