Search Results | SQL Server Performance Forums

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 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?

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?

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"?

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...

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....

To restore only 1 file out of 10 file?

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

HI All, I have one database that cantain 10 primary file(.mdf and .ndf) and out of it 1 file get corruptted. My backup shedule: Full backup in sunday...

only filename to be printed?

Thread by: mssql_dba_123, Nov 17, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

HI all, Please help me on problem I have my backup file save in one location ,now i want only backup file name not the path to be queryed when i...

LSN miss match error while loading the tranction log in DR server?

Thread by: mssql_dba_123, Nov 17, 2008, 4 replies, in forum: Getting Started

Hi All, we are using the log shipping for high aviability .But some tome we get an error that LSN missmatch error.We had temp. solution that we...