hi..

there just one thing i wanna to know is that..

i restore only one DB from one server to another..ok..here i transfer two users associated with that DB..one...

hi MARK !!!!!!!!!!!!!!!

Simply great!!!!!!!!!!

It worked!!!!!!!!!

Thanks!!!!

hi..

i used this also it gives me 0 update..

and then again same error

hi

i used all the stuff for resolving my login problem but i am unable still i am gettig the same error

unable to connect to server ABC:

server:Msg 18452,level 16,State...

hi!!

i restored my DB to my destination server!! but as i logon i am getting err like

unable to connect to server ABC:

server:Msg 18452,level 16,State 1

[Microsoft][ODBC SQL Server Driver][SQL...

Hi..

I also fired this..

SELECT  *

from master.dbo.sysperfinfo

but still i got nothing.....

Hi..

can i enable my auto shrink option for tempdb...so that i will not run this job every hour...can any body plz have any idea on this?

Hello ppls

I know there is performance issue by running this job every hour but...

Because of huge transaction, temp db grows upto sometimes 15 to 16...

Hey..PW

i will explain whole scenario..i have emp table and store table data here PK is EmpID from Emp..Data is coming from other source in table Stg_Store..and moved in Store table...

I cant do cascading delete but how that is successful after second run of this?????

Executed as user: EMPSQLSRVR\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_3   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_3   DTSRun OnStart: ...

Hi..

Y u trying trigger only..u can u simple procedure also

like

create proc update_test

@id int

as

begin

update test_table

set Date_test = getdate()

where id = @id

end

Hi...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=187731

if that works....

Hi...

insert into tableASAH (stulink,schoolyear,grade,school_attended)

select distinct asch.stulink,asch.schoolyear,asch.grade,asch.school_attended

from myDBASE.ASCH inner join [tableASAH] on ASAH.Stulink = ASCH.stulink and ASAH.GradeLevel = ASCH.Grade

where asch.schoolyear = 2003 and asch.grade = 09 and school_attended =...

Hi!!

Greg!!   yes i got the reason why it is failed and due to which process..by observing properties from Disconnected Edit...thanx for ur valuable time....

Now as u said "As for...

Can u specify that bulk insert query n both table structure...