Viewing 15 posts - 1 through 15 (of 20 total)
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...
July 21, 2021 at 3:09 pm
Great way to capture the errors Brian.
Thank you for sharing.
June 13, 2019 at 3:34 pm
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...
November 23, 2018 at 8:35 am
Hi,
Unfortunately I didn't find a solution and have just manually checked them into source control.
Dave
September 28, 2018 at 2:07 am
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...
March 1, 2018 at 3:42 am
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...
January 9, 2018 at 7:09 am
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...
June 11, 2014 at 3:36 am
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...
June 2, 2014 at 7:07 am
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...
March 27, 2014 at 6:46 am
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 =...
November 12, 2013 at 8:25 am
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...
November 12, 2013 at 8:03 am
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...
February 6, 2013 at 8:21 am
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.
February 6, 2013 at 7:44 am
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...
February 6, 2013 at 5:17 am
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...
February 6, 2013 at 5:05 am
Viewing 15 posts - 1 through 15 (of 20 total)