Using sps and roles will recuce your surface area, but there is always the possibilty of someone using access or MS Query to access your database.

Now, it is possible to...

Use stored procs and views to hide the tables.

Ensure the user is not sysadmin or db_owner.

Use revoke and grant to limit permissions via usual roles.

Quite simple really..

You should be in...

It's best practise to qualify objects with the schema anyway.

If it is absolutely necessary, you could try "sp_addalias", but I can't remember how it's used (been so long...). I'm not...

Following on from Chris, don't forget SPACE() to add a fixed number of spaces in a string

I've enjoyed reading this thread.

I was reading CVs for my job when I left my last place (cool - pick your successor) and the rubbish we were sent. Senior SQL...

You just go into the Server netowkr utility and stop SQL listening on named pipes.

It makes no difference to your clients for XP and later MDAC versions because...

Because of the extra layers of rendering.

One stored proc can return multiple result sets, did you know

asp.net can handle it, I dunno about asp.

There are articles on it, but I don't...

Don't forget an IO filter driver such as Antivirus, 3rd party backup solutions etc messing things up

This may be from the same MSN post above but read these:

http://msdn.microsoft.com/SQL/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_04222005.asp

and

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

The first article has some read world examples seen my MS SQL PSS

First thoughts - latest...

I'd say this would be slower. Or are your SQL and IIS on the same box, always a no-no

Bit of an odd way to to do it but try "text" datatype.

But then you have the problem in that the functions and operations you can use are a limited.

So, you...

Good call, SQLBill.

My thoughts exactly.

The way I look at it...

NULL means unknown or undefined.

Which is not nothing, Nothing means you know you should have something.

So how can you use '= NULL'? Or equal to...

At a wild guess, are the datatypes all the same (smallint or int)? No float or real or decimal?

The poster said OLTP so RAID 1+0 and they never mentioned having a SAN.

He did say mission critical and performance is very important.

HP do a AMD based DL585, which are...