This sounds like a prime example to use the HASHBYTES function where you hash all of the columns in each table and join on the key and where it is...

Great way to capture the errors Brian.

Thank you for sharing.

I have used Redgate's SQL Search SSMS plugin for this. I search every object and all object types for the name of the linked server and see what refers to...

Hi,

Unfortunately I didn't find a solution and have just manually checked them into source control.

Dave

I can't say I have seen any increases in backup times on servers that have had the patch installed. Certainly, for a 86GB database with 47GB of used space and...

Caution needs to be aired when  following the recommendations in the SQL KB article  (https://support.microsoft.com/en-us/help/4073225/guidance-for-sql-server) when you are using hosting a SCCM Config Manager database.

A Technet blog...

I've now found the source of this error; for anybody who is suffering from the same problem, hopefully this might help;

The error was due to the scheduled jobs that were...

Hi,

Sorry to re-open old posts.

Did anybody have a successful resolution to this? I have a installation of SQL 2008 R2 on Windows Server 2008 R2 in an clusterd solution.

SQL...

Great article. I've experienced this problem from a database that i had inherited. The 5GB data file was dwarfed by the 90GB transaction log file. I did run a transaction...

You will need a table to populate with your instances, something like;

CREATE TABLE [SQLAdmin].[SQLInstances](

[ID] [int] IDENTITY(1,1) NOT NULL,

[SQLInstance] [varchar](30) NULL,

[Version] [varchar](10) NULL,

[Active] [smallint] NULL,

UNIQUE NONCLUSTERED

(

[SQLInstance] ASC

)WITH (PAD_INDEX =...

Hi,

Are you wanting to run the same query against the 100+ servers to compile this report? If so, I have an SSIS package that I created that dynamically creates a...

I think in that case you will need to log on as SA if you can get the password and add your new login to SQL. Your new user won't...

Does the SQL service even start up? If not, you will need to use SQL server configuration manager to change the account that SQL server is using.

Hi,

As far as I understand your question, you are trying to login to your SQL instance with an account from a separate domain. As your SQL instance won't have permission...

I was unable to trace the errors but to rectify the issue I followed this post here;

http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/3588c09f-8f76-4a62-87e3-85d2b02dbce3

and set Async=true on the connection string which has prevented the problem.

Hope...