Home > Community, SQL > Of course that’s how you spell sp_MSacquireHeadofQueueLock!

Of course that’s how you spell sp_MSacquireHeadofQueueLock!

 

 

If you are a blogger or speaker you probably cringe a little bit every time you have to reference a system object in your post or presentation and you see that little red squiggle under a system object name that you know is spelled correctly.. I know I did, and after the tweet below I knew that others were doing the same thing.

 

So, I stepped up to the challenge.

 

And the mssql.dic custom dictionary for Office was born. 

At this time the dictionary contains qualified and non-qualified names of system objects only (and only those that exist in sys.all_objects).  I’m sure that there’s a ton of other words that would be great to have in a dictionary, but hey – this is the first rev and I’m a busy DBA .  This has been tested on both Office 2007 and Office 2010, and the object names were pulled from SQL Server 2008 R2.

 

This is easily extended to create custom dictionaries for your environment – use the following query to pull object names for your specific databases:


SELECT  sys.schemas.name AS schemaname ,

        sys.all_objects.name AS objname

INTO    dba.dbo.dictionary

FROM    sys.all_objects

        JOIN sys.schemas ON sys.all_objects.schema_id = sys.schemas.schema_id

You can either then save the results as text or insert them into a table in your management database (this is what I did).

Feel free to download the file and use it for all of your documentation and presentation needs – did I mention that this works in Power Point as well?

Anyways, the file is here: mssql  Once you have the file downloaded save it as a unicode text file called mssql.dic in the following path:

 …\appdata\Roaming\Microsoft\UProof\  (same place as CUSTOM.DIC and your ExcludeDictionaryxxxxxx.lex files for office)

the instructions to import it into Office are here (use method 2).

Enjoy, and please leave any feedback or suggestions in the comments – I will continue adding to this dictionary and releasing it as needed.

 

 

Advertisements
Categories: Community, SQL
  1. No comments yet.
  1. May 2, 2011 at 5:18 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: