In the case of this particular data type, using it, in the past would have caused you grief.  When the internal definition changed (I think it was in 7.0), then...

The only other time I've seen this used is for tables created by vendors whose products reference the system tables.  I've never used it for anything.

From Book Online

sysname data type is nvarchar(128), which allows for 128 Unicode characters.

Expect different results as compared to earlier versions of SQL Server. Expect any columns or local...

I've seen these kind of confusing messages before when the script assumes that the user running it is either SA or has the target database set as his default and...

Perhaps we were identical twins separated at birth?

Could you run profiler while this is running so you can see what the script is trying to do and the exact database context?  What id are you logged on...

Just a couple of questions.

Is the table supposed to be in the master database, as the error indicates?

Might it have been created under an id other than dbo?

If you do...

Just some possible stuff:

This only works if this is a SQL Server authenticated id.

You might need quotes around the old and new password strings so that the command resolves to

exec...

Couldn't you do a sum(abs(a.correct)), instead of a count, to give you the total of correct questions?

Have the statistics been updated and the proc re-compiled?

At one place I worked, we ran into a bug that had to do with referencing values on the end of a...

You'll need to use a 'format file' (see the Books Online documentation for a good description).  Basically, the format file describes the input file and indicates which table columns correspond...

That would work if you got al the new stuff every hour and 'flattened' it.  That might be simpler and less maintenance overhead than the trigger solution. You could turn...

I've heard of 'Security by Obscurity' but this is my first encounter with 'Security by Chaos'.  When you think about it, though, there's a strange sort of organic sense to...

So, the rlvntdata table has a procid, a data type name, and the data value corresponding to that type name for that particular procid, correct?

In that case, the view is...

I think you need to wrap the updates in a begin-end block like:

IF EXISTS(SELECT User_ID FROM dbo.User_Information WHERE User_ID = @user-id)

Begin

UPDATE dbo.User_Information SET Salutation = @Salutation,...