Congrats Frank.

This is a remarkable achivement. my Best Wishes.

I have seen almost all times your responces whenever i was trying to resolve any issues.

Jeswanth

Hi Noel.

Thanks a lot. Infact i wrote three Triggers! now i will change back to this method.

Thanks again

Jeswanth

Hi,

Thanks for the replies. but whats the ieda about the deleted count > 0 and inserted count > 0 . Is it happeing because when we update any row it...

Good one. But i was expecting some thing like the follows.

the one should telling the structure of usage.

ie . if i have  functions...

Hello,

Everrything if fine while using goto untill you get the first bug and try to debug the same. the programmer even the one who wrote the same wont be able...

Hi

I Feel the function dont serve the purpose. First thing is in INDIA we dont have 5 Day Working Concept except for Software Comapnies. ALL are 6 Days Working and...

Whats is a Query Bench ? i never saw any thing like that in sql server 2000 ? are you talking about the next version ???

Jeswanth

Those who are getting only errors because . they are ignoring the result tab. if you see the result tab you can see the date.

other wise press CTRL + T...

Hi growl and stone

Thanks for the replies it was really informative. each time i post a question i learned a lot .  in fact...

Thanks "Growl" learning the stuff.

Hi ,

I feel you should make your boss also happy. Write one VB application which executes the script without using sql QAnalyzer ....

SP 3

visit http://www.microsoft.com/sql/downloads/topdownloads.asp

Jeswanth

Hi,

I havent gone through the Script you have forwarded. but i normally do a diffrent method whenever i work with large data .

use a table variable

insert the cursor declaration output...

Do check the following commands

DBCC PROCCACHE, DBCC FreeProccache,

dbcc dropcleanbuffers

it might be usefull

Jeswanth

I was refering to the DMO its a Com Library . that you can find under the references of VB . its named as Microsoft SQLDMO Object Library. this Component...