Identities alone shouldn't cause Access issues.

However, I can see issues with your trigger when you update multiple rows. That would cause issues.

I didn't think it was a good design, and not sure it really saved space, but I knew it would generate discussion. Lots of people, especially developers, think this way....

There is a NYC group run by Joe Lax.

http://nycsqlusergroup.com/default.aspx

Philly and New Jersey (http://njsql.org/Default.aspx) have groups as well.

Office 2000-2003 formats should work, but a jpg/gif/png would be better.

However, there is nothing in that image that provides information. It's a shot of Configuration Manager that doesn't even show...

You'd have to check each database (sysusers) and join back to syslogins.

ms_foreachdb will help you.

GSquared is speechless? And so am I after that.

You shouldn't need admin. Local Service, Network Service, or a domain user account with minimal rights is recommended.

are you changing the service account with the SQL Configuration Manager or just...

I would suggest the default trace as well. There's an article here to help:

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

It looks like you're comparing dates in a function of sorts. That can be slow. If you can calculate those dates out for a query and store them in variables...

Honestly I think you're on your way, but to tackle more types of issues, do what you just did. Post on forums, or answer questions. Solve other people's issues. Tackle...

It's an interesting look from a developer point of view. Compared to the power and speed of the relational engine, I think space savings are a minimal thing to worry...

http://www.sqlservercentral.com/scripts/Miscellaneous/31793/

If you have specific issues, send them here.

There can be a cost to pulling all that data back together from multiple processors, so the optimizer tries to make an efficient...

Do you mean it displays that way when you view it in SSMS?

The date data is stored always the same way. It's an offset from a base time value,...

a local temp table is available only to the connection that creates it (that SPID).

The global temp table is for all connections.