Unfortunately you don't write if you're using the 32-bit o 64-bit version. On the 32-bit version you need to enable AWE in SQL Server to address more than 4 GB...

good paresh good

Hi,

try below query wherever you see servername put there your server name you have to create one user with admin rights on the server which you want to link with...

first try to do test connection through right click on linked server and test connection ... i think this problem come's because of wrong setting of connection

hi,

as per paresh told just create linked server and after that you can interact with there server

do u know how to linked server if you don't know then reply me...

is vs2005 previously installed before you install sql server 2005

create restricted user with limited right's like all guys tell u and give that user name and password to them and change other user's password admin right's user with you

hi shail,

first answer me that do u try to run that dts package manually ....

to find out which package that job runing to to schedule job property you will...

Hi,

as per you mention for data you want on which column you want to create relationship i think

select t1.A,t1.B,t1.C,t2.D

from table1 t1 inner join table2 t2 on (t1.A=t2.A)

this...

you have to run upgrade advisor of sqlserver 2005 on sql server 2000

then you will find all the upgrade advice need to upgrade that and also solution for that

HI,

paresh i got that problem solution we can get procedure name through error_procedure()

now i want to make database trigger if you have any idea than please pm me or reply...

hi, paresh

i know that

call me

hi as per you told that if you want to check for this particular column of primary key then right click on table and click on design and now click...

HI,

Temporary table's are limited to particular session in which they are created when session end they automatically dropped... but if you want to perform the task to drop that temporary...

hi i want to know that whateever memusage this query shown is that in mb or in kb can u please tell me that