Can't do it in query analyzer put your script in notepad or some other ascii text editor.

To do this you need to use the set identity_insert Tablename on.

Check out Identity_insert in Books online.

The temp table is only your first problem.

I don't think you can call function from functions either.

Use derived table.

Select count(*)

from (Select field

        From mytable

        where Foo = 'Somevalue'

        ....) As T

The way I can think of

is create a new filegroup, and a new file.

then move all objects from old filegroup to new one. Drop the old one.

Your going to have to restructure your xml.

as you have under column you have a element named coldata when parsing xml since the names are the same sql does not...

Your concatenating all fields together. I'd bet one of those fields is a bigint. and when concatenating to a string you need to cast it into a string first.

Double check...

It is in the Business intellegence studio,

but it is no longer called DTS

Its called Integration Services.

They completely re wrote it. It works completely differently than dts now.

http://www.sqlis.com/

for Tutorials and...

Sorry, Your using access, I missed that part.

try this

SELECT WRid, WRenteredDate, WRcurrentStatus, WRclaimNumber, WRstatusUpdated, WRsendToID, WRbillToID, WRrequestorID,

IsNull(sendto.COcontactNameLast,'NA') AS 'Send To',

IsNull(billto.COcontactNameLast,'NA') AS 'Bill To',

IsNull(req.COcontactNameLast,'NA') AS 'Client Rep',

, coalesce(PayDay,(DEaltKeyValue * 1), 0.00) as totPaid

, case WRcurrentStatus when 110 then...

Wierd,

if the same parameters are run from QA and when it was run in agent, I'd expect the same error.

QA should capture the same error as agent.

you still may have...

I do not believe there is a way to do this.

The user granting privileges must have access to the database, There is no way for a user to grant themselves...

Sure, but you'll have to put the relationships into a table, or inside of a stored procedure so you can use the query value.

This tutorial does it, but its example...

That error message indicates that your trying to put a value into a table that exceeds the data type, and or length.

For example your trying to stuff a 60 character...

Something is missing

in the mssql query your using a case statement to supply a value for DEaltKeyValue, it does not look like your outputting the same amount of columns.

Also structuring...

Wait: I just reread your post

Is user Rank a value you have in the view?

Is this what your looking for?

select UserID, ProjectID, User_Name, min(User_Rank) as User_Rank

from Myview

Group by UserID, ProjectID,...