no is not, it was working before.

hi, under application log i have no errors for this instance, however if i go to system logs i get this:

The SQL Server (ProfileCenter) service failed to start due...

thanks, is there any way to remove it?

hi thanks for your input, it was due to a huge snapshot that was done by the DBCC CheckDB that was still running, once the snapshot was deleted and sql...

thank you guys!!! thanks to you i was able to fix the same error 🙂

hi how would you run this for one login?

great article, thank you!

hi how do you change the service account of litespeed?

thank you

this is the message i am getting, sorry at the beginning i was using a proc, same script , this is the error:

Msg 1934, Level 16, State 1, Server...

i checked the DBCC UserOptions for tempdb is the same for both environments.

how do i check the QUOTED_IDENTIFIER settting in the server level?

it is query not a stored procedure. help! i still have this error :crying:

anything else i could check?

thank you for your reply, i get the same in both environments:

textsize2147483647

languageus_english

dateformatmdy

datefirst7

lock_timeout-1

quoted_identifierSET

arithabortSET

ansi_null_dflt_onSET

ansi_warningsSET

ansi_paddingSET

ansi_nullsSET

concat_null_yields_nullSET

isolation levelread committed

thank you guys!!