Thanks for your advice.

Based on your instruction, I downloaded the advisory and I tried to analyze against our intranet

sql server with a lot of databases on it.( I only need...

Wow,

Thanks for all your suggestions. It seems there are more than one way to do.

I will definitely try in different ways.

Very appreciated.

Sincerely

Betty

Hi Eddie and Daryl,

Thank you for your help. I appreciated very much.

Sincerely

Betty

Eddie,

That's good comment. then, how they solve the issue? I mean how they accomplish it.

Thanks.

Betty

Hello jezemine and Lowell,

Thank you both for clarifying this for me. Very very helpful.

Betty

Quick question, what is the exact difference between red-gate standard and professional version, did find it on its web site

Betty

Greg and John,

Thank you both for your advice and information and I will take a look at those sql compare software especially red-gate since you both mentioned that software.

Sincerely

Betty

Hi Roi,

Thanks for your idea. I probably have to utilize in both way because I probably have more than 10 rows in table2 for each row in table1. Since I...

Farrell,

I didn't get any error.

Betty

Thanks everyone. I think I can use:

 select convert(char(10),txndate, 101) to let it become mm/dd/yyyy

Betty

Do I have to do something like this:

Declare @sDate Char(10)

select @sDate=Str(Year('9/13/2005'), Len(Year('9/13/2005'))) +'-' + Str(month('9/13/2005'), Len(month('9/13/2005')))+'-'+Str(day('9/13/2005'), Len(day('9/13/2005')))

select @sDate

Is there any easier way?

Thanks.

Betty

Hi Norm,

It's a really good suggestion. Especially the part you said you will not allow any user to access tables directly but only procedure. Although I didn't undestand all you...

Hi Ninja,

Yes, backup production database before apply ing new change is a good paractice. But I am not sure "have a script to test that the application still works with...

Hi everyone,

Can you give a hint. If I ran netstat and I have thousands active connection like this:

TCP    travelinsure1:3838     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

but travelinsure1 is our web server and our database server...

Hi Sireejith,

Exactly, that' what exactly I asked. I used sp_who and sp_lock,

it is quite normal, we just have several connection to production database. and in enterprise manager,-->current activity--> I don't...