are there any other inserts in to other tables with a similar identity? try using scope_identity over @@identity

thank you all very much

Thanks will try that

HI, im currently working on importing an XML document using

exec sp_xml_preparedocument @idoc output, @xml_in

what i want to do is to be able to pass the @xml_in a file path...

Thanks, thought it might be that easy lol *** goes and cowers in a corner ***** :w00t:

I read it that you are saying

your current script returns

2

10

19

However, what you want like for example is 1 row to be returned that would sum the above results so the...

can you provide some sample data, have a look at some of the other threads see how when asking for help they add in scripts to create replica data as...

Personally I would leave the compatibility level at 80 for now and like other people have mentioned in this thread, create a test environment and then thou rally test your...

how about using triggers and an audit table for insert update and delete. So every time a record is updated inserted or deleted yoit will be added to a log...

Have you tried running BCP from a batchfile

???

SET database=yourdbname

SET Sever=yourSQLserverinstance

bcp %DATABASE%.dbo.yourtable out "yourtable.bcp" -n -T -S%

Depending on what you are doing i like to user variable temp tables, there is no need to drop them at the end because once the script as completed execution...

its ok found the issue databse compatability level was the wrong type for this query thank you 🙂 retrieve server from the abis 🙂

updated my SQL to only report on...

Thanks ok so i found the below script however, this only works when i run it against the master DB can anyone help????

SELECT TOP 50 creation_time, last_execution_time, total_clr_time,

...

HI thanks for all this info, not sure about 1 plan executing several hundred times how do i find that information? just looking on the activity monitor the column header...

im not sure i entirly get what your asking for but, as i read it sounds like you want to pivot the data, look up pivot tables