1
vote
1answer
90 views

Unable to change schema of a Publication Database using TSQL (Ready-roll): being forced stop replication

I am trying to apply schema changes using T-SQL (using Ready-Roll database source control tool with Octopus Deployment) to a Publication database however it is forcing me stop Replication for the ...
0
votes
2answers
813 views

SQL Server Database Design for Archiving Process

I am currently working on a large project to move an MS Access application to SQL server. Our team has been having discussions on the best way to design a part of the new database so I figured I ...
1
vote
3answers
5k views

How do I grant a database role execute permissions on a schema? What am I doing wrong?

I am using SQL Server 2008 Express edition. I have created a Login , User, Role and Schema. I have mapped the user to the login, and assigned the role to the user. The schema contains a number of ...
2
votes
3answers
2k views

SQL Server 2008 default schema not being respected?

We just copied a SQL 2008 database over to another server, for testing purposes. The typical user that logs in uses some objects in a certain schema. Let's say it's user foo and schema bar. foo's ...
0
votes
1answer
100 views

tool to analyze MSSQL schema and current values

Is there a tool out there that will go through a schema, compare the current values, and return a report of what columns are near the capacity of their data type? I am looking for a tool that can give ...
0
votes
1answer
28 views

MS Sql2000 and “scheme”

I've run to a problem in which I'm not sure where to look or how to fix it. The problem is the following. We have a site with a sql2000database. A backup from this was restored to create a development ...
3
votes
2answers
248 views

SQL Server: explicit rights to schema?

When giving permissions to certain Schema in SQL Server, I want to deny some operations from certain users. Do I have to explicitly deny these, or is it so that when user gets a permission to this ...
0
votes
2answers
175 views

How to define user as dbo of a specific schema

I'm creating a multi-tenant application that will utilize a single database with multiple schemas. Each tenant will have their own respective login/password. I was able to restrict view permissions to ...
1
vote
1answer
2k views

How to backup a specific SQL Server Schema's table?

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored. Example: [dbo].[Trucks] [dbo].[Cars] ...
0
votes
1answer
209 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
8answers
3k views

One Database vs. Multiple Databases

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project ...