I think that the best way for this is invoking stored procedures that validate requests.

For SQL Server, books by Itzik Ben-Gan work quite well.

Yes. The stored procedure does require parameters.

It doesn't have anything to do with SQL Injection. It's just that, as I was testing for that, I was wondering about the password storage issue. In addition,...

Hi GSquared,

I sent a proposed article to the article email address for SQL Server Central on June 27 but haven't received any notification that it was received. How many...

select @@version

Response:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on...

So what would it be for 2008 R2?

SQL Mgr Studio does not clearly label the DB engine as 2008 or R2 - it's labeled as SQL Server 10.50.1617. I had to redo the path specified. ...

Is SQL Server 9.0.5000 the same as SQL Server Express 2008 R2? I think that's what I got with VS 2010.

At:

ALTER DATABASE [SecureSchool] SET COMPATIBILITY_LEVEL = 90

GO

I get the following message:

"Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '90'."

Here is the script. Version is SQLEXPRESS (SQL Server 9.0.5000) also (SQL Server 10.50.1617) I tried both.

---------------------------------------------------------------------------------------------------------

USE [master]

GO

/****** Object: Database [SecureSchool] Script Date: 07/11/2011...

Thanks for quick response. I ran all the code just before this line and it completes successfully.

Hi GSquared,

Are there any guidelines for an editorial as opposed to a post?

Mike

Jeff,

I would be happy to review your preliminary article. I'm sure I will learn a great deal in the process. I might even be helpful. 🙂

I will try...

Jeff,

Thanks for your kind words. You put a big smile on my face. I don't what else to say but, "Thank you!"

The tutorials would use both English, that...