Nice article,

Here is a site dedicated to sql security: http://www.sqlsecurity.com

You'll definately want to run a tool to scan for easily guessed passwords too.

I found a few on my...

Here is a code revision for you, but it sounds like you might have some mapi issues too. You might want to try starting mail and sending an email...

Here is some code that I wrote that you can alter.

This is for a custom database so ignore what it's doing and concentrate on parts of the structure that you'll...

I wouldn't suggest doing this for a publicly accessible website because it's probably going to open up a security hole. Any user accessing your site will have access to...

Try this instead:

create table #tmp1 (result int)

insert into #tmp1 exec(@sqlstatement)

select @count = result from #tmp1

also an fyi... string or varchar values in mssql are encapsulated in single quotes, not double...

SAN (Storage Area Network) Support is determined by your operating system and not by SQL Server.

To MSSQL A SAN is transparent and looks just like a regular hard drive. ...

... you know how to pronounce PostgreSQL.

... you dropped all of your extended stored procedures in SQL Server to prevent security holes.

... you find yourself explaining that "fixed width" means...

Thanks!

I didn't realize you could use the alias there... works like a charm now.

Dan

Here you go:

http://msdn.microsoft.com/library/en-us/whatsnew/wn_whatnew_7im0.asp

I agree for the most part...object ownership can be a real pain if everyone is allowed to create objects. There are some pretty strange circumstances where object ownership can...