I did check BOL for that did not get anything.

when I create mirror endpoint I define the port number in it now if only one

endpoint allowed per instance then how can i use different port number for two...

Thanks

Will two mirroring sessions on same instance use single endpoint or I require

two separate endpoint for two mirroring session on my box.

sorry in this case rollback after print statement, is necessary which I missed in the code.then it works perfect.

Once again to bother you,but as per my code which is working fine as per my requirement ,it is an example from good sql book,there was an argument that it...

Thanks:-)

Thanks I for your example it did help to understand practically.:-)

ok now my code which is not allowing salary coulmn in my emptable

to get updated

create trigger tgigupdate

on emptable

for update

as

if update(salary)

begin

print 'can not update salary '

end

go

it is working fine as...

Thank you

Thanks for your answer but My question has a problem.It should have been that I am not able to see dependent object of rule through sp_depends,I tried all ways given...

Thanks for your reply but half the problem is solved

I am log shipping from pc1 to pc2 as

an pc1\administrator and having same password on the machine still restore...

Just want to know whether all ddl(create,alter,drop) and dcl (grant,deny,revoke)stsements are also logged in log file apart from dml(select,insert,update,delete)ststements?

Thanks in advance

Thanks for information u sent.

I am sorry the sp that u sent is not working.

I want to set default user at the creating database.