Request C-SRO certification and DB

[OutOfMemory]

Hello RZ members,

Could someone please upload for me his c-sro certification and database.

The one that released in full package are missed up.

Also which name is better for database to use SRO_R_Accountdb or SRO_AccountDB?

I noticed that global manager do a problem with one of them.

Thanks.

 

[pablitto15]

Hi is SRO_R_Accountdb and in ODBC is SRO_VT_ACCOUNT

 

[OutOfMemory]

what about this?

Global manager giving me this error when i try to enter to smc with gm account.

Also i changed the odbc to sro_accountdb and still same problem



Shard manager asking for different account db name lol

 

[Caosfox]

your inbox is full, but : you can fix it opening the procedures and checking the db names, procedures have wrong db names
im not working with csror or csro, so cant post any link with fixed db or cert

 

[OutOfMemory]

your inbox is full, but : you can fix it opening the procedures and checking the db names, procedures have wrong db names
im not working with csror or csro, so cant post any link with fixed db or cert

Thanks a lot for answering me.

 

[Cyberninjah]

i have gived a small query last week to check your procedures for specific text
http://forum.ragezone.com/f722/maybe-usefull-query-ppl-renamed-1054492/

You can use it to validate your names in the stored procedures

 

[OutOfMemory]

Thanks Cyberninjah, but the problem not from it.

I checked the procedures and seems that they are fine.

Could you please upload your csro db if you have one?

 

[Cyberninjah]

Uploading my db will not help you figure out where your problem is

Try to find out where the source of your problem is

so when you do this query on your shard database

SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%SRO_R_Accountdb%'

You get non results ?

are you running SQL 2005?

 

[Caosfox]

problem is at procedures, i downloaded the db, checked some procedures and yes, they point to wrong db names. you must change them to your db name

 

[OutOfMemory]

Okay guys thanks for help, i will re-check that.