.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?

Improve company productivity with a Business Account.Sign Up

x
 
gpompeConnect With a Mentor Commented:
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
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
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.