Viewing 12 posts - 1 through 12 (of 12 total)
Thank you I got the first one working. Still trying to figure out the multiple outputs one.
January 28, 2020 at 7:47 pm
We have a requirement that we are not allowed to make any changes in the application connection string.
Does setting RegisterAllProvidersIP to 0 similar to MultiSubnetFailover=True?
August 19, 2018 at 10:56 am
Thanks for your reply.
From what I understand you used DNS alias to point to the alwayson listener name.We too have series of DNS alias name pointing towards...
July 24, 2018 at 8:02 pm
So after the failover has occurred, I should map the logins to the database?
August 18, 2016 at 12:53 pm
That was so simple. Thanks
May 3, 2016 at 8:53 am
sample data in A
[highlight="#ffff11"]GUID FBNUM ...
March 22, 2016 at 1:22 pm
Thanks for you reply
The fields in A table are truncated and populated with new data every week
all other fields might match but the date field doesn't
Not only the first...
March 22, 2016 at 12:57 pm
February 10, 2016 at 11:45 am
Thank you for all your effort.
I just want to remove that particular record. It's not always on the first row, it can be anywhere in the table.
September 9, 2015 at 7:24 am
I have so many NOT IN conditions like ::
Select * from backups
databasename not in (select databasename from backups where servername ='d900'...
September 8, 2015 at 2:06 pm
We use 2012. I dont think my organization agrees to that, they only have a requirement to encrypt 2-3 columns of a table. I think TDE is for the data...
December 10, 2013 at 12:04 pm
Thanks for the reply. I thought of putting up XML Indexes, but the concern is the table is huge it will take a lot of time to create the indexes.....
July 29, 2013 at 7:56 am