I have two tables whose structure are as follows:
TableA
tblA_ID   tblA_Name   tblA_Cost
1            Name1        10

Hi friends
Is there any DMV(or anything but UI) I can query to see port number a sql
server instance is
currently using?

This database is on an acitve/passive cluster and is the mirrored principal.
The data file is 96 GB & log file is 22 GB as shown by Windows Explorer.  
Database Properties show Data File = 94014 MB Initial Size, 10% Unrestricted
Autogrowth; Log File = 21625 MB Initial, 20% ...

Hi.. I'm   trying to set up AWE in a Server with 8 GB of RAM, Windows 2003
Enterprise and SQL 2005 Standard
my Boot.ini is like this:
[boot loader]

      We are running SQL Server 2000 SP4 with 2040 patch. We have got the
following error twice in two days. It gives a different "file ID" every time.
I have run the checkdb on tempdb and didn't get any issues there. Tempdb
doesn't even have the file with ID 11. The server has ...

Hi support,
We have faced a problem when we migrate our database from SQL Server 7.0
Enterprise  to SQL Server 2005 Enterprise.  Currently our production database
is SQL 7.0 version and it was upgraped from SQL 6.5 version.  Some of the

I'm in situation I need to mask data for testing purpose and table do not
have primary key to cursor for mask it . For example student table below I
need to mask. I'm looking for logic to mask as below
OPEN c_table

Our environment is getting bigger and bigger. We have almost 45 SQL Servers
running and its a high availability cluster servers. We need to monitor all
jobs, services etc.
Is there any third party monitoring tool that can monitor all services and

I have a restore that I'm sure is hung on sql 2000. I started it from the GUI
but lost the dialog box somewhow. Under the Databases Folder it shows the
database as greyed out with the words loading\suspect.
I just want to stop it but can't bring down SQL Server

I would like to update my tables in the local SQL 2005 server with the data
from the tables from an SQL database on the internet.
I used to do this with Data transformation services, but this seems not be
running in SQL2005.

I somewhat new at writing queries in SQL server management studio
express.  I am trying to design a query using the query designer.
The problem I am having is that I am not good at setting up filters
for periods of time.

Is this possible to read and write to remote directory.
In order to access the directory i need to pass user name and
password.
At the moment i use BULK INSERT and bcp to import export files.

Gurus,
Looking for a script which can do an unattended installation of SQL Server
2005.

Since SQL Server 2005 standrad edtion only support 4 CPU's, does that mean it
will only use 1 x quad core processor?
If I have 2 x quad cores can't is use all 8 cores?

I have SqlServer 2000 running on a laptop for development. I now have
a new laptop, have installed SqlServer 2000 on it and I want to
transfer over my data. Both are on my in-home network, but using
Enterprise Manager, I can't register them so that they see each other.