On the Start menu, point to Programs/Microsoft SQL Server , and then click Client Network Utility.

In the general TAB you will find Enabled and Disabled options. If Named Pipes is...

I have had this problem before and this is how I solved it I hope this will give you a little bit of help.

I had MDAC ver 2.8 and was...

I need some more info about your setup

What version and SP of SQL Server and what platform?

I think that you have a possible disk bottleneck.

Use Performance provider to chech PhysicalDisk counters for confirmation.

A pointer to look at (IMHO)

% Disk time - If...

You can use the following statement. You alter the table remove the constraint insert your data and alter the table to add constraint back...

ALTER TABLE

WITH NOCHECK

Declarative referential integrity.

Data-integrity rules that will enforce the relationships between tables and keep the database as consistent as possible

Full table scan can be select * from table OR

Ignoring indxes -- Which one is bugging you?

Hi,

Use SQL Profiler and trace TSQL and Stored Procedure events.

Then search the textdata column.

I hope this helps...

Depending on the size of the table u could

select column1,column2 into products where blah blah

create table Spacetemp (name nvarchar(255),

rows nvarchar(100),

reserved nvarchar(255),

data nvarchar(255),

index_size nvarchar(255),

unused nvarchar(255)

)

insert Spacetemp (name,rows,reserved,data,index_size,unused) exec sp_spaceused 'products'

select *...

Hi,

My 2 cents.. Does the Oracle table contain a numeric field? If so what is the precision? I can't remember the "cut off" precision that the provider can't handle. But...

Check books on line for....

DBCC CHECKIDENT

IDENT_INCR

@@IDENTITY

IDENTITY (Function)

IDENT_SEED

SET IDENTITY_INSERT

Try this.....

DECLARE @object int

DECLARE @hr int

DECLARE @property varchar(255)

DECLARE @return varchar(255)

DECLARE @src varchar(255), @desc varchar(255)

-- Create a SQLServer object.

SET NOCOUNT ON

-- First, create the object.

EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT

IF...

In T-SQL you have different join types... 

(INNER) JOIN

A join that displays only the rows that have a match in both joined tables.

OUTER JOIN - LEFT OUTER / RIGHT OUTER Joins

A...

Try this......

SELECT    mm.title, aa.[name]

FROM         movie mm INNER JOIN

                      casting cc ON mm.movieid = cc.movieid INNER JOIN

                      actor aa ON cc.actorid = aa.actorid

        and mm.movieid in(SELECT m.movieid

             FROM    movie m INNER...