Have you tried using the Dedicated Admin Connection? (Look it up in Books Online if you're not sure how to do that.) That should allow you to fix...

Yes, I would expect this to run slowly. I'd start rewriting it from the GoTo statements (get rid of them and use Begin...End for the If), change the Not...

Here's a test you can run, that includes log-reading functions:

create function LogReader_Table1

(@XML_in XML)

returns @T1 table (

ID int,

Act char(1),

Col1_From varchar(100),

Col1_To varchar(100),

Col2_From varchar(100),

Col2_To int)

as

begin

insert into @T1 (ID, Act, Col1_From, Col1_To, Col2_From, Col2_To)

select...

Yeah, I forgot about one detail. You have to assign the XML to an XML variable, then insert that. Otherwise, you get that error.

As far as querying XML...

Unless you're talking about hundreds...

Kaushal (7/21/2008)

I think the OP wants to know the...

Can you run a backup of the source database, restore that under a different name, and do your export from that? (Either directly to the target server, or to...

You could do:

select ManagerName

from ManagersInfo

inner join WorkInfo

on EmployeeNumber between begin_value and end_value

Does that get you what you need?

There isn't such a table.

Are the databases on different servers?

If so, you might want to export the data into a text file (or something similar), then bulk import it. You can bulk import...

Is the database detached, or do you just not have the rights to see it?

I've really only had two IT jobs, and neither has been bad. The first company was messed up, but my job was okay.

One bad job I had was "stickering...

I try my hardest to be arrogant, but just can't seem to get it right! 🙂

And, perhaps more importantly, are you selecting from the temporary table in the same query (or on the same connection) as you created it?

Just as a test, I ran:

create table #Runtime (

Version int,

Runtime int)

go

declare @Start datetime, @X int

select @start = getdate()

select @x = col2

from dbo.sometable

insert into #runtime (version, runtime)

select 1, datediff(ms, @start, getdate())

go...