CREATE RULE rl_BeforeNow AS @dtDate < GETDATE()

The date thing is an absolute pain

I have standardised on using yyyy-mm-dd as my date format in my applications and therefore my SQL always...

I take your point on upscaling webservers.  I wish I knew more on the infrastructure side.  Come to think of it, I wish I knew ANYTHING on the infrastructure side

Strictly speaking yes, it would be at risk from an injection attack, but not in the case of this particular CMS.

The execsp portion tells the CMS that this is a...

We develop a lot of UK government web-sites and accessibility is a major issue.  That is, could this site be used by someone who is blind, can't use a mouse...

I don't agree because the topic id is not private information.  In fact in the live application the topics are SIC codes so the SIC code is actually displayed on...

Steve,

It's your site but the only post that could have generated more flame would be a "do you think you a DBA should take a gun to work to deal...

Has there been a sudden reduction in disk-space on your server?

What size are your log files?  Are they expanding at some point during the backup?

We had a situation where a...

I have had this joyous thing happen on a couple of occassions.

I couldn't see anything wrong so I got the web page to write out the SQL statement that it...

I've had a couple of experiences like this.

I went into the server room to find a layer of smoke covering the top 6 inches of the server room, but no...

No, what I meant was that I started with two tasks.

1. Run the SQL to Access download DTS.

2. Run the copy of the downloaded file from the DB Server to...

From my own experience, if you have very large tables then rather than joining them together for a query you would do use temporary tables to store the results of...

Thanks Kathi,

That's what I did in the end and it seems to have worked OK.

I had a bit of a struggle getting DTS to set the precedence of the copy...

Why not use MSDE?  There is an installation folder somewhere on the MS Office2000 CD.

This way you wouldn't have to butcher your existing code.

I've found that MS Access (running the...

CREATE PROC qryOrderInfo AS

SET NOCOUNT ON

SELECT orders.*,

products.ccode,

products.cname,

products.cprice,

oitems.numitems,

customers.*

FROM customers INNER JOIN orders

ON customers.custID = orders.ocustomerid

INNER JOIN oitems

ON orders.orderid=oitems.orderId

INNER JOIN products

ON oitems.catalogID = products.catalogID

qryOrders

CREATE PROC...