|
Post Ranks
-
10-16-2006, 2:29 PM |
-
xmldeveloper
-
-
-
Joined on 01-18-2006
-
Bucharest, Romania
-
Rank NA
-
-
|
Pentru a face site-ul un pic mai amuzant am creat urmatoarele ranguri: Name | Min Posts | Max Posts | db_datareader | 0 | 1 | db_datawriter | 2 | 20 | db_owner | 21 | 100 | sysadmin | 101 | 1000 |
Comentarii ? Pareri ?
Cristian Andrei Lefter, SQL Server MVP MCT, MCSA, MCDBA, MCAD, MCSD .NET, MCTS, MCITP - Database Administrator SQL Server 2005 http://sqlserver.ro
|
|
-
10-16-2006, 2:56 PM |
-
ggciubuc
-
-
-
Joined on 03-18-2006
-
Bucharest
-
sysadmin
-
-
|
Si uite asa ajungem la CREATE PARTITION FUNCTION
[CristiPF1](int) AS RANGE LEFT FOR VALUES (1, 20,100,1000) (vezi http://sqlserver.ro/forums/thread/376.aspx) ; dar partitia de la 1000 incolo cum se cheama ?
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
|
|
-
10-16-2006, 3:00 PM |
-
xmldeveloper
-
-
-
Joined on 01-18-2006
-
Bucharest, Romania
-
Rank NA
-
-
|
Asta e problema: Community Server nu te lasa sa specifici o partitie de la 1000 incolo Te lasa de la 1000 la X (ambele limite trebuie specificate).
Cristian Andrei Lefter, SQL Server MVP MCT, MCSA, MCDBA, MCAD, MCSD .NET, MCTS, MCITP - Database Administrator SQL Server 2005 http://sqlserver.ro
|
|
-
10-16-2006, 3:05 PM |
-
10-16-2006, 3:06 PM |
-
10-16-2006, 3:33 PM |
-
narcis
-
-
-
Joined on 01-18-2006
-
-
db_datawriter
-
-
|
Combinand putin din propunerea lui Cristi si putin pe langa rolurile din SQL Server am ajuns la urmatoarea sugestie: db_newbie intre 0 si 20 db_backupoperator intre 21 si 50 db_datareader intre 51 si 100 db_datawriter intre 101 si 200 db_owner intre 201 si 500 sysadmin intre 501 si 1000 forum's_proffesional intre 1001 si 2000
Narcis Ditiu, MCT MCSA, MCDBA, MCSE, CCNA
|
|
-
10-16-2006, 4:32 PM |
-
10-16-2006, 4:58 PM |
-
10-16-2006, 9:43 PM |
-
ggciubuc
-
-
-
Joined on 03-18-2006
-
Bucharest
-
sysadmin
-
-
|
Daca este posibil un calcul, ar trebuie ponderate interventiile pe forum: adica de exemplu cine face articole sa aiba 2 puncte sau 3 in loc de unu, iar cine zice un "asa e" juma de punct
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
|
|
-
10-16-2006, 9:44 PM |
-
10-16-2006, 9:59 PM |
-
ggciubuc
-
-
-
Joined on 03-18-2006
-
Bucharest
-
sysadmin
-
-
|
Bine , si eu sunt pentru. Problema este cum facem cu aglomeratia de la partitiile cu db_datareader sau db_datawriter . Aici as vrea sa gasim solutii doamnelor, domnisoarelor si domnilor !
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
|
|
-
10-17-2006, 9:21 AM |
-
10-20-2006, 10:57 AM |
-
ggciubuc
-
-
-
Joined on 03-18-2006
-
Bucharest
-
sysadmin
-
-
|
Pe un alt forum ( http://www.kdkeys.net ) am gasit varianta cu New member Gold member Platinum member Bronze member Diamond member deci tema cu medalii olimpice.
Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
|
|
-
10-20-2006, 12:25 PM |
-
xmldeveloper
-
-
-
Joined on 01-18-2006
-
Bucharest, Romania
-
Rank NA
-
-
|
Este o varianta. Insa inca prefer varianta fixed database roles si fixed server roles
Cristian Andrei Lefter, SQL Server MVP MCT, MCSA, MCDBA, MCAD, MCSD .NET, MCTS, MCITP - Database Administrator SQL Server 2005 http://sqlserver.ro
|
|
|
|
|