Oh ok,

Well each table will have a sessionID column that identifies which session the data belongs to.

A table row cannot exist without a sessionID entry.

So maybe I...

I guess I should have stated that the sessionID is inserted into every table when the stored procedure is called.

So there would be no chance of a sessionID be...

you know what? I think you are right...now there is no reason for this to be a temp table!

Thanks!

Oh ok, so basically I could get the sessionID in asp.net, and then pass that to the SPROC. And inside my "temp" table, I could add another column for...

Thanks everyone!

I don't think I would be able to use a .NET session or state table, because I need it to be in SQL Server.

Reason being, is...

Thanks!

Would 2 or more users then be able to run this stored procedure without "bumping" into each other?

I think the way I have it setup now, is that...

No, it was the full code...should I put an order by in there?

Thanks

Well it didn't group by group, institution, and then user. They are still all mixed up in the search results. I should have been more clear in what...

No, I never did find a backup. It wasn't too terrible because the system was only a development system. But it definitely taught me a lesson!

Ok, all I see is FULL in the backup_type. How do I turn on transactional logs?

Thanks!

How do I know if I have any transaction logs?

Thanks for all the input!

but it is the correct backup file. I even tested it again...and the files in the restore as option are always different from the actual name of the database.

Here...

Thanks...I figured that the best way to do this was just add the needed table to the full text catalog. 🙂

How can I add a partition Count column to my big query? Is that possible?

Thanks!

Here's what I have so far. As you can see, I tried adding a column that COUNTs the nodeIds. But I just get 1 for every row.

SELECT nl.nodeId,...