Yes, the mdf and ldf are there.

Thank you melton for your suggestion, I will look into xp_cmdshell.

Steve, How do I call vbScript from SQL? Thanks for your time.

Hi Bob,

Converting the results to VarChar did fix it. Thanks for your help.

What is wrong?

That worked, thanks.

I had to rename that file and after that it showed up. Strange!!! Thanks for your time.

Yes i copied both mdf and ldf. After running the command on master, it is still not showing up.

Thanks G-Squared that works.

Thank you Ken Simmons, that worked. Have a nice day.

I apologize for the typo, here is the changed proc with ClientID as the parameter

CREATE PROCEDURE [dbo].[sp_getClients]

@ClientID VarChar(20) = 'Sp1'

AS

BEGIN

SELECT intID, ClientID

FROM Clients

WHERE ClientID = @ClientID

ORDER...

Thanks Andrew, that really worked.

The output should be intID and ClientID. Take out the intID in the order by statement because that was a mistake. As seen by one of the responder, the query...

I want to select dates between "02/15/2009" and "02/19/2009", one day per row like,

02/15/2009

02/16/2009

02/17/2009

02/18/2009

02/19/2009

so the end date should be included

thanks

Hi,

The index is on the intID column. here is the script to create table and add data

create table Clients

(

intID INT,

...

If I run the proc with param 'Sp1' then i get the following:

Conversion failed when converting the nvarchar value 'Sp1' to data type int.