How long these process ids remain there (in case the sessions are closed). Anyone ?

How long these process ids remain there (in case the sessions are closed). I want to check only those session ids which are live, in use or not in use.

Yes. It says sleeping. But then there are other sessions which are not closed but still seen as sleeping. How can I differ between the two ? Should these sessions...

I tried the same actually. I opened two sessions and from one of them I ran one update statement. Once I closed that session with update command, and performed select...

Here Sorry if I missed something but please clarify me. Varchar mean variable length character and when the length of a character is not defined then we should use varchar....

Thank you. I am looking to pinpoint on the idea of having a role with necessary permissions on required objects. Seems best as per our requirement.

Can I use implementing both db_datawriter and db_denydatawriter for the solution ?

Great. It worked with the hint FIRE_TRIGGERS. It resolved the blockage.

Thanks LutzM and Brian for your inputs. I will go through these views and try to get the information I am looking for.

On thing I want to know:

I have only one Clustered Index with columns C2, C3, C6 and C8 on table T1 which contains columns from C1 to C30. There...

"but you can bcp a FILE into or out of a shared directory that exists on a Unix machine..."

- Thats what i am looking for. If say I have a...

Thanks Jared.

Thanks. Few more clarifications:

1. If we use following command on server S1

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'S2', @locallogin = N'TestUser', @useself = N'True'

Here does it means, that password is not required...

Passwords cannot be same. How can the logins be impersonated ?

Yeah. I think it should be some manual error else it would have not occured in first place.