If you have the password that was used when you created the database master key, you can use it to "introduce" the new master service key. You do that...

I would still check for the set options. Bellow there is a code that shows you what can happen when you use different set options at the procedure’s creating...

Since you didn't show us the table and proc's code, I can only assume that something like the code bellow would work

select min(status) from...

Adi

I think that in this type of question it is better to test it for yourself. It will be much faster then waiting for an answer, and there is...

Make sure that the login is not also a member of sysadmin server role. If a login is part of the sysadmin role, then it’s permissions are not being...

If we know that a car can have only one owner and it can’t have more then one owner, then I’d go with a foreign key like you suggested. ...

I think that this...

If you work with SQL Server 2000, my answer won’t work for you. Next time pleas give us more information. I suggest that you’ll fallow the link...

I’m not aware of such setting in the database or server level. I know that you can prevent page level lock on index and table level when you create...

A process that is killed and is doing a rollback cannot be killed again. You’ll have to wait until it will finish the rollback. By the way,...

Actually it has nothing to do with the edition that you work with. This procedure was needed in older version of SQL Server. If I’m not mistaken it...

Doesn’t DBCC FREESYSTEMCACHE clear only the memory structures? Are you sure that it shrinks the tempdb?. I don’t have here SQL Server 2000 to test it, but...

There is a KB article about it - http://support.microsoft.com/kb/906344/en-us

Adi

You need to specify the column's name after the first condition

select * from mitmas where mmitno like '%655599972D7%' or mmitno like '%655599989D7%'

Adi

I have to agree with Ninja's_RGR'us. Assuming that the column primaryKeyID is indeed the primary key, this statement should run very fast with row level lock and shouldn’t cause...