Welcome to EMC Consulting Blogs

January 2012 - Posts

• 3 things that really get on my nerves with using SQL Server

  Don't get me wrong I love SQL Server, I have been using it for many years in all its Windows favours... SQL Server 4.21a, 6.0, 6.5, 7, 2000, 2005, 2008, 2008 R2 and 2012 If fact I trained under someone who used SQL Server 1 on OS/2 (there you go revealing Read More... Posted 06 January 2012 16:28 by Paul.McMillan | 0 Comments

• SQL Server Error 18452, "Login failed. The login is from an untrusted domain" Windows 7

  The full error message is SQL Server Error 18452, "Login failed. The login is from an untrusted domain and cannot be used with Windows Authentication" I have just got this error message again on a Windows 7 Workstation, that I am using SQL Server Management Read More... Posted 06 January 2012 11:57 by Paul.McMillan | 0 Comments

• A way to find the Real Total Lines of T-SQL Code in a SQL Database

  Version 2 In my previous post http://consultingblogs.emc.com/paulmcmillan/archive/2012/01/03/find-the-total-lines-of-t-sql-code-in-a-sql-database.aspx I said that the code was not perfect because it just counts the number of Line Feeds and you could have Read More... Posted 03 January 2012 14:42 by Paul.McMillan | 0 Comments

• Find the Total Lines of T-SQL Code in a SQL Database

  My Project Manager asked me to find out 'How many lines of code have we in the System'. I could not believe that no one has ever had to do this before so I googled 'sql server stored procedure number of lines' and found the following posting from Gordon Read More... Posted 03 January 2012 12:06 by Paul.McMillan | 0 Comments