137 reputation
19
bio website
location
age
visits member for 1 year, 9 months
seen May 10 '13 at 0:16

Dec
24
awarded  Popular Question
Dec
16
awarded  Notable Question
Dec
4
awarded  Popular Question
Dec
4
awarded  Popular Question
May
8
accepted How do Availability Groups work with cheduled jobs and SSIS packages?
Apr
24
awarded  Popular Question
Dec
12
comment How do Availability Groups work with cheduled jobs and SSIS packages?
That's sounds promising. I only want the jobs to run on the primary server (which ever server that may be at the time).
Dec
11
asked How do Availability Groups work with cheduled jobs and SSIS packages?
Dec
10
accepted Logins aren't syncing across Availability Groups
Dec
6
awarded  Teacher
Dec
6
revised Logins aren't syncing across Availability Groups
deleted 1 characters in body
Dec
6
comment Logins aren't syncing across Availability Groups
I figured it out and posted a new answer appropriate for AlwaysOn.
Dec
6
answered Logins aren't syncing across Availability Groups
Dec
6
comment Logins aren't syncing across Availability Groups
Keep in mind that I am asking about AlwaysOn, not mirroring. I tried the script, however the sys.servers table only contains the local server so I get the following error when I run the stored proceedure: Msg 7202, Level 11, State 2, Line 1 Could not find server 'otherserver' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Dec
5
asked Logins aren't syncing across Availability Groups
Oct
24
awarded  Supporter
Oct
24
accepted Can Availability Groups provide seamless failover (with no query failures)?
Oct
24
comment Can Availability Groups provide seamless failover (with no query failures)?
Perfect, thanks!
Oct
24
comment Can Availability Groups provide seamless failover (with no query failures)?
I see, so that requires a smarter client app.
Oct
24
awarded  Editor