These quereis might help. But bear in mind that these work on data since the last time SQL Server was restarted, so if that was recently, the queries might...

Try this:

INSERT into tbl_Assembly_Delay(ID, Code, DelayTime)

SELECT ID, '#Trim(FORM.Code)#', '#Trim(FORM.DelayTime)#'

FROM tbl_Assembly_Production

WHERE tbl_Assembly_Production.WorkOrder = '#FORM.WorkOrder#' ;

kabaari (8/26/2009)

---

Good morning all,

And thank i advance. I need to "UPDATE table2.ID with value from table1.ID on INSERT into table1"

Table1.ID is Identity Insert but table2.ID is Nullable. I want when...

What exactly are you trying to achieve here?

You say you're trying to achieve a nested transaction but that doesn't make much sense. So why don't you explain a bit...

What the previous poster meant was check the amount of free space in the distribution database - not the server. Just because the database is 59GB in size doesn't...

Gotta admit, I can't think of anything obvious. It doesn't sound like it's an issue but, like you say, it'd be nice to know where the space has come...

The other thing you can do is run dbcc updateusage(0), which corrects rowcount inaccuracies, which can cause wrong data to be presented when you run the space usage procedures.

I'm not...

It's quite probably that whilst you were doing all of those inserts, indexes became heavily fragmented and, quite possibly, caused lots of page splits.

I'd go through the exercise of re-indexing...

Yes, pretty much. Just copy the backup file to the secondary, restore it with norecovery and then get the copy job and the restore job back up and running....

In this situation I would be inclined to put all of the data into one table and then partition the table with one partition for each month. Thereafter, when...

You're pretty much spot on with your analysis. In the first example the nested query (or derived table as it's commonly referred to) runs first, the results of which...

I run a similar query to yours but I regularly dump that data into a dba database I've created and then I've hooked reporting services into it, which allows me...

As Gail pointed out, each entry relates to a specific statement within the procedure. I've modified your query so that it returns the actual statement each entry relates to....

ok, so what happens if you log on with 'sa' - does that work?

So you're saying you can't even logon to the SQL Server? Was the only login onto the SQL Server the local administrator login?

I'm wondering if the local admin login...