Hi Grant

Ok, take your point about Source Control and will look into it

Re Redgate Search Tool, just to confirm.

When the Search Tool returns say 10 Stored Procedure names, if you...

HI Grant. Thanks for that

I already have a search which lists out the Stored Procedures I am looking for, but what I cannot do is just click on one and...

Hi Thanks for your reply

No. SqlServer is not under Source Control

Hi Sue. Thanks for replying
Not sure what you mean by default instance or named instance.....don't really know what to check for......could you point me in the right direction

Hi
Going back to one of earlier replies
Is it possible to configure, on the one Physical machine, through HyperV or another
a Domian Controller
A SqlServer  Machine

.i.e....

Thanks again for your reply
Any idea of where on the logs to start looking
There seems to be a few 'Log Files'  and they just have hundreds of commands...

Thanks for your replies
So my only option would be:
4 pcs
Separate Machine (as   Domain Controller)
Separate Machine (As Sql Server Machine)

Seems like an overkill for...

Hi Vedran.

The problem is that I have tried numerous options now , and none is working.

I've tried removing columns, adding columns etc, to no avail

e.g.

MERGE TA AS T

USING TB AS...

Hy Lynn. Thanks for replying.

The sample I gave ws just a very simple sample to illustrate the error.

There are in fact 8 parameters input as :

@Type, @WhichFieldQuery,@CustomerFrom, @CustomerTo, @TranFrom,@TranTo, @dateFrom,@DateTo

The...

Hi Thanks for your reply

So, I gather then that ypu need to mention the Parameter twice ?

Once just after the Procure name

....ALTER PROCEDURE [dbo].[TestSPR]

... @P1 int

and again in the ExecSql...

Ok thanks for that.

So each time I Rtrim the variable and it seems to work

Ok. so how to enter Constraints ?

I checked SSMS and could not see an option for 'Constraints' where should I be looking ?