yes i added but at the end the ok button is not displaying/disabled.

Any setting or installation issue.

adding some more details.

After adding backup folder path ,setting the schedule at the end that ok button is disabled ? how to enable that.

Database is in full recovery model only.

Any...

Can we attach only .MDF file through cmd mode.

Hi,

By seeing this error what i can suggest is to check whether model databaese .ldf file is their or not. Please check it.:-P

Hi,

This is not specific to one table but this error is for all i,e in DB->tables->click on that then we get this error.

Can we increase lock_timeout period , do...

Roy,

Yes i will check about that and any other things i can cross check as a DBA.

yes u r right but daily i see many process are getting blocked. Most of them are select queries but after killing that process the it works fine or...

Hi,

Yes i can find which process is blocking and the conern SPID also, i will kill that process at that moment it will be fine but this issur occurs after...

Hi,

I login as SA and checked, but same issue is there???:hehe:

I have full admin access and i can see login aduit option screen but that option window is showing faded color i,e i can't edit that option but same thing...

I am using Enterprise edition with sp3.

hi,

If i go to Database server->properties->Security option

their using Login audit window will be enable to select to options but in my server login audit option is not enable i,e i...

yes we can do that for some testing purpose i need to enable that option but that login audit option is disabled in database server properties- security option.

Hi dugi,

If i grant create table and alter permission, then the user can drop the table i have crosschecked, but if deny createtable and alter table then the ...

Hi,

In order to shrink the log file ,from Sql server managment studo

1. Take the log backup of the db

2. then right clk db ,select tasks--> shrink--> their select Log its...