Using MS SQL Server

setting up witness on SQL SERVER Express
I am trying to set up mirroring between two SQL SERVER 2005 servers using a third SQL SERVER Express as a witness. However SQL SERVER Express does not seem to work as a witness. I have set up the endpoints, logins and permissions. When the principal tries to connect to the witness I get the following error message ... 31 Oct 2006 09:41

SQL 2005 - Export table to a fixed width file.
I want to export a table into a "fixed width" file using SQL 2005 import export wizard. This is the version I have: SQL Server 2005 - 9.00.2047.00 For some reason it joins all the rows together. For EX: if the table is like this: Create table Mytable (col1 varchar(50) null, col2 varchar(60) null, col3 var... 31 Oct 2006 08:38

DBCC Memory Status and Query Plan
When I executed DBCC Memory Status following are the out put Buffer Distribution Stolen 187191 Free 1026 Procedures 6698 Inram 0 Dirty 154661 Kept 0 I/O 0 Latched 772 Other 436084 Buffer Counts Committed 786432 Target 786432 Hashed 591517 Internal Reservation 510 External Reservation 2291 Min ... 26 Oct 2006 20:30

No Local instance with SQLServer2005 Dev. Ed.
(New to SQL Server Installs) I installed SQL Server 2005 Developer Edition on a WinXP-SP2 workstation and can see some enterprise databases on the network just fine. My problem is I cannot register a local database on the local drive for testing/education purposes. (I accepted all of the defaults on the insta... 10 Nov 2006 18:12

MSDTC?
I keep getting this error on my application server...what does it mean? The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of th... 16 Oct 2006 18:40

Trasactional Replication Times Out...! - Help!!!!
I have a transactional replication working fine till to date. I have the publisher on ServerA and subscriber on ServerB. The transactional replication is running fine... I need to get a copy of the subscriber to another server and replicate the Publisher to that serverC while the replication on ServerB is runnin... 3 Oct 2006 17:59

Snap-in creation failed
Hello I have SQL Server 2000 on my laptop. I installed VS 2005. Now when I go into Enterprise Manager for SQL 2000 I get an error message Snap-in failed to initialize;Name <unknown>;CLSID {a bunch of numbers}. When I click ok, it loads Enterprise Manager with a message Snap-in Creation Failed. Thanks Sali... 29 Sep 2006 14:38

Install Problem
I am trying to install SQL2000 on a Dell Server running Windows 2003SP1. I get the following message: Setup Initialization Error Error Performing Inpage Operation Source:E\x86\Setup\..\upgrade\res\1033\cldtsctp.rll Target:C:\Docume~\Admini~\Locals~\Temp\Sqlsetup\Bin\cldtcstp.rll It will not allow me to get ... 26 Sep 2006 14:53

DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'
When I want to delete a data from a table that this tabl has a trigger and this trigger reached another tables to delete the data in cursor I have this messeage: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. My trigger : CREATE TRIGGER [TOPBASICIKISSILME] ON [db... 11 Oct 2006 02:11

SQL server connection
Hi All, I was able to connect to MS SQL Server 2005 on my computer but after a while I can not. When I want to connect to it using MS SQL Server Management Studio I got this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cause... 22 Sep 2006 13:51