Advertisement

07.25.2008 at 12:26PM PDT, ID: 23596549
[x]
Attachment Details

SQL Server 2005 - How to copy/migrate tables and stored procedures with permissions??

Asked by synapse88 in SQL Server 2005, Programming for ASP.NET, SQL Query Syntax

I'm developing a new module for an ASP.NET application.  In the process I'm creating a number of new tables and stored procedures.  I would like an easy to migrate those tables/procedures AND the permissions I have set.

I know I can right-click the table in Management Studio and script the table out, but that script doesn't include the permissions.

Whats the best way to migrate tables and stored procs?Start Free Trial
 
Keywords: SQL Server 2005 - How to copy/…
Title
1 Project Migration
2 sql migration
3 migrate from Access 2000 to SQL …
4 Migration Assistant Error
5 PB 10 MIGRATION
6 Cross-Server call to stored proc is "…
 
Loading Advertisement...
 
[+][-]07.25.2008 at 12:32PM PDT, ID: 22091601

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Programming for ASP.NET, SQL Query Syntax
Sign Up Now!
Solution Provided By: chapmandew
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.25.2008 at 12:35PM PDT, ID: 22091618

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628