I have given a user db_datareader owned_schema and now i what to change it to db_datawriter ,but unable to change because db_datareader is in...
Is it possible to monitor the memory usage through DBCC Perf command..........
Iam a sysadmin,i saw that Login properties->status->"Login is Locked Out tab is showing disabled always,unable to check or uncheck the...
what the system tables available in the master database in sqlserver 2005? i know that in sqlserver 2005 system tables are hidden,i want to know that...
Hi,this question is asked by an interviewer,how to take the logical backup using export/import... is it possible or feature available in sqlserver...
Hi,can any one tell me what would be the roles and responsibilites as a DBA for L3 position.
Hi,Iam configuring logshipping for the first time, i configured logshipping successfully,transaction backup is happing but it is not copying and...
Iam new DBA i have gone through the many books for performance counter baseline values(Recommned values) many have give different values, could...
Hi DBA guru's
iam unable to back up the transaction log, because it is in disable state,how to enable the transaction log?
Hi DBA guru's
How to recover/get back the lost/missing Transaction log file?
How to trace the Database space of all database rather than single database by using sp_spaceused?
How to find the long running queries & Network performance issues?
Iam new to the sql-server performance topic, i like to know the recomended values for the sql-server counter?
Could any let me know.
the user is unable to open the application......... i can i know what wuld be the problem..how to slove the issue.( performance issue and network...
Separate names with a comma.