There is a password policy in SQL Server 2005, and if the host OS supports it, SQL Server can respect that. I thought the SA account was immune, but...

Agree with David on this one. Nothing should blow up

Be curious to know why stored procs are a nightmare for insert/updates.

sprocs encapsulate functionality, make it easier to maintain, IMHO for everyone. Cut and paste on the client means the...

Be sure you check the logic as a SELECT first.

http://www.rentacoder.com as well

Borland C++, ah, those were the days.

Used that in 91/92 to write some small utilities for a Novell network. Worked better than Visual C++, as I recall.

Not that I know of. You need to add the user.

A good reason to have a script to create database instead of using the GUI. Let someone change parameters at...

I don't think there's a way to do this. I thought someone had done a GRANT EXECUTE on a schema, but not sure if that would work.

The thing to do...

You could create a computed column and do something like identity + 1. Why can't they see the identity?

Christopher,

No idea how it's used. I haven't messed with it, but I'm sure someone has.

I know it's based in reality, they have real CSI people consulting on things, but it's exaggerated. Each person has many more cases, less space, and less equipment. Tests take...

That's a scary thought. Google has a lot of information about you, but it isn't necessarily related. With their API, I suppose some of it could be mined.

Definitely a good...

Check the local "hosts" file. Be sure there's not an overriding entry there. Though I'd think that would prevent other issues.

What about an alias in the client network utility? A...

I think you have to put those up as attachments. There are always some things like XML that the forums have trouble converting.

Not sure offhand what's wrong in there,...

I go this from a developer at MS:

= = = = =

Yes, using DQ, the Jet OLE/DB provider, and the Excel IISAM.

I recommend you get the Jet Programmer's Reference Guide...