hi good question..

i too have same doubt...

can any one plz give ur suggestions???

thnaks

hi .. thnx for the link

sry

Just confirmed, they are using LINQ to Entities..

can any one tell me how to tune those queries?

can i profiler and DTA for...

thank u all for replies

i will try and let u guys know..

thnaks

thnx for the replies, got some info on using ssis....

but will it transfer the users without changing ssid's?

thanks

are there any free tools , should i have to look out for??

which one u guys prefer red gate sql monitor or fog light for sql server??

thanks

thanks guys

thanku perry, thats really helpful

and

i got another doubt guys..

i can upgrade SQL Server 7.0 Enterprise Edition SP4 to SQL Server 2005 .

does it mean, the inplace upgrade has been...

as per my knowledge , u should use

log for restoring log file not databse

like

restore log dbname

from disk='d:\logbckup.trn'

with recovery

or u can use stansby

not

restore database dbname

but i dont...

Hi Jayanth

thanku, thats really nice of u .

so far i studied only local author book only..i will start reading some foreign author from on..

thanks

hi koen..

sry ...

and

thanks for replys guys..

hi..

thanks Lynn Pettis,

Hi,

Jeff Moden,,

i know the purpose of msdb , but i dont know about the second part of the question..

i got questions from some of my friends...

and

i copied and...

Hi.

actually i have 70 questions with me and i googled everything and foundout the answers..

and

i did found answers for some of the questions i posted but i didnt understand..

and

for...

oh kk

thanks

hi thanx

but can u go through this and tell me..

http://www.codeproject.com/Articles/167714/Copy-Database-Wizard-MS-SQL-Server-2005-and-later

he is saying we can transfer everything using copy database wizard..

big confusion now...

Thanx lowell,calvo,GilaMonster

to gila:: why do i need backup and restore for db and ssis for logins and jobs??

i can use ssis for databse also , right? or is it not...

hi divine..

no , nothing was installed other than iis and active directory.... after the os installation

thanks