4Site
Support Request System
View Patch #50.030.003
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02777 -
Error creating SQLServer login when database name starts with a number
Symptoms:
When granting access for a new SQL Server user, the message 'Invalid syntax near "#"' may appear when database name starts with a number, such as 4Site or 4Train. This error would only be apparent to a user running against SQL Server 2005 or higher.
Solution:
Enclose the database name in square brackets to resolve this error. Sample command to run against SQL Server 2005: create login [NewGuy] with password = 'password', default_database = [4tune], check_policy = OFF
Browse Patches
Find a Patch
Return to Request System Menu
