You can use the optional parameter when creating a stored procedure [ ; number ] . 

create proc usp_Test;4

As

Begin

Select * from sysobjects where type = 'u' order by name

End

You can...

Here you go:

select

Name, object_name(parent_obj), xtype

from

sysobjects where...

Thanks it worked but a little cumbersome.  I had to add the Sort Data Flow Tasks, but it worked.

Yes, thank you.  That was the problem. 

Daniel

I installed SQL Server 2005 Developer Edition.

On a machine that has SQL Server 2000 on it.

Thanks,

Daniel

SQLBill,

The folder doesn't have to exist when creating the dump device.  That is the way it has always worked and is working for the other client databases.  It is pretty...

Thank you for your help. I did try it, but it won't work for our solution. The actual XML doc that I am trying to build would have different...

I think it is a good article. It would be nice if you wrote a more thorough article comparing the two DB technologies. I don't have familiarity with DB2,...