Unfortunately, I don't think I understand enough about your system to be able to make decisions about the database design. My own personal preference is to store similar data...

Oh yeah you asked about performance too...

I can't really say for sure since my application isn't in production yet (www.roushi.net). I would assume it would be similar to MySQL...

I didn't have to play around with triggers on PostgreSQL so I can't add much value there...

Views seem to be the same (other than the different select syntax)

Jobs and scheduled...

I think that it's good to educate more people on using INT fields in this way.

It's a great space saver.

Although it is much less confusing to use bitwise operators (which...

You could try this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\MSDE

Or just try to connect to each box on 1433 with sa <blank password>.

Gotta love MSFT,

DanW

I'm not sure what data type you are using for you boolean fields, but you could setup something like this:

create table test (b1 bit, b2 bit, b3 bit, b4 bit)

go

create...

This might be a bug with enterprise manager. Instead of using EM use the following SQL code:

This will return all triggers in your database:

select * from sysobjects where type...

This article contains all the correct MAPI32.DLL versions depending on your version of outlook. Verify that you have the right one installed... possibly reinstall Outlook if there is a...

I agree WA is very rarely secure. I don't know about you guys but I don't want any NT Admin to be able to hijack my databases. Also you...

Looks like a good config to me.

I don't think you will need the /3GB switch in there with the /PAE switch.

I know that I don't need it with my 8GB...

Andy has a good suggestion...

Have you tried rebooting your SQL Server?

I've had a MAPI 87 before on SQL 7 due to MAPISP32 being hung.

You can try to kill it or...

Unfortunately, there's not much you can do to find the login attempts other than profiler. If you narrow down the scope of profiler to just capture failed logins then...

I've never seen a difference documented for SQL Server. In Oracle count(1) is much faster because count(*) enumerates all the columns in a table before counting the rows. ...

Nazim is dead on.

Also, at this point you need to get the situation quarantined.

An IDS system would be a great benefit to put into place, but this requires a lot...

Well, then the first part should work for you.

Let me know if you have any issues.

DanW