|
(→Installation w/SQLServer)
|
(→Installation w/SQLServer)
|
| Line 33: | |||
| * db_datawriter | * db_datawriter | ||
| * db_ddladmin | * db_ddladmin | ||
| - | * [[Image:sqlserver-permissions.png|left|320x320px|alt=Shows the checkboxes on the user account for the anthill database|Shows the checkboxes on the user account for the anthill database]] | + | [[Image:sqlserver-permissions.png|center|480x480px|alt=Shows the checkboxes on the user account for the anthill database|Shows the checkboxes on the user account for the anthill database]] |
| + | <br/> | ||
| + | <br/> | ||
| + | === Imported Databases Note === | ||
| + | Imported databases might have a schema & user associated with them already. To change the default schema that is being used (usually '''dbo''' on imports), you can run the following in a new query: | ||
| + | <pre>USE [DatabaseName] | ||
| + | SELECT 'ALTER SCHEMA anthill3 TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME | ||
| + | FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbo'</pre> | ||
| + | This will provide a list of queries that you can run next in the SQL window: | ||
| + | <pre>ALTER SCHEMA anthill3 TRANSFER dbo.HI_LO_SEQ | ||
| + | . | ||
| + | . | ||
| + | . | ||
| + | </pre> | ||
