Hello all,

trying to return the time in minutes between the Date1 and Time1 columns and the Date2 and Time2 columns. Help is much appreciated.

create table #TimeDiff

(Date1 date

,Time1 varchar(50)

,Date2 date

,Time2...

Define "Mirror server".

If you have some sort of replication on the main server that is pushing data to the other three, that could be the cause.

Do you have multiple versions of SQL in your CMS?  That is likely the cause of your issue.

I have never had the transaction log become 2.5 times the data it needed to delete (and still growing). Have I just been lucky and this is more common...

Aw cmon Jonathan. Let us at least hold on to our visions of youth.

In between the aches and pains.

That appears to...

For starters, are you sure that the query highlighted is place to start?

If it's executed once a month as part of a some process, then I would ignore...

For starters, are you sure that the query highlighted is place to start?

If it's executed once a month as part of a some process, then I would ignore it.

This report...

Uh,...

I did not understand the below in your reply...could you please elaborate. Was something wrong with the function I shared? I did not write it but please let me...

Grey

So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough.  Today, after a lot of begging, the 8...

So, getting my 8 and 10 year old grand kids to take showers during the Covid crisis has been tough.  Today, after a lot of begging, the 8 year old...

Ok, what are you trying to accomplish?  I would recommend leaving sa as is, disabling it, and create a new login that is a sysadmin.

Are your applications or users logging...

I did not use code to delete it.

I open table in edit mode and then hit delete key to delete it.

Does it make difference?

I checked it many times the...