1
vote
1answer
608 views

Is there a maximum number of schemas allowed in SQL Server 2005?

What is the maximum number of user schemas one can create in a single SQL Server 2005 database? Is this figure different on SQL Server Express vs SQL Server Standard? I've searched the MSDN ...
0
votes
1answer
214 views

Schema changes with replication

What are the steps to make a schema change to a SQL Server 2005 database using transactional replication? I'm trying to add a database column. I thought if I removed the article for the table, made ...
4
votes
1answer
185 views

SQL 2005 Security - Users: What are they used for? (and other various questions)

I am not a DBA and so dont really know anything about SQL 2005 security settings, etc. I am attempting to set up an empty copy of our database by generating the full database from SQL Management ...