Server Configuration

SQL2000 Max datafile size & placement for performance
Hi environment sqlserver 2000 SP4 enterprise SAN -Virtual Array storage I have a database which has 3 datafiles under one filegroup(not on primary) and one log file. two of those data file size is around 30GB each and one data file i am using for nonclusterd indexes which is 20GB. everything on the san sam... 8 Jul 2008 00:50

Transation Logs in a default location
Is it possible we set a default location ONLY for all log files of user databases? Thanks, Felipe ... 8 Jul 2008 02:52

2005 Maintenance Task
I am creating new maintenance tasks for my 2005 server as we migrate from 2000. In the "Maintenance Cleanup Task" the option "Search folder and delete files based on an extension" doesn't appear to go through sub-folders. Since I selected the option to create sub-folders for each db in the backup option I do... 7 Jul 2008 18:41

Unable to start T-SQL Debugging. Could not attach to SQL Server pr
"JeffRoughgarden" wrote: We have several developers who need to develop and debug stored procedures on a common development SQL Server 2005 box. Everyone runs Visual Studio 2005 on their local machine. Since QA is no longer available for T-SQL debugging, everyone must use VS05 for this purpose. Eve... 7 Jul 2008 17:40

Master and master_log in different drives
Is it a good practice separate master.mdf and master_log.ldf in different drives? If yes, how? Thanks, Felipe ... 8 Jul 2008 01:51

Help with Performance Issues / Application Event Log filled with S
Hi all Win2k3 2-Node Active/Passive config cluster SP2 Win2k3 and SQL2005 SP2 2 small questions 1) SQL is writing events into the Application Log. I am not too sure how to turn this off. I thought it was from the PROPERTIES of the Server itself, then goto SECURITY and turn off "Login auditing". trouble is, I ... 7 Jul 2008 13:32

How can i determine that sql server 2005 express is installed in a system?
Hi! How to check that SQL Server 2005 Express is installed in a system? I want to create a small program that will create or modify a specific database for my software. How do i check for the existance of the sql server? Then prompt the user if he wants to set up sql server express? Thanks! ... 8 Jul 2008 03:53

Debug without sysadmin rights?
Is it possible to debug without sysadmin rights? We would like to grant this privlidge to certain users, but we don't want to give them sysadmin rights - is this possible? ... 7 Jul 2008 12:30

Any risks to change Local System to a domain account ?
Hi All, We have a sql server serving for BizTalk in our staging environment running under "Local System" account. To make the account privilege identical to production environment, I'd like to change it to a domain account. I wonder if there'd be any risks for doing that. Please advise. Linda ... 7 Jul 2008 17:40

Cannot pull symbols for SQL 2005
I am trying to debug a SQL 2005 dump file - I have the correct public symbol path (it gets the kernel symbols, etc.) but for some reason it cannot find the SQL symbols - what am I doing wrong here? 0:075> !sym noisy noisy mode - symbol prompts on 0:075> .reload .. DBGHELP: c:\symbols\ntdll.dll\45D70AD8c0000\nt... 7 Jul 2008 13:32