We have around 40 databases in this server. We didn't face insufficient thread messages.

This one works! Thanks a lot!

Purpose is we want one DB to be in Synch till some time and then we need to detach it in Primary server and start...

Thank you. Waiting for your scripts eagerly.

Hi, I need to store the Nepal date & year in sql table column and not time. For ex: if you check today's date in nepal it is 24 and...

Thanks for the response. But the question is not about Time it is Nepal Date & Year.

Thank you!

What is this PDW & Poly Database movement about? I see some errors on those services in my SQL log.

attached execution plan

Dear All,

Thanks a lot for your ideas! I will try to refine the sql statements also i will check the plan and if i need any help i...

LOG_BACKUP - I get this in the query you gave.

And i am sorry that i didnt post my question clear. The log size for Publication database is where i am...

In "Show Advanced Editor" of a OLE DB Source i see Input/Output Columns tab where each column's data type was listing as per the database type and length. And the...

This server is running with SP3 (SQL 2012) and it is uptodate. I see the crash dump file names like "ISServer_106368_75a8592f-0076-4e1b-9e4c-0875df46d4f2_0".... and so on. Any idea how it gets created?

Thank you!

Thank you!