I have Windows 2003 Server and installed SQL Server 2000 Sp 4 behind the firewall. I open the Portal 3389 TCP, 1433 TCP, 1434 UPD. when I try to connect SQL Server from my local box it says SQL Server doesn't exists or access denied. when I run the following query in my local box. telnet...more >>

In the query analyzer when I run the command create database TestingDb I can see the messages The CREATE DATABASE process is allocating 0.63 MB on disk 'TestingDb'. The CREATE DATABASE process is allocating 0.49 MB on disk 'TestingDb_log'. I want to hide the message, how can I do that? ...more >>

Hi, I'm trying to connect to AS2000 using AdoMd.Net 9.0 and I get the following error: {"Retrieving the COM class factory for component with CLSID {B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error: 80040154."} Trying to connect using AdoMd.Net 8.0 (same code, sa...more >>

Hi Can anyone point me in the right direction here, I would like to open a table in access 2003 by date. I have an asp web page which needs to read data from a table with each days today's date (which ever day that is) then a new table is created with today's date. Example: I have a table c...more >>

I would really appreciate if any one let me know the Best Tool for SQL Server Performance, Data Structure Validations and which Microsoft also recommended. Thanks in advance ...more >>

Hi, We have a serie of objects stored in the database as xml (ex: MyClass is stored in the table MyClasses in the field XML_MyClassObj which contains the an instance of the class serialized to XML). We did that because it was easier to serialize everything and send it as XML than to build a 2...more >>

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each time I attempt to I get the error message: "Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ ...more >>

I need to do a complete reistall of XP on my laptop, I have 2000 and 2005 Developer editions installed side by side. I'd like to backup my registered server and alias info for Managemenet Studio, I can't find where it keeps it. Enterprise Manager stores registered servers in HKLM\user_id\So...more >>

I have migrate SQL Server 2000 database into SQL Server 2005 and in all the stored procedures I am using SET BEGIN TRANSACTION but SQL Server 2005 support BEGIN TRANSACTION, is there any way i can resolve this issues, I have 150 stored procedures where I am using SET BEGIN TRANSACTION Than...more >>

Hi, Does any one have any experience with the Hibernate layer [which acts as an abstraction layer between DB & application layers]? The factor which is bothering me is the absence of stored procedures. All transactions are done via this Hibernate. What I am looking at is a system which does...more >>

Hi, Where could I find the explanation how to use User, login role, schema objects for SQL Server 2005? The resource I found mostly explain how to create the schema,... but don't explain how to use these objects effectivelly all together. Thanks, Lubomir...more >>

In SQL Server 2000 the following works but in 2005 it gave me an error. Msg 8115, Level 16, State 1, Line 1 Arithmetic overflow error converting numeric to data type numeric. Thanks ...more >>

Kill 142, I was trying to kill one of the session and found the following error. SPID 142: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds. when I use : dbcc opentran, it gave me following result Oldest active transaction: SP...more >>

When I run the following query in SQL Server 2000, it works fine but when I run into SQL Server 20005, it gave me following error. Msg 8115, Level 16, State 7, Line 1 Arithmetic overflow error converting numeric to data type numeric. Any idea, how can I resolve it, I migrate my database i...more >>

Hi, Is there any way how to formulate SQL query to select all columns except column D and E? So if the table has the columns A,B,C,D the result woud contain only columns A,B,C SELECT " * except D,E" FROM myTable Thanks, Lubomir...more >>

Quick question, I am backing up SQL Server Database every night, I want to encrypt the database backup file? Is there any way through scheduler I can take the backup as well as encrypt it. Thanks Noor ...more >>

Hi, I am new to SQL Server2005. I have installed it on a computer running Windows 2003 Server as WORKGROUP. I have another computer running WindowsXP. How can I connect to SQL Server2005 from WindowsXP? Do I have to install it on WindowsXP machine also? Thanks, Dave...more >>

I have just moved a database from Access to SQL server 2005 and added three (automatically indexed) full-text indexes. This works fine through my vb6-ado program and users are happy because searches are reduced by factors. Except the first user in the morning. The VB6 program has to handle a...more >>