Without a domain - you need to have local accounts on both systems with exactly the same username and password.  And even then - you can end up having issues...

If SQL Server is restarted - or the server is restarted - then those jobs that were running at the time will show up as canceled.  If that is not...

just use straight convert with the correct destination type (e.g. no VARCHAR without specifying a size - bad practice!!) and with the correct format - no need for substring...

I would definitely convert that scalar function to an inline-table valued function.  You don't actually need a separate view to implement @Phil's solution - which can be done using either...

I would disagree with the normal way as using DelimitedSplit8K - if the goal is to split out to individual columns, using that utility would require a secondary pivot/cross-tab (and...

Well - you can avoid this issue using a slightly different approach.  I would create an iTVF to split the elements and then cross apply to that function.

            
October 4, 2021 at 6:04 pm
            
#3936364

            
            
                                                
        

Finally found the reason for the error. Thought add that so anybody who have this issue can benefit.

On the secondary database , properties, Advanced, Enable Contained Databases Option should...

Just curious - but do you have the option 'Optimize for Adhoc Workloads' enabled on that server?  I would also review the parameterization setting on the database - the default...

You should also not use SELECT to set the variable - use SET instead:

DECLARE @SQL NVARCHAR(4000);

    SET @SQL = 'SELECT * FROM TableA; ';
...

If you enable automatic seeding - then you only have to restore the database to the primary and add the database back to the AG.  So your steps would be:

...

@JeffModen - I rather like Peter's version to get the Nth Weekday outlined here: https://weblogs.sqlteam.com/peterl/2009/06/17/how-to-get-the-nth-weekday-of-a-month/

And we had a discussion about my changes to his function here: https://www.sqlservercentral.com/forums/topic/get-particular-date-from-a-month/page/3

I would think using...

What are you looking at to determine that the instance was not upgraded and instead was installed side-by-side?

What have you tried so far?

Or is it possible that the backup process is switching the recovery model before performing backup - then switching it back to full?  Those are the only reasons I can...

Peter Larrson created the function outlined here: https://weblogs.sqlteam.com/peterl/2009/06/17/how-to-get-the-nth-weekday-of-a-month/

I updated that function and showed it here: https://www.sqlservercentral.com/forums/topic/get-particular-date-from-a-month