Laura,

Sorry it took so long to get to...

Did you run ALL the sp_configure commands in the same order I listed them? The first one enables you to see the advanced options which is what common criteria...

You probably have Developer Edition on the PC where you are developing the package which allows the Fuzzy lookup to work, but Standard Edition does not include the Fuzzy Lookup...

Okay since, you are on SQL Server 2005, it looks like you may have common criteria compliance enabled (newer than C2 Auditing) or someone has configured a trace to start...

I'm actually seeing more recognition that everyone in sysadmin is the wrong way to...

If you are running SQL Server 2000 what does this return:

SELECT * FROM fn_trace_getinfo(Default) AS FTG

If you are running 2005/2008 what does this return:

Select * From sys.traces

Also if you are...

My preference, and I emphasis preference, is this:

CREATE TABLE dbo.User_Log

(

User_Log_Id INT IDENTITY(1,1) PRIMARY KEY,

UserId INT NOT NULL,

...

That query should be selective enough to use an index lock, which in theory, should allow you to do operations on other types ('c'). What is the query...

You need to list the columns you are inserting into unless you are inserting into every column in the table, like this:

INSERT INTO tblMyTable

(

...

Just put everyone in db_datareader role. That's good enough security.

Glad I could help.

If you are using Windows Authentication for your users you can suser_sname() to return the user name.

When you install the ReportServer service on the other machine you tell it to use/install the ReportServer database(s) on the Server that has the database engine installed.

Sorry, my bad. It's not:

=ReportItems.textbox1.Value + ReportItems.textbox2.Value

it is:

=ReportItems!textbox1.Value + ReportItems!textbox2.Value

Replace the period after ReportItems with an "!". I always do that:w00t:

Yes it is possible. You need 2 SQL Server licenses though.