[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1665
  • Last Modified:

.PRC

I only know .sql, how do you create a .PRC for a stored proc?  We're moving our stored procs to VSS and I don't see how my collegues got the .PRC files created or even moved to VSS.
0
dba123
Asked:
dba123
  • 3
  • 2
1 Solution
 
gpompeCommented:
They probably just renamed the file to PRC
0
 
ShogunWadeCommented:
it is better to save files as .sql  than .prc   .prc means you need to fiddle with file tpye associations to open them easily.

simply script up the procedures and save them.
0
 
gpompeCommented:
With Visual Studio you can integrate VSS to manage the code. I am not sure but maybe is Visual Studio who generate the PRC.

But is always a plain text file you can call in the way you want.
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
gpompeCommented:
When you use a DTS with a Copy SQL Server Objects Task, this will generate a PRC for the procedures, a TAB file and so on.

This task place the file in the "Script file directory" you setup in the task.
0
 
dba123Author Commented:
Ok, I got it.  My boss has a new process for us to upload stored procs, etc. to VSS 2005.  I didn't get where .prc came from because he's using Enterprise Manager 2000 and I'm using Management Studio 2005. I didn't want to bug him but learned that 2005 doesn't have an option any longer to save procs as .prc...and I've always saved ANY script as a .sql.

thus the confusion!!
0
 
dba123Author Commented:
We are already integrated with VS and VSS, this was the DB side of things for our stored procs.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now