Just in case you were not already convinced there is no way to prevent an SA user from seeing your code if its housed on a server they have access...

shagil.a.gopinath (7/19/2016)

---

Hi

In my table component information ID is stored as comma separated whenever multiple items are selected from the interface.

Scenario – 1

I would like to search with ComponentInfoID =...

Something like this?

With MyCTE(val)

AS

(

SELECT '9.0.0832.1032' UNION ALL --need to get the 32 (one after 08).

SELECT...

Hmm it would be impossible to help without first understanding, what is the relationship between these two screens and the database?

Is it a read and/or write of the same table...

Were you using Configuration Manager to push the Service Pack update? If so this may be your reason and answer/workarounds.

CONFIGURATION MANAGER UPDATE ISSUES LINK

as this issue has been awhile your first reported error was...

As that may or may not be...

Yes install Business Intelligence Studio 2008 and then load your 2005 package into that IDE. Deal with any errors that the IDE reports then run test in the IDE...

My first question is did you load the 2005 package in a 2008 BIDS session? Sometimes doing this and saving the package, then reloading to the server will solve...

GonnaCatchIT (7/8/2016)

---

We have SQL Server hosted on different physical server managed entirely by different vendors.

You mean .net 3.5.1 is required on sql server box as well ?...

I have tried DTCPing...

Meant that for the SQL Server sorry for not specifying.

Have you run the BPA on your SQL Server?

Assumptions:

Server Level Logon is already a user to the database in question.

You want to apply a deny (restrict) user to a specific table in a database.

User in database is NOT...

dandrews 45259 (7/7/2016)

---

I've got a complex bit of sql that took a lot of work to get working to view our bill of material levels at the same time. ...

GonnaCatchIT (7/7/2016)

---

You mean just change the IIS .net framework to 3.5 and try? , we have not done this as all our .net dll's are built in .net 2.0 framework......

You might want to look at using a global table for this work.

Is the .NET 3.5 Framework role installed on the Server?

If not, install it and retry.