posts - 94, comments - 124, trackbacks - 82

My Links

News

View Anthony Trudeau's profile on LinkedIn

Add to Technorati Favorites

Article Categories

Archives

Post Categories

Image Galleries

Other Links

Cannot start with 'Log'

I found another oddity that seems to be undocumented today.  This one in SQL Server 2005.  Apparently, you cannot start objects (at least stored procedures) with the word "Log".

I have a table called ShipNoticeLog and a stored procedure called LogShipNotice.  The table is the noun and the stored procedure is the action -- this is how I prefer to do the naming.  My code quickly failed with the message, "Invalid object name 'LogShipNotice'..."  I ended up solving my issue by renaming the stored procedure as AddShipNoticeLogEntry.  A little more verbose, but it'll suffice.

By the way, I classify this as a bug not because there's anything wrong with the restriction, but the fact that it isn't documented or at the least clearly documented.

Print | posted on Wednesday, September 24, 2008 2:21 PM | Filed Under [ SQL Server bugs ]

Feedback

Gravatar

# re: Cannot start with 'Log'

Hi Anthony,

Interesting post. But which version of SQL Server are you testing this with?

I am using SQL Server 2008 and I dont have problems with starting object names with "Log".

Thanks, Frank
9/24/2008 2:47 PM | Frank Wang
Gravatar

# re: Cannot start with 'Log'

This is in SQL Server 2005.
9/24/2008 4:01 PM | Anthony Trudeau
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 

Powered by: