This web page is about MS SQL. You might do well to try an Oracle web page.

The first one has an unmatched open-single-quote. I copied it into Management Studio, and it's pretty clear there.

You'll need to wrap the count in a sum.

Isn't that just the most recent log backup?

The primary disadvantage to indexed views is that they increase the overhead for insert/update/delete actions on any of the referenced tables.

You'll need to drop and re-create the connections.

Since I haven't tried doing what you're proposing, and don't have a system to spare right now for testing it, I can't say one way or the other whether it...

Nope. I figured it out on my own. Which is one of the reasons I say it's probably not an ideal solution, but it does work.

The way I...

That makes sense. Glad you sorted it out.

Hate to say it, but read your own arguments about it not being right. Every single one of them says, "once a seed value has been set".

The question is...

In SQL 2005, this would be dead-easy, with the row_number() and except commands. In 2000, the only thing I can think of requires dumping the data into temp tables...

You might be able to achieve that with the OpenRowset function wrapped around the exec command. Check that out.

Are you running this on an isolated system, with you as the only user?

If not, because it's a global temp table, once it's created, multiple copies of the proc can...

It's been a while since I used SQL 2000, but if I remember correctly, you should be able to select from the syscolumns table and get all the columns in...

halifaxdal (7/25/2008)

I've tested the syntax of the command I suggested, through xp_cmdshell, and it works.

If the folder name has spaces in it, it needs to be in double-quotes.

You also need...