Server Configuration

default directory change for full text search
Hi Would like to know how i can change the default directory for full text search. Does anyone know how to do this in SQL Server 2008? Regards, Rikard ... 10 Jun 2010 07:48

Am I UNICODE ?
Hi, On my SQL Server 2008 my collation is SQL_Latin1_CP1_CI_AS am I unicode ? Thanks in advance ... 13 Jun 2010 05:05

how to replace in sql
Hi, let output string will be, str="01/Mar/2010,02/Mar/2010,03/Mar/2010,04/Mar/2010,05/Mar/2010" Some manipulation Resultant string should be, "01/Mar/2010,02/Mar/2010<br/>03/Mar/2010,04/Mar/2010<br/>05/Mar/2010" Here I want to replace Comma (,) by <br/> Note: I want to replace even commas only.... 10 Jun 2010 16:49

SQL05 Cluster: Striped tempdb reverting to original non-striped?
My environment is: SQL 2005 64-bit two-node Cluster operating in a 64-bit environment (Windows Server 2003 64-bit SP2) on an iSCSI SAN. We have been successfully running for a long time (over a year) with a striped tempdb (4 physical files - 4 physical CPUs). The stripes were created as 4 12288 GB files when ... 9 Jun 2010 15:21

Why there are so many connections?
In my asp.net app, I use ado.net and store procedures. Last night about 10 pm, I ran app and then ran sp_who2. I found that there are so many SPID were generate. Is it some problem in my app? Status:sleeping login: sa hostname: intranet1 dbname: live command:AWAITING COMMAND programname: .Net SqlClient Data P... 10 Jun 2010 16:49

ANN: Database Workbench 4.0.2 released - including Free Lite Editions
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0.2 Pro " Version 4 introduced full Unicode support, 4.0.2 fixes some issues found in that initial release, like ODBC connectivity issues, BLOBs taking too much mem... 9 Jun 2010 08:38

MSDTC - SQL server 2008 - Windows Server 2008 R2 Standard
Hi, I have a db in SQL2005, on a Windows Server 2003 R2 (SP2), wich uses MSDTC perfectly. Now, we moved the same db to SQL2008 on a Windows Server 2008 R2 Standard, and configured MSDTC just like on the other machine, and isn´t working. Is there any issue with this OS or SQL version? Any ideas? Thks ... 9 Jun 2010 08:38

SQL Server Agent Account
Hello, I would like to get the name of the SQL Server Agent Account by a (SQL) - Query, or, to ask otherwise, if a given login comes from the SQL Server Agent. Thank You Joachim ... 9 Jun 2010 07:32

Stored Procedure details in one query
Hi all, can anyone help in getting below information from all stored procedure from one DB we have 100 procedure in one DB of sql server 2005.instead if of manully getting info for each procedure i want all below details in one shot or one query Procedure Name : Input Parameter : Output Parameter ... 9 Jun 2010 04:17

Maintenance plan Error in Sql management studio
In the Microsoft sql server management studio when I am trying to plan for maintenance task i am getting following error "cannot show editor for this task. Absolute path information is required. (mscorlib).". Please help me in resolving this issue. I have MSSQL 2005 with SP2 installed and .net framework3.5. ... 22 Jun 2010 08:17