Did you see this?

http://www.codeproject.com/useritems/listsqlservers.asp?df=100&forumid=3432&exp=0&select=508182

or

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=734&lngWId=10

Ciao, Chiara

Sorry, I don't understand exactly your question... but why do you not use a function?

If you explan me you question, maybe I could help you. I don't understand how you...

and what about using....

...WHERE convert(char(10), [datetime],121) LIKE convert(char(10), getdate()-1,121)

instead of...

...WHERE [datetime] LIKE convert(char(10), getdate()-1,121)

where, obviously, [datetime] is your fieldname

Ciao, Chiara

You can use one of these

--- disable all constrains

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

--- disable all triggers

sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"

and then... as told you alzdba, remember...

Hi /rockmoose,

I'm a "newbie" but I hope I will contribute...

Maybe you can try...

connSConfig.Execute "SET IDENTITY_INSERT [AlarmClass] ON; Insert into [AlarmClass] (ID,AlarmClass,Priority,BPM,WAVFile,PlayType,VectoringGroupID,AlarmHelpStringID,AlarmMsg,AlarmTextColor,AlarmBackColor,AckTextColor,AckBackColor) Values (11,'Cleared',10,10,'','',0,1,'',16777215,16711680,0,16777215)"

All in one query...

Bye, Chiara