Hey, I don't advocate creating user-defined things in master. I would rather prefer your approach with a separate DB for this, but the OP wrote "reply asap", and the "master"...

Doesn't make too much sense, but you'll get the idea:

USE PUBS

GO

SELECT *

FROM authors

ORDER BY

 CASE WHEN au_lname ='Green' THEN 'ZZZ_'+au_lname ELSE au_lname END

Right-click on the server in question -> Edit SQL Server Registration Properties -> Uncheck Show system databases and system objects.

I don't know of a way to do this in SQL Server 2000. Even if it would be possible, you wouldn't want to do so.

Yes, there are certain system...

Can you verify this?

Create it in master and prefix it with sp_

FWIW. Here's another approach for the lazycoder:

SELECT REPLACE(STR(ST.GR,2),' ',0)

There is no need for a CASE here anyway.

Another way would be:

SET NOCOUNT ON

CREATE TABLE note

(

 col1 VARCHAR(8)

)

INSERT INTO note (col1) VALUES('Notes1')

INSERT INTO note (col1) VALUES('Notes2')

INSERT INTO note (col1) VALUES('Notes3')

INSERT INTO note (col1) VALUES('Notes4')

INSERT INTO note (col1) VALUES('Notes5')

INSERT INTO...

Yes, and since last year I haven't found an explanation what indid 251-254 are used for. I don't suspect them to be reserved for future use, since indid is of...

Let your work partner give you some more details.

SQL Server alone won't do this automatically. However, if someone has fired a DBCC CHECKIDENT to reseed the IDENTITY property, SQL...

Creating a trigger on that system table would be way tooo easy. You have found out already that you can't do so. And...

If the row count of *any* query exceeds the range of an INT, you'll have other more serious problems than row numbering. I would start with adding a WHERE clause....

I might state the obvious, but you know this one?

http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750

Nicolas, thanks for this!

Dale, no haven't had a single look to SQL Server 2005 yet. When the RTM version is out it's still early enough to play with it.