I'm trying to build a new cluster with SQL Server 2K Enterprise on
Windows 2003 server. When I run the install, I tell it to put the
program files on the D: (local) drive and the data/log files on shared
drives. However, after the installation is complete, almost all the

when i install the SQL server 2005, it occured the follow message:
Product: Microsoft SQL Server 2005 CTP -- Error 29628. The setup has
encountered an unexpected error in datastore. The action is
PrepareUpgradeDialog. The error is :Failed to find property "langId"

I have a sproc with 5 params that takes about 40 seconds to return.
But when I Create a Temp table and do a
Insert Into #temp
Exec sproc param1, param2, param3, param4, param5

We are trying to move data from a product called TABLEBase that runs on
the mainframe and we are experiencing problems trying to BCP the data
into SQL Server.  The SQL server we are tying to BCP into is SQL 2000.
We are using BCP from a command prompt.

I'm currently trying to establish a linked server to an Oracle
database.
Setup:
Connecting to 8x version of Oracle

How can I port, or can I port, a MSDE database from one standalone computer
to a second standalone computer?
Charles

I just inherited a Java application with a fairly complex data model
that does not yet have any indexes except those on primary keys. It is
still in development and before I get to do any performance testing I
want to put some default indexes on it. I realize that this a very

Can someone make a recommendation for backup software which will backup SQL
7 and it's databases running on a Windows Professional 2000 PC?
My customer has a Honeywell app which won't run on SQL 2000 which is why
we're running it on SQL 7 and Win2K Pro.

What query shoul I send to SQL serwer ( in transact SQL language ) to check
does some database exist on serwer ? It similar to problem "does some table
exist in database" - resolve to it is query:
use db_silnik

I have Access Font End to SQL server Back end.
In an Access form, I use combobox, based on a stored procedure, which based
on 1 table (SELECT LocationID, LocationDescription FROM Locations).
When I open the form and check in the SQL server Enterprise Manager, go to

Complete newbie to sql server. I have a Companies table from which I would
like to create a Clients view as follows;
SELECT     ID, Company, CompanyType
FROM         dbo.Companies

Complete newbie to sql server. I have a Companies table from which I would
like to create a Clients view as follows;
SELECT     ID, Company, CompanyType
FROM         dbo.Companies

I am new to sql server and have an access background. My question is
regarding views; If I create a view from two tables linked together on two
fields, is it possible that the view can have records inserted, edited and
deleted?

I am hoping to create an updatable view from two tables joined on two
fields. I have two questions;
1. How can I enforce a one to one relation in sql server 2005 based on two
fields? Do I need to create one explicitly under relations? Do I cerate an

Quick question, I have an application with ASP/VB and MS SQL. (Use
Dreamweaver).
My query has a Where clause that uses the IN (), inside the parenthesis I
have integer numbers, something like: