.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.
LVL 1
dba123Asked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.