No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
2 Posted Topics
When you create your new table, create your columns for autonumbering with the option IDENTITY. It sounds like you want to start at 1 and increment by 1 so you don't need to add the options for seed or increment. When you insert into the table, don't specify the identity …
You can list the users in the database like this: SELECT d.name, s.name, d.type, d.type_desc FROM sys.database_principals d LEFT OUTER JOIN sys.server_principals s ON s.sid = d.sid WHERE d.type IN('G','S','U') AND d.name NOT IN('guest','INFORMATION_SCHEMA','sys') With domain logins you can add them pretty easy as long as the two servers are …
The End.