Viewing 15 posts - 721 through 735 (of 1,478 total)
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2009 at 3:38 am
I also agree. The whole table will be dropped.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 28, 2009 at 8:24 am
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 22, 2009 at 8:46 am
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,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 22, 2009 at 7:29 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 20, 2009 at 2:39 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 17, 2009 at 7:35 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 1:59 pm
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 7:01 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 5:16 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 5:11 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 4:53 am
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 16, 2009 at 4:22 am
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2009 at 8:01 am
I agree with Lynn. A combination of case and order by should do the trick.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2009 at 6:55 am
Could it be that you are mixing between file groups and schemas? File groups have no owner.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 15, 2009 at 4:38 am
Viewing 15 posts - 721 through 735 (of 1,478 total)