database problem

[ultimatehex]

when i try to modify something in database its say me can`t start in firehouse mod what is this..i dont`t know what to do...what should i do..or how can i reinstall mssql and database without lose accounts?

 

[chumpywumpy]

when i try to modify something in database its say me can`t start in firehouse mod what is this.?

Eh? Do ou have a screenshot of the error?

.or how can i reinstall mssql and database without lose accounts?

Just take a backup of the databases. Either that or right-click them and find the directory the mdf/ldf files is in (C:\Program Files\Microsoft SQL Server\MSSQL\Data normally). Now detatch each of the databases and take copies of the mdf/ldf so you can attach the again later after reinstalling.

 

[ultimatehex]

...and when this problem start,players complain to me that they can`t see guild,buddy list and can`t wishper...what can i do chumpy help pls?

 

[chumpywumpy]

Did you just try opening that char table with a "return all rows"? Your DB will NOT thank you for doing that if the table is big.

Use queries to get to the data you need and try to limit the data returned to just the bits you need. Try avoiding returning entire tables unless you really must see every record.

Last 50 chars created:
select top 50 * from cabal_character_table order by CreateDate desc

Last 50 logged in:
select top 50 * from cabal_character_table order by LoginTime desc

Find chars with "ichi" in their name:
select * from cabal_character_table where Name like '%ichi%'