Search Results | SQL Server Performance Forums

sql server 2005 blocking locks

Post by: mssql_dba_123, Jun 4, 2009 in forum: SQL Server 2005 General DBA Questions

Hi Vijay, I would no sggest to kill any process in production enviroment ,before consulting our appication team. And in 2005 there is system view...

Is there sany way to find out how may virtual log file does my tansaction log file has?

Thread by: mssql_dba_123, May 26, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, Is there sany way to find out how may virtual log file does my tansaction log file has?

Can user defined role be owner of fixed database role?

Post by: mssql_dba_123, May 22, 2009 in forum: SQL Server 2005 General DBA Questions

Hi Satya, I our enviroment we are creating a user role and grant some fixed server role. ANd this user role is assinged to any group or user for...

Can i find which process is using max cpu utilization in sql server?

Post by: mssql_dba_123, May 22, 2009 in forum: SQL Server 2005 General DBA Questions

Thanks Satya for you help...It's helping a lot.... But is there is any way to find out a particular proccess using a MAX CPU...or CPU % through query...

Can i find which process is using max cpu utilization in sql server?

Thread by: mssql_dba_123, May 20, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I want to find which process is using max cpu. we can find through task manager...but we cannot find for indiviual process. Through sp_who2...

Can user defined role be owner of fixed database role?

Post by: mssql_dba_123, May 20, 2009 in forum: SQL Server 2005 General DBA Questions

Hi Franks, No... Lets explain by example.. Suppose i create on role db_read use databasename go sp_addrole 'db_read ' Then i add fixed database role...

Can user defined role be owner of fixed database role?

Thread by: mssql_dba_123, May 11, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, Can user defined role be owner of fixed database role? If yes Then please let me know how to find out fixed database role permission to user...

How can i find when column is added in table?

Post by: mssql_dba_123, May 5, 2009 in forum: SQL Server 2005 General DBA Questions

Is there any other way to find out the same without using trigger?

How can i find when column is added in table?

Thread by: mssql_dba_123, May 4, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, Is there any way to find out when particular column is added in table? Thanks in advance..

When adding sql server logins ,its failing with below error?

Thread by: mssql_dba_123, Apr 1, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

The server principal 'logins_name'already exists. when check login and user for database there is no user with the same name. Pleae help

Error while granting insert permission to user?

Thread by: mssql_dba_123, Mar 31, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Msg 4606, Level 16, State 1, Line 2 Granted or revoked privilege INSERT is not compatible with object

Can we define not null constraint in unique column?

Thread by: mssql_dba_123, Mar 19, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, Can we define not null constraint in unique column?

Wnat to restore master database --Giving error?

Thread by: mssql_dba_123, Mar 18, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi i want ot restore master database . FOr that i try to start my instance in single user mode.... But give below error: C:Program FilesMicrosoft SQL...

SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll"?

Post by: mssql_dba_123, Jan 19, 2009 in forum: SQL Server 2005 General DBA Questions

HI All, Issue is resolved. The reason is when we run setup.exe of sql2000 which is kept on other remote system it not copied the file due to some...

SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll"?

Thread by: mssql_dba_123, Jan 19, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi all, My sql 2000 set up failed with the error SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll" Please help .... Thanks in...

SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll"

Thread by: mssql_dba_123, Jan 19, 2009, 1 replies, in forum: General DBA Questions

Hi All, My sql 2000 set up failed with the error SQL setup failed with the error "LoadLibrary failed on sqlsrs.rll" Please help .... Thanks in...

How can you find the dependencies of a table accross databases

Thread by: mssql_dba_123, Jan 3, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Normally sp_depends will provide information for all dependent objects on a particular objects, or through a GUI tool you can see it in a more...

How can you find the dependencies of a table accross databases?

Thread by: mssql_dba_123, Jan 3, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Normally sp_depends will provide information for all dependent objects on a particular objects, or through a GUI tool you can see it in a more...

To restore only 1 file out of 10 file?

Post by: mssql_dba_123, Dec 23, 2008 in forum: SQL Server 2005 General DBA Questions

No......

Space issue on the hard disk?

Thread by: mssql_dba_123, Dec 17, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I have to restore one database from prodution server to development server.But it show there is insufficient space to load the database....