Can you write a query and send it to me through which I can get the HH:MM:SS details (time difference) between two date-times (start and end dates)?

I wrote the below...

Hello,

Could you please send me the steps to configure database mail please? I'm trying the same at my home and do not have any seperate domain!

Regards

Sourav

The Ids which were there in the source system should be readily available in the destinatio server.

Added my comments..

Regards

Sourav

Thanks Gail for your response.

Infact, I can repro the issue in my local system to see the outcome but thought to get a response from our SQL Experts if this...

Thank you chandra, for your response...

Can you please reemphasis on the point 2::

(2) For the first time installing SQL Server also can we have the named instanes installed to the...

(1) It is difficult to know about the project in which they will allocate after you are recruited into the company. That is the key point.

You need to get this...

No, no updated are happening at Distributor end!

Thanks much..It is much helpful...:-)

Run the following (you’ll need to have a SQL Server login with sysadmin or processadmin privileges to do this):

select req_transactionUOW

from master..syslockinfo

where req_spid = -2

This will...

Thanks Ten for your response. I had one more query to you ..

1. While creating the "Indexed View", do the index available as a seperate entity or does this refer...

When using transactional replication, transaction commands are stored in the distribution database until the Distribution Agent propagates them to all Subscribers or a Distribution Agent at the Subscriber pulls the...

That is fine..infact as to run sp_who2 we can run that in any DB.

But unable to repro the first situation that .. when the session expires.

Anyways,

Can you suggest one more...

Thank you Guys!! But I am not confident in either way.

Let me explain you the scenariooo...

One of my colleagues faced the problem..

1. He taken one of the DB into "Single_User"...

1. Take the DB to single_user mode.

2. The session expires.

3. Try to connect again. As it was in Single_user mode you should not connect. (if not wrong).

4. How to reconnect?

I...

Awesome!! Thanks,