You should remove the login entirely. Seldom should all network admins also be SQL admins. Even if you're not clustered, the instructions here are relevant:

http://support.microsoft.com/?id=263712

--Jonathan

http://support.microsoft.com/?id=246133

--Jonathan

Must be in master, prefaced with "fn_" and added to system schema, e.g.:

USE master

go

CREATE FUNCTION fn_Pad(@i bigint, @p tinyint)

RETURNS varchar(20)

AS

BEGIN

  RETURN RIGHT(REPLICATE('0',@p) + CAST(@i AS...

If you're "saving" the local data every half-hour, don't you already have it locally and therefore do not need to "return" it from the server?

I wouldn't use a view or...

Seems like a good candidate for an artificial key: a four byte integer (or perhaps a two byte smallinteger) rather than a 16 byte key of concatenated char columns. ...

I don't have enough information to give you a definitive suggestion, but perhaps create a units table and a conversions table and then have columns for both measurement and unit...

quote:

---

I appreciate the conversion statement but I really need to know how to autoatically populate that field date_entered without supplying the date...

Frank--

Yes, we seem to have interpreted the question differently.

Couldn't your loop be replaced by just a set-based solution?

WHERE @sz1 LIKE '%[0-9]%'

Or, more to the point of...

WHERE ISNUMERIC(STUFF(ColName,1,CHARINDEX('-',ColName),'')) = 1

--Jonathan

The methods oulined here:

http://support.microsoft.com/?kbid=186133

will give you "golf tournament" types of ranking, where ties get the same rank and then skip the next rank number. Test the performance vs. your...

quote:

---

If you set SQL Server memory to be dynamically allocated, shouldn't it automatically leave memory for the O/S, etc.?

---