Scrubbing Data - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Scrubbing Data

Author

Topic

MadSQL
Starting Member

1 Post

Posted - 2007-12-20 : 14:45:20

I dont know if anyone else uses this, but I'm trying to scrub a database on my dev server. The procedure is called uspScrubDatabase. When I execute this I get an error message:

Server: Msg 201, Level 16, State 4, Procedure uspScrubDatabase, Line 0
Procedure 'uspScrubDatabase' expects parameter '@ErrorCode', which was not supplied.

The guy that usually does this is on vacation so I have no one to ask.

Can anyone assist?

Thanks.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-20 : 14:49:27

DECLARE @ErrorCode {Some datatype here}

EXEC uspScrubDatabase @ErrorCode OUT

SELECT @ErrorCode

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-20 : 15:02:31

As you can see is this just a stab, because we have abolutely no idea how your stored procedure looks like.

E 12°55'05.25"
N 56°04'39.16"

sqlsquirrel
Starting Member

21 Posts

Posted - 2007-12-20 : 18:35:21

Just like Peso pointed out... copy and paste your procedure here. This will allow us to give you a more detailed answer.

Brett Davis
Senior SQL Server DBA
For more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources