I’m sorry but your message is not very clear. From what I understand, you want to know if you can install SQL Server 2000 and SQL Server 2005 on...

Database owner can drop the database that he owns, but I think that you can create a DDL trigger on the server level that will prevent dropping the database. ...

I also agree. The whole table will be dropped.

Adi

Actually sp_helpuser returns only one recordset. In any case you can use this statement also:

select USER_NAME(role_principal_id) as RoleName, USER_NAME(member_principal_id)

from sys.database_role_members

Adi

I don’t think that it has to do with the package owner. The job has an owner. If you’ll right click on the job and then select properties,...

I’m not so sure that users will use the TDE on Express edition. Most of the time Express edition is not managed by a DBA. In fact in...

I also got it wrong because I didn’t select the answer – “When the session that created it ends”. The reason that I didn’t select it was that all...

I don’t think so. You can modify my script to create a database with few files and then modify the partition schema to use few files instead of...

The script bellow shows that you can create a foreign key that references a partitioned table. Can you post the script that you are using to create the foreign...

Can you check it using the sp_helpindex procedure? Just run it with the table's name and check the columns' names for the primary key and all unique...

If each time that a record is inserted into the table, you run an update statement on the new record, then I agree with you that you should use an...

Why aren’t you using an identity column? This will solve your problem and you won’t have to generate the primary key by yourself. If you can’t use an...

From the error message that you specified it seems that those 2 columns are not the columns that the primary key or any unique index. Could it be that...

I might be missing something, but if you are joining the table to another table, then you can get more records then you have in the original table.

Adi

I agree with Lynn. A combination of case and order by should do the trick.

Adi