Honestly, neither.

What scares me is medical data. I was working for a software start-up that provided software to doctors. Not only did it store full patient history, but it had...

We did tests in the past and found that for simple lists, UDF's were WAY better than XML. XML started to shine when we were working with more complex structures.

BTW,...

You can use the SQL Server Management Studio to connect to and work with Compact databases though, if that helps. It's not stored procedures but it is a bit easier...

Version 8.0 is actually "SQL Server 2000."

It sounds like security has changed inside your database? Possibly.

What error? Are you running in SQL Server 2008? This is a 2008 forum.

Looks like tempdb ran out of space.

Either you ran a query against such a large amount of data that you maxed out your tempdb or you may have something wrong...

Also it could be the statistics are changing in your data. Make sure that they're up to date. It's really important, as noted above, to look at the execution plan,...

Database design theory, I'll leave to someone else. I'm using an ancient text called "Handbook of Relational Database Design" by Fleming & von Halle. It's too basic for most of...

Oops. Missed that one. I hate when I get hung on the first error I see.

How about

OUTPUT INSERTED.CategoryId

because there wasn't a column in the list called ID

I don't think that's possible. Unless there's a way to make the Compact database a linked server, there's no way to open a connection within TSQL. You could write CLR...

I agree that NOT using a cursor is an even better approach.

However, to answer your question, I wouldn't use the WHILE loop with a BREAK statement because it's really a...

It sure sounds like you need to set up Profiler. That will capture the stored procedure calls along with the parameters passed, no extra code on your part required. You...

A teenager down at the dojo says I'm losing my touch... He's testing in August. I'll "touch" him then.

Anyway, glad to be of use. One other point worth mentioning is...

Not even, don't worry about it.

You've got a lot of options. You mentioned triggers. That is one possibility. Another would be to use the OUTPUT clause from your data modification...