It's generally reomended that sub queries go in the from clause, not in the select. Sub queries in the select get evaluated for every row of the result set and...

Try this

http://www.sql-shield.com/sql2k_spcrypto.txt

Where I live the term 'postal service' is a joke. It's more postal non-service Stuff takes a week or 2 weeks to get from one city to another (50km apart)....

It may also be that the indexes are fragmented. Performance degrades as indexes get more fragmented and it may be that recently the fragmentation reached a point where the query...

You can use a trigger to log inserts, updates and deletes. There's no way to audit selects though, not within SQL directly. Books online gives a good overview of trigger...

http://www.microsoft.com/learning/mcp/default.mspx

That'll give you a good overview of what certifications are available and what exams and courses exist for each.

Why do you say that? What exactly doesn't work? I've found it works in most places, missing a few irritating things (like picking up new tables, or when using 3-part...

As I said, it will force the database to grow again, when data is added. This grow may occur at a busy time, slowing the database down. It will fragment your indexes, possibly...

It's not considered good practice to shrink a production database.

If the database has been shrunk and new data is added then it has to grow again, probably at an...

I suggeested it as al alternative to a second table, which he said wasn't really what he was looking for.

A second thought, no need to do the update, can specify...

ALTER TABLE #Table

ADD Variable1 <data type>

ADD Variable2 <Data Type>

UPDATE #Table

SET Variable1 = @Var1, Variable2 = @Var2

Is that what you're looking for?

Is there a question here?

I would suggest you do an integrity check on your database. It looks like you might have allocation errors.

DBCC

CheckDB ('<YourDBName>')

That's users for you.

My pleasure, good luck hunting. If you do fnd the cause, please post your solution here.

It states 1 row inserted cause that's what you set @rowcount to...

SELECT @rowCount = Len(1) FROM inserted

Change that back to SELECT @rowCount = count(*) FROM inserted and the print will read...