Well, this is a "brand new" feature (not a bug) in ADO.NET!  This is not a limitation of SQLServer.  In ADO 2.x, I used to use the strategy of making one...

In my opinion, I would never in my life use an Identity field.  But that's because I've created my own Synchronization program rather than using Replication.  Identity Fields are very...

Umm, yeah...read up on ADO.NET?  I would start by doing some research on the subject before posting something.  However, I have pity today...below is a VERY generic routine...

Nice site...responsive ! Yo deseo yo sé más español ! Quiza necesita agregar localización para unas idiomas múltiple? What app did...

I got around this issue by using a "SmallMoney" data type instead of Real, Decimal, or Float. When I tried using the other data types, a Value of "4.5"...

That all depends on what you're doing with the Data...in other words, how do you plan to display this data?

If it's in a User interface, your recursion code should go...

Yes, MSDE DBs are limited to 2GB. You can, however, move some of the data to a "Historical" DB in the same Server because the 2GB limit pertains to...

Umm, you can't stop Access (or SQL Server for that matter) from interpreting NULL Dates as "12-30-1899".

There are two solutions. Read in the data using DTS and make a...

Any SQL Server Tool will work with any kind of Instance of SQL Server (including MSDE). Just attach a new server from within EM (Enterprise Manager).

From what I can gather (which isn't much), why not just make your Date field in the Parent Table the Primary Key? I can't understand why you have a...

Yes, although any table I have with a numeric Key is only a lookup table and gets modified once every...couple years? =P

Thanks for the input guys, this isn't really for me...I just needed proof for someone else =P. I'd actually never, ever use a Composite Key. I always try...

No, bdohmen is correct, use the "Scope_Identity" so that you're retrieving the ID from the Scope of your Application (i.e. Insert). I have been using Ident_Current('tablename') in my stored...

I speak of "updates" in a generalized manner. An update would be any Insert or Update statement.

With Disconnected Recordsets, I try to make it a general rule that during...

Ok, maybe you have a Link to Database Normalization rules I can read? I know I've read it before, but I don't have the book anymore...