Sounds like you have some hard coded items in the package. Are you using an XML config file, or a SQL Table to store the config items that need to...

Lady

Try removing the ""SET NOCOUNT ON" statement for one time. I just read something about that. I am using it in my sproc, but it may be worth a shot...

Have you tried to just run a query:

SELECT

GroupId

, GroupName

, FileTypeName

, SubjectID

FROM

dbo.MyTable

WHERE

SubjectId = 'FBBE20B1-55F1-E111-BF73-00155D062F00'

ORDER BY

FileTypeName ASC

To see if there is a row with...

Have you tried to setup a test page with all the items hard coded? Do you get a resultset using only SSMS and that same string? Have you tried CASTing...

I am not seeing anywhere that you are opening and closing your connection.

Why would are you passing in the connectionstring, and the sproc name? I believe in code re-use, but...

I just saw this:

But in the sproc that you sent, you have a "begin" with no "end"

There is really no reason to have the "begin". Remove that. Unless you are...

What you are showing is only the Code to add the variable data to the stored procedure call. Not the Code to actually open the connection, call the sproc name,...

Have you tried changing the database connection string?

That is not a good idea to do nothing at all to the tables, indexes, etc... If you take a little time now,...

Sounds like the owner of the object that you are using, like dbo.ObjectName, does not actually own the object. Look at the properties of the object to verify who actually...

Luis

Thank you also. The query that you suggested worked also. I did not mean to lave you out of my last post.

Thank you

Andrew SQLDBA

Thanks Sean

That is perfect and just what I was after.

Thank You

Andrew SQLDBA

I thought of that, but it will not work because that query returns all tables in the database.

I am looking for a way to return the max Column number for...

You should not be inserting into All three tables. You should be inserting data into one, the table named "Bio". The other two tables are list tables. Those tables would...

You Must provide the IDs from each of those tables in your INSERT statement.

INSERT INTO BIO

(

, FirsName

, MiddleName

, LastName

, SexID

, StatusID

)

VALUES

(

'Sammy'

, NULL

, 'Johnson'

, 1

, 1

)

That is what...

You really need to have an associative table. You should Never, Ever store data in a delimited string like that. Change that and your database coding life will become so...