I don't know of a way to "cache" parameters for use by multiple reports when navigating through the RS interface. The only way would be to setup defaults for...

I would agree with twillcomp. The application si probably using @@IDENTITY. I'd drop the identity column from the status changes table.

Does adding a trigger to the application's database...

Lynn's solution will work, is simpler, and doesn't need an arbitrary number. The only issue is that some UI's don't like the warning so you need to SET ANSI_WARNINGS...

Typically a string split using a numbers/Tally table or CTE will outperform a while loop. For a small list a while loop is probably okay. Here is the...

Are these subreports or reports you have to navigate to through the report server interface?

Any error messages in the database mail log? Where are putting the non-existent account, E-Mail Address or Reply e-mail? I have tested this at my shop and it...

Something like this works:

Declare @stocks TABLE([dAte] SMALLDATETIME, [nAme] CHAR(1), Buy INT, sell INT)

INSERT INTO @stocks (

dAte,

[nAme],

Buy,

sell

)

SELECT

'1-1-2008', 'A', 1, 4

UNION ALL

SELECT

'1-1-2008', 'A',...

I would define Optimization as jobs that reorganize/rebuild indexes and update statistics.

Integrity Jobs verify that the data on disk is not corrupt. For Integrity things you should read Paul...

I can't duplicate your error, of course I don't have a 1GB file either. I have included all the columns mentioned in the 2000 KB error and have multiple...

What's the other way you found?

I found 2 bugs listed for fn_trace_gettable in SQL Server 2000. This one was fixed in SP3. This one does not have a fix listed.

I have not found...

I think this will work:

IF OBJECT_ID('dbo.Table1') IS NOT NULL

DROP TABLE table1

IF OBJECT_ID('dbo.Table2') IS NOT NULL

DROP TABLE table2

...

I'm going to have to agree with GSquared on this one. This definitely does not belong in a trigger and as Gail said the trigger runs on the server so...

Gus and Gail have both been to this one, but I had to put it here. I'd like to know what resources he has read on triggers.

You can issue the command Set Identity_Insert [TableName] On before you start the insert and then Set Identity_Insert [TableName] Off when you are done.

Yes, nulls will cause a problem because...