While I'm not sure I can answer the questions on solving the lock, I can offer these few data that might help.

First, a table variable can end up with schema...

GilaMonster (9/8/2008)

---

GSquared (9/5/2008)

---

I moved a database just last week just using the Alter Database commands, and the files ended up where I wanted them. Of course, that was tempdb,...

I have to ask what goal you are aiming for.

To what end are you copying data from one database to another?

The reason for it will help me suggest the best...

BCP should be able to do that. Check it out and see if it will do what you need.

A single-table hierarchy should handle this, unless you are tracking something more complex than geneology.

If you had a table with PersonID, Gender, FatherID, MotherID (and any other columns you need,...

CP1 = Code Page 1252, which is the set of characters supported.

For the same reason you don't have Order By in a table (clustered index isn't the same as Order By).

Like Gail said, it's because those objects exist to be queried....

This function will very rapidly parse out lists like that into columns.

ALTER function [dbo].[StringParserXML]

(@String_in varchar(max),

@Delimiter_in char(10))

returns @Parsed table (

Row int,

Parsed varchar(100))

as

begin

if right(@string_in, 1) = @delimiter_in

select @string_in = left(@string_in, len(@string_in) -...

Not sure what you mean by "existing report". Do you mean a report built in some other application?

Once you know what order you want the data in, you can use the Row_Number function to get the 40th row (or any other) pretty easily.

For example:

;with CTE (ID, Row)...

Is the executable something that could be done by a CLR proc called by a trigger? I think that can be done, but I'm not sure how well it...

The only way to have a variable table name would be to use dynamic SQL. You can't use dynamic SQL in a function.

Can you use a proc instead of...

You can do this either way, or as a mixture.

Using a table of usernames and passwords is certainly the easiest to build and administer, for a simple application. It...

Hire someone who has those skills, probably as a contractor, and have them do it for you.

What you're asking is a fairly complex project (depending on the databases and applications)...

I would assume Oracle has some sort of transaction log, which you could use for that.

You might be better off asking that question on an Oracle forum, since this is...