![]() You can't use spaces or other special characters.įor detailed info about these requirements, see Database Identifiers. Subsequent characters can be letters, numbers, the at sign, dollar sign ($), number sign, or underscore. The first character must be a letter, underscore (_), at sign or number sign (#). Here are the most important requirements. The database name must comply with the rules for identifiers in SQL Server. ![]() (This allows 5 characters for the suffixes that SQL Server appends to the data file and the log file, within the maximum of 128 characters.) The database name can be a maximum of 123 characters. The database name must be unique within an instance of SQL Server. Make sure that you follow SQL Server naming conventions when you name the database. Provide a name for the destination SQL Server database. The following screen shot shows the Create Database dialog box of the wizard. If you're looking for info about the Transact-SQL CREATE DATABASE statement, and not about the Create Database dialog box of the SQL Server Import and Export Wizard, see CREATE DATABASE (SQL Server Transact-SQL).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |