I don't think you can ever really do this for a deployed application where the SQLExpress DB exists on the user's machine.  It looks like the local admin will always...

Or of course you can just paste your query into EM and run it.  Select all the results and paste to Excel along with the column headers.

If you get to the point you feel you need to write some sort of looping structure you're probably going to be better off keeping that part of it in your...

I think the only way to do that for sure would be to encrypt each person's data with a different key.

Or put the data on different servers with different sa...

Query analyzer will script out creates/drops for individual objects.  If you want one file, you'll have to compile them together though.

Try adding the 'FOR xml auto, xmldata' syntax in the stored procedure when setting up the schema.

Then you have to take the ',xmldata' clause off before actually using it from an...

This is true for any references to the table as well as creating tables, nested stored procs etc...  You can't rely on it to generate the scripts with interdependent objects in...

You could create view(s) in the main DB that point to the dynamic DB(s) and just recreate the view with a reference to your new dynamic DB when that is...

SELECT

CASE

    WHEN @param = Code_1 THEN Lesson_1

    WHEN @param = Code_2 THEN Lesson_2

    WHEN @param = Code_3 THEN Lesson_3

    WHEN @param = Code_4 THEN Lesson_4

END  Lesson

FROM SomeTable

WHERE SomeField =...

You may try dropping indexes on the table that includes any of the updated fields, then add it back and rebuild it after the update is complete.

If you want it normalized you would probably break out the x, y, z values into a separate table with an identifier and add a junction table to link the two.

If there will...

You could create 3 different tables named sde, each with a different owner.  For example:

dbUser1.sde

dbUser2.sde

dbUser3.sde

If you're connecting with dbUser1 etc... then it should look for a table with that user as the owner.

Does the driver handle conversion of any numeric fields or does this need to be done in the update query?  I believe DB2 stores everything as a string correct?

Yes, I don't think you can use TOP with the aggregate function like that.  I believe bkelley was right except you were using the AVG function instead of SUM.

SELECT AVG(smu_reading) Total

FROM

(

  SELECT...

That was originally my thought, which was to use the native data encryption, but I could never find anything that explicitly said that SQLExpress would support it.  It doesn't support...