I was attempting to attach to the Northwind database from SQL 2005 and it gave me some error.
Unfortunately, I pointed it/associated it to a filename called "sqlservr.exe" and now all my MDF File associations are all screwed up.
1. Can someone help me to reassociate it with the correct .exe or service file? For example, the LDF file shows an assocation with "SQL Server Database Transaction Log File (.ldf)"
2. How to successfully connect to the Northwind database from SQL 2005?
With many thanks,
>>Now I just need to find out how to reassociate with the SQL Server 2005 Database Application.<<
Why are you trying to do this? This is not MS Access. SQL Server data files do not need to be associated
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
by Mark Wills
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
by Mark Wills
Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server... So if you are the accidental DBA, or, simp…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.