Not sure you have a lot of choices..

CEWII

I'm a little fuzzy what you are asking.. An SMTP relay is just a server that passes SMTP traffic for you. It is really no different than any...

I don't think this is a good use for synonyms..

Why don't you tell us what problem you are trying to solve. We can probably give you some guidance..

CEWII

I found me a site that had the data for free so I loaded it.. But I agree it did not make a huge difference.. I'm wondering what...

Your clustered index is on Lat/Lon?

SELECT t1.*,

DistanceInMiles = dbo.fnDistance(t1.Latitude, t1.Longitude, t2.Latitude, t2.Longitude)

FROM dbo.ZipCodes t1

JOIN dbo.ZipCodes t2

ON (dbo.fnDistance(t1.Latitude, t1.Longitude, t2.Latitude, t2.Longitude) < 10)

WHERE t1.ZipCode='10029'

ORDER BY DistanceInMiles

Changing from t2.ZipCode in...

Is the field ZipCode in an index? And I'm curious about the fnDistance logic, what are you using?

CEWII

This *may* be the right method..

However, if there is any need to get the clear-text version again this...

No. Sorry..

CEWII

I believe the answer is yes. I haven't seen it myself though. In SQL 2000 it was EASY. In 2005+ I don't think it is so easy.....

1. Add "WITH ENCRYPTION immediately before the AS statement..

CREATE PROCEDURE dbo.ProcedureName

@Variable1 int

WITH ENCRYPTION

AS

Save a copy of your sproc elsewhere.. Lock it down.. That...

Sorry, I was completely forgetting about the other calendaring methods. Ah, American thinking.. Gotta love it..

CEWII

Then I stand corrected.

But that doesn't seem to be obvious though.. The dateadd function in particular, what variation is there to adding (or deleting) time that would...

I am most intrigued by this statement "i can locally login to the Management Studio. " Can you not loging form elsewhere? If not then check to see...

You are welcome, had the very same problem last year..

CEWII

Maybe we should ask Steve to add a "Whoop upside the head button".. That guy in that post just didn't get it.....