Database partitioning

E

eoint

Hi, this is more of a sql question that project but i can't figure it out
I'm using three-way-partitioning and have got to the step where i configure
the main db server. My problem is with the following stored procedure
MigrateProjTablesSP

Format:
EXEC MigrateProjTablesSP <Name of Main Server>, <Name of Main
Database>, <Main Server sa Login>, <Main Server sa Password>,
<Project Tables Server>, <Project Tables Database>, <Project Tables
sa Login>, <Project Tables Server sa Password>, <Local File Path to
Temporarily Hold the BCP Files>

I type:
EXEC MigrateProjTablesSP 'headiis018stest', 'ProjectServer', 'sa',
'password', 'MSSQLServer3', 'sa', 'password', 'c:\temp'

i keep getting the following error:
Procedure 'MigrateProjTablesSP' expects parameter '@FilePath' which was not
supplied

i know this is probably simple but i've been looking at it so long that i
need a fresh perspective...any ideas would be greatly appreciated.
 
E

eoint

Figured this out i was ommiting to put in the name of the database on the
project Tables DB

the stored procedure expexts 9 parameters and i was only entering 8
 
Top