Hi,

Please share the exact error that you are facing.

Hi,

"Availability Group is not ready for Automatic Failover" Policy check suggest that atleast on of the secondary replica is not ready for failover ready. We face this issue when our...

Hi,

Please share the error you are getting while trying to delete the user.

Are you getting error related to schema or something else.

Regards

Shafat Husain

Dear Vijay,

You can change it in one go. No need to wait for the restart.

Regards

Shafat Husain

Dear Jeff,

I would like to take one more shot on this one.

1. Open User Account Control Settings by clicking the Start button , and then clicking Control Panel. In the...

Welcome.!!

Regards

Shafat Husain

Hi,

Try this one.

DECLARE @SearchStr nvarchar(100)

SET @SearchStr = 'Value to Search'

-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.

-- Purpose: To search...

Dear Ajfarroll,

1. Are you able to ping the database server from the application server?

2. Are you able to connect the SQL Server using SSMS

3. Check the firewall on the database...

Hi,

Here is a proc that will help you. it is a modified version of the original code taken from http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

CREATE PROC SearchAllTables

(

@SearchStr nvarchar(100)

)

AS

BEGIN

-- Copyright © 2002 Narayana Vyas Kondreddi....

Hi,

Can you please be a little more descriptive.

You should take Transaction log backup more often, However the frequency of Transaction log backup would be directly related to your RPO (Recovery Point Objective). Loosing 30 minutes of data...

Dear Fred,

Have you tried using Openquery??

Select * from Openquery ([Linked Server Name], 'Select * from a.table name.....')

Regards

Shafat Husain

Hi,

Please run the query on the production database server and send the Actual execution plan.

2. Now, someone is having trouble updating data. The issue seems to be that a trigger fires during the update. In the trigger the code tries to delete from a...

Dear Jeff,

Apologies, I am out of ideas right now. Maybe some of the senior members should dive in.

Regards

Shafat Husain