It would be helpful if you could provide more information like table structure, the update statement.

Without knowing more an answer will be like a shot in the dark.

I am too young to know this (haha). Members older than 35.5 to the front.

Btw, happy new year, Jonathan <grin>

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Does the new menu system already work?

I am not able to open the articles page

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Hey Steve, wouldn't this make a good case for another detective work like in your page size article?

...if not someone else comes up with the solution.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Flipping through MSDN, BOL and other I found no real explanation why there is this theoretical limit, but I think that 249 indexes (including PRIMARY KEY and UNIQUE CONSTRAINTS) are...

Sorry, actually more information you'll find in BOL under PATINDEX()

quote:

---

...

Remarks

PATINDEX is useful with text data types; it can be used in a...

Reading the thread and my post I think you should foret it!

Sorry if it has lead to confusion. Should teach not to concentrate on other things while posting.

You mean you need more indexes on a table ????

Frank

http://www.insidesql.de

http://www.familienzirkus.de

AFAIK it is not possible to directly pass GETDATE() to a UDF (sorry!)

This might be a workaround

CREATE VIEW GetNow

AS 

SELECT GETDATE() AS Now

GO



CREATE function sampledate ()

RETURNS...

Ah yes, I forgot your almost non existent dismissals protection .

It could also be viewed from exactly the opposite point of view:

5 jobs -> 5 years ->...

I'm not sure if a 'normal' user (even the original questioner himself) should be able to close a thread. Such a feature could easily be misused or not used in...

Well, building the statement at the client and sending it to the server might make you more vulnerable to injection.

Building it at the server and execute it within a...

You need the ADO Stream Object and a reference like this http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

For general information this might be useful http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

Frank, what would you want us to do if we did store your timezone?

---

Consider this...