Actually, there is a better more fool-proof way besides "Select @@IDENTITY". The way @@IDENTITY works is that it will return the Last Identity Value entered for the ENTIRE Database...

I guess going along with this Topic, does anyone have a Design for a History table that would encompass any Table (all my tables have 1 Pri-Key)? I guess...

Ok, I finally got it to create Backups locally. I had to Right-Click on the Database and Choose "All Tasks..." then choose "BackUp Database". In doing so, it...

Heh, sorry, must have missed it...still waking up here...

Ok, but what if later you find you need more than 8 questions?

Why not make it relational. Have a table called "Questions" and a table called "Answers". Maybe...

No, we're using BackUp Jobs in SQL Server 2000 Enterprise Manager.

Ok, disabled Norton and configured to not touch MDF's or LDF's. However, I can't remember if I tried Backing up when users were not in the Database. It's...

Ok, I'll check that.

You can do two things, but first, buy a Barcode Font...

1.) Use an Access 2000 Project to hook into the SQL Server DB and then utilize Access for Reporting.

2.)...

Although this site (www.codeproject.com) is mostly C#, it can easily be converted into VB.NET. There is a VB.NET section as well. Some of the most advanced code I've...

Start learning C# or VB.NET.

You can't...use Tabel valued Functions! Their Great <Tony the Tiger impression>!

Well, that all depends. You can also make a UDF (User Defined Function) that will return a Table of the Strings (one string per Row) which returns only one...

What I did was use an NVarChar(50) Field "Password" in my Users table (but I only allow a 25 Length Password). I use my own Encryption methods from the...

If you're talking about someone who sits around and just designs databases...I am not so sure many jobs exist like that? I know where I work, just about every...