OK files almost work now but i have 2 probs and 1 question.....
1st)Again when i add the ranking script appears the same:
The CREATE DATABASE process is allocating 8.00 MB on disk 'Ranking_Data'.
The CREATE DATABASE process is allocating 32.00 MB on disk 'Ranking_Log'.
Server: Msg 15007, Level 16, State 1, Procedure sp_grantdbaccess, Line 97
The login '9226com' does not exist.
Server: Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 66
User or role '9226com' does not exist in this database.
Im not sure but i think it has sth to do with the add of user 9226com...... maybe in these lines
"if not exists (select * from dbo.sysusers where name = N'9226com' and uid < 16382)
EXEC sp_grantdbaccess N'9226com'
GO
exec sp_addrolemember N'db_owner', N'9226com'"
2nd)I still have the prob with the link 5
http://img97.imageshack.us/img97/5012/link56ev.jpg
Smo said it is a prob of the sa password, but it is coreect!!! Checked it many times... Do you have any other ideas?
3rd)How do i chage the name of the server?? :D