I was assisting on a similar error message as well. Did you manage to fix this?

In my case, this was occurring on a single node windows cluster.

Initially the service...

Is there any other way to improve the execution time (has gone from 2 hrs to 20+ hrs)...

DBCC scheduled to run off-peak hours

PROD

what is the size of database?...

Thank you for the info on SPNs. I had checked the SPNs are registered under the SQL Server Service account names for both Instance name and the Port#( this is...

John Mitchell-245523 (7/9/2009)

---

Have you looked at DDL triggers? As far as I know, you can create a trigger that will fire when a DDL event (such as creation of...

Check if the SQL Server Agent service account has access to this file (and location).

You should be able to use netsh command and use the firewal option to open the port 1433 for SQL Server.

netsh firewall set portopening TCP 1433 "SQLServer"

Refer the...

Hi Aadhar,

I am not sure if thers is any way to monitor the execution of sp_configure procedure.

You can use the below approach.

1. Make sure "show advanced options" is...

That was really helpfull.

I was trying to execute on SQL Server 2008 R2 and bumped into an issue with the Collation parameters with the "keycolumns ".

To work around,...

Thanks Perry for the article.

The new partitions when they are created gets its own filegroup and is placed on...

The file names are the same. But some of the files are in different location.

* Use partitioning for tables having more data(based on date)

* Use data and backup compression to reduce the size of the database and there by reduce the backup size and...

You can check the below query.

select * from sys.server_principals

where sid = (SELECT SUSER_SID('MyDomain\DomainUserA'))

This would probably give you a different login name than 'MyDomain\DomainUserA'

You would probably have to drop the login...

The sp_link_publication did not work.

I have changed the options in security configuration of MSDTC section of the component services to 'allow remote administration' and 'allow inbound' and 'allow outbound'...

1) shrink the file -- Does not reduce this value

2) restarted the server -- Resets the value to 0

3) Detach the server -- Does not change...