Okay, okay, I'll help you a bit with searching

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

http://www.aspfaqs.com/webtech/062899-1.shtml

http://www.google.de/search?hl=de&q=sql+server+paging&meta=

Why is there no Primary Key on that table? Almost all solutions you will find when you search the fora here or google for SQL Server and paging will rely on...

Have a look here for a large database in SQL Server:

http://www.microsoft.com/sql/techinfo/administration/2000/rosetta.asp

I might be wrong, but I don't think there is an easy for this in an existing table. I would guess the way looks like.

- add a new column (tempcol)

-...

See if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=153114

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=16769

Read Jonathan's response there. And ignore the strange formatting as this was written in the former forum software package and migrated.

For your question specifically, here's the management summary:

1. Production...

See if this provides additional help:

http://www.karaszi.com/sqlserver/info_datetime.asp

http://www.pinnaclepublishing.com/ME2/Audiences/default.asp is another one. I think, given the three alternatives now, this is the most expensive one, which might the K.O. criteria here.

Any reasons why you are still on SP1 ?

Did you read the article? The fn_* prefix is only requirement. Additionally it *must* be created in master, be named all in lowercase and be owned by the system_function_schema. These steps...

Well, the problem with that is when the table is created, I do a

create table(

TableIdCol...

primaryKey(TableIdCol)

)

So, now you've got a good reason to care for the names of your object...

alter table ... drop constraint < your name > should do

Are you saying, this could be optimised?

You should make up a new thread for these new questions. Most people will scan the subject and therefore might miss this one. I for myself don't know anything about...

Piggy-backing on AJ, every now and then one can read, that you can workaround this "limitation" by utilizing a view. Now, consider this:

USE northwind

GO

CREATE VIEW foolview

AS

 SELECT

  GETDATE() AS Jetzt

GO

CREATE FUNCTION...