What is the ¿ÀÀü characters for am/pm?

Like to think if you remove the ¿ÀÀü it should work, specially with yyyy-mm-dd.

What is the korean default date format.

Have you tried set...

Check BOL 2000: UPDATE (Level 4)

The 6.x example may give a hint why it was changed. I think the update can be a bit ambigous to resolve. Example one can...

Just found this article http://support.microsoft.com/default.aspx?scid=kb;en-us;282286

Why I ask about 365 x 24, is there anytime of the day that one can get all the users / locks of the database. In the article, another site...

Is this a 365 x 24 system?

See article at http://www.sqlmag.com/forums/messageview.cfm?catid=3&threadid=9568

800 hours / 24 = 33.33 days

What is the database size / processor / memory / disks of this machine?

Do you use SQL Server SQLMaint?

Can you Restart SQL and check if problem 'go away'. Another person suggested detach/attach

Articles(bugs) at http://support.microsoft.com/?kbid=814579 and http://support.microsoft.com/default.aspx?scid=kb;EN-US;317375

Have a look at Frank's reference at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15691&FORUM_ID=9&CAT_ID=1&Topic_Title=ntext+confusion&Forum_Title=General

Try DBCC OPENTRAN, see BOL 2000.

Do you run replication on the database

Create View MyDate as Select GetDate() as TheSystemDate

GO

Create Function SomeFunction (@CustomerCode Int) 

Returns VarChar(20) AS

Begin

Declare @Year Int

Select @Year=DatePart(Year,TheSystemDate) From dbo.MyDate

Return(Cast(@CustomerCode as VarChar(10))+Cast(@Year as Varchar(4))+'01')

End



GO

Select 'Answer',dbo.SomeFunction(10)

GO

Drop function...

Create Table Tmp(ColA Money,COlB Money,ColC Money)

GO

Insert  Tmp Values(1,2,3)

Insert  Tmp Values(4,5,6)

Insert  Tmp Values(7,8,9)

GO

Select ASum,Asum/ColC

From (

Select ColA+ColB as ASum,ColC

From Tmp) as F(ASum,COlC)

GO

Drop Table Tmp

Did something similar to JeffE.

Setup pivot table from dummy data range in spreadsheet. When user selects from combo (month) an stored prog is executed, returns data, repopulate / update...

SQL 2000 in general or only after sp3?

Frank, excellent reference, read it myself last month.

Read SQL Server Books Online(2000) about TEXT types, "sp_tableoption 'Text in row'",READTEXT, WRITETEXT and TEXTPTR.