Hi,

yes i checked the database limit it is 4GB now what i am confused about is can i have multiple database in which each can expand to 4gb or all...

Hi,

thanx for the prompt help guys, basically if we don't allow remote connections from internet then sql server management studio can't connect to it from the internet, so we have...

Hi

can you guys tell me what will be the straight forward way to change the password for sa account through sql server management studio,

and somebody mentioned that login _triggers...

Hi,

thanx for usefull information guys, the reason why i cannot disable the sa account because helm the web hosting control panel uses this account to create databases and the reason...

Hi,

another question poped into my mind, if we rename the sa account will the sa account privileges be transfered for all databases to the new account the we have renamed.

please...

Ok,

but that will make the count to 6 that means that the user created by helm as db user is not counted or one of them you have mentioned is...

Hi,

i created a new database and it also showed 5 users, i think

1) sa

2) username created by helm

what do you suggest for 3 4 and 5 are these system...

Hi,

the password is already in place can you tell me the way i can rename the sa account to some other name so that people can never guess the password...

hi,

thanx for prompt replies guys,

well the server is web facing is hosting many websites and we have to give sql server management access to people so i think the best...

Hi,

thanx for reply

can you tell me the whole command sp_cycle_errorlog so that i can use it, as i am very new to sql server and what do you recommedn how...

Hi,

Not very often only when sql server reports some error or stops responding

Do you ever...

sorry i am new i have edited it to quote

If the log...

Hi,

the file name are ERRORLOG AND ERRORLOG.1 are the biggest first one is 3gb and second one is 2gb

please recommend

Hi,

That's the option you want. To know how big to make it, you need to know how much space the log typically uses. If you don't know, maybe leave the...

Hi,

thanx for fast reply

when we go to shrink file and choose log under shrink action it shows the following

release unused space

or

reorganize pages before releasing unused space

shrink file to...