How can I change the Select Top <N> Rows command in SQL SMS 2008

Try using row_number instead of TOP:

SELECT * FROM
(
select *, row_number() over( order by MyID) MyRowNumber
from MyTable
) T1
WHERE T1.MyRowNumber <= 1000

thanks for the reply rbeadie but I obviously didnt make my self clear.  The function comes from right clicking on the table and it automatically writes the query for you.  I want to edit this automated query so that it still pulls all the columns into the query but does not display them like this:
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [JobID]
      ,[MarketID]
      ,[CountryCode]
      ,[AccountNumber]
      ,[IssueNumber]
      ,[Status]
      ,[KeyRef]
      ,[Reference]
      ,[Position]
      ,[Skills]
      ,[Location]
      ,[StartDate]
      ,[Duration]
      ,[Contact]
      ,[Telephone]
      ,[Fax]
      ,[Email]
      ,[KeyLocations]
      ,[JobType]
      ,[Rate]
      ,[DatePosted]
      ,[URL]
      ,[JBEIssueNumber]
  FROM [Jobs].[dbo].[tJob]

I want the query to output like this:
SELECT TOP 1000 * FROM [Jobs].[dbo].[tJob]

Ah -- sorry.  I understand your question now.  I'm not sure that you can change that functionality.  You can change the number of rows that is your default, but there are limited changes you can make to the ssms generated scripts.

Guess I'll just have to put up with it then :-)  Thanks for the replies