Search Results | SQL Server Performance Forums

What are the reasons why Database Mirroring cannot be used for system databases?

Thread by: pcsql, May 4, 2009, 1 replies, in forum: SQL Server 2005 Database Mirroring

I just want to know the reasons why Database Mirroring cannot be used for system databases.

How to set up SQL Web Data Administrator in Windows XP?

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

I have downloaded SQL Web Data Administrator from CodePlex and unzipped the files. The setup instructions in CodePlex are not quite clear. I cannot...

Is there a way to configure Activity Monitor?

Thread by: pcsql, Oct 9, 2008, 1 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I'm using SQL Server 2008 RTM and connecting to SSMS as sa. The SQL Server 2008 Activity Monitor is missing some columns such as host, net library,...

Is there any function or system view to show connection pooling setting?

Thread by: pcsql, Oct 8, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

How can I find out whether a connection is connected with connection pooling enabled?

How to truncate log in SQL Server 2008?

Thread by: pcsql, Oct 1, 2008, 9 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I want to replace the coding Backup Log with Truncate_Only in a sql script. If I understand correctly, I need to do the following: alter database...

Difference among functions like original_login, system_user

Thread by: pcsql, Sep 16, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

I'm trying to understand the differences among the following functions: Functions returning login original_login() - original login name not...

Can SQL Server Profiler use to trace which filegroup is used?

Thread by: pcsql, Sep 11, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Can I use Profiler to trace which filegroup is used? I'm trying to trace which filegroup is used for a table which is partitioned using partition...

What are different ways to find out the permissions granted to a particular user?

Thread by: pcsql, Sep 4, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Besides using sp_helprotect, what are other system functions/system stored procedures/system tables/system views that I can use to find out granted...

Which SQL Server 2005 Exams are corresponding/similar to 70-450?

Thread by: pcsql, Aug 26, 2008, 2 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

I want to take some practice tests for 70-450. I don't think there is any yet. Which SQL Server 2005 Exams I should take as practice tests for...

What permssions/roles to be assigned to a database user who is in charge of jobs?

Thread by: pcsql, Aug 21, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

I want to assign permissions/roles to a login who is in charge of creating, maintaining, and executing jobs. The login is the dbo of a database on...

SQL Server 2008 new data types and Entity Framework

Thread by: pcsql, Jun 16, 2008, 1 replies, in forum: SQL Server 2008 Questions [Archive Only - Closed]

Does anyone have a list of SQL Server 2008 new data types that will not be supported by Entity Framework?

What are the pros and cons in using SQL Server 2005/2008 Reporting Service vs using Crystal Report?

Thread by: pcsql, May 20, 2008, 4 replies, in forum: SQL Server 2005 Reporting Services

Is there any comparison article between SQL Server 2005/2008 Reporting Service and Crystal Report for .net application?

Does replication add a column to each table automatically?

Thread by: pcsql, May 7, 2008, 2 replies, in forum: SQL Server 2005 Replication

I don't know enough about replication. Someone mentions to me that replication (may be in SQL Server 2000 and/or SQL Server 2005) will add a column...

What settings can affect an idle connection?

Thread by: pcsql, May 1, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

If an application on a windows workstation has connected to SQL Server 2005 or SQL Server 2005 Express using ODBC with tcp/ip and there is no...

How to change a sql server instance not to check password policy?

Thread by: pcsql, Apr 29, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

I'm getting the following problem: Property IsLocked is not available for Login '[x]'. This property may not exist for this object, or may not be...

What is the relationship between .NET Framework Data Provider for SQL Server and Sql Native Client?

Thread by: pcsql, Jan 24, 2008, 3 replies, in forum: SQL Server 2005 General Developer Questions

I'm using .NET Framework Data Provider for SQL Server. I'm reading this...

What is the difference between Exception event and User Error Message event in Profiler?

Thread by: pcsql, Jan 17, 2008, 3 replies, in forum: SQL Server 2005 General Developer Questions

I'm trying to catch error in a .net application but the exception caught in .Net is actually the User Error Message. Should I just use the Error #...

How to interpret this trace?

Thread by: pcsql, Jan 15, 2008, 8 replies, in forum: SQL Server 2005 General DBA Questions

I'm tracing the Connect to Server dialog in SSMS when I entered the correct SQL Server login and password but wrong default database (a database...

Which folders need to be accessible by a domain user so that user can start SQL Server service?

Thread by: pcsql, Jan 15, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

I'm trying to start sql server service using a regular domain user account and get the error "Access is denied". I kind of remember that it is...

How to find out the actual role/user accessing a database?

Thread by: pcsql, Jan 15, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

After I added a sql server login, that login can use the following system databases: master, msdb, tempdb My understanding is that login is actually...