GilaMonster,

Thanks for your quickly reply.

In this case, the application uses a web service, but it is a windows application, installed and used just inside an intranet. I think i do...

Hi,

Steve block,

Most of cases, the full name is fullfilled. Its about patient names. But i agree with you.

SSCommited,

I don't know how to work with full search.. Can you point me...

I've found another solution using dynamic sql:

DECLARE @NAME VARCHAR(100)

SET @NAME = 'john charles smith'

declare @CMD VARCHAR(8000)

SET @CMD = ('

SELECT

*

FROM USERS

WHERE

SEARCH_NAME LIKE ''% '+replace(@NAME,' ',' %'' AND SEARCH_NAME...

Thanks for your help.

Assuming that the user do not will search for 9 or more names of a patient i will use something like this:

SELECT

*

FROM

USERS

WHERE

NAME IS NOT NULL

AND (

NAME...

Chris,

Yes, there are other parameters, such as birthdate, number, but in this case i only want to search by name.

Thanks for remember the endless possibilities..

SSCommitted,

I've tried create the select statement...

Thanks for your help.

Since i already created the individual stored procedures for each step, which returns the 'scope_identity' value, i'm thinking to use transaction scope, like in this link (

Sean,

I was really thinking in 'using' statement in c# 🙂 I'll read some on connection pooling.

Craig,

I had already thought about re-design the apllication, but it scares me a litlle.. :unsure:...

SeanLange, thanks for your reply. 🙂

I really was not disposing the connection, i was just closing it. :s

Regarding the try-catch blocks, i will make sure that all of them are...

I tryed reboot the server and it works! Thanks! 🙂

Thank you a lot! I will follow what you said! 🙂

Hi, i'm trying use this code and i do not have the '?' symbols, i rewrite the code in a new query and continues giving the error

"Incorrect syntax near '?'."

Any...

Hi,

i faced a similar problem and i created a stored procedure that uses bcp, fmt format file and xp_cmdshell..

The code follow this:

select @cmd = 'bcp "SELECT column from table" queryout...

Matthew Bryant,

Thanks for your reply.

Hi Elliott W,

Thanks for your reply.

Now, the problem is solved. It was a proxy server that was blocking the access to database server..

Are there any freeware tools that help to manage database version?