The third way doesn't seem to be option to find out which of the port SQL Server is listening, since if you are already connected to the SQL server, then...

You are very right. Oledb Destination should be used for OLEDB connection.

Thanks

Avinash

But you said, sysobjects did have some trace of 'quot' table.

Can u post the results to this query?

select  * from sysobjects

where name='quot'

Hi Patrick,

Do you mean to say that the Tables were DROPped by SQL server anyhow? I never heard of such kind of problem. In not case the Table can...

Yes Donald, they do affect the @@rowcount variable. Say for example you have the following trigger on Table1 then you would only receive those Rowcount which may be result of...

I tried executing the below queries and found no problem from my side.

SET IDENTITY_iNSERT [dbo].[Table1] ON

INSERT [dbo].[Table1](Col1, Col2, Col3)

SELECT Col1, Col2, Col3 FROM [remotesrv].[remotedb].[dbo].[Table2]

SELECT @@ROWCOUNT as 'rowcount'

SET IDENTITY_INSERT [dbo].[Table1] OFF

And...

I dont think the issue with selection of Remoteserver data.

Since selection is from remote server. And that too is giving right @@rowcount value when only select was used.

What I...

While partition the Original Table, are we doing Normalization in the process of partitioning the Table.

Why is it termed as Partitioning, where you can describe this by the term Normalization itself.

Hello Herb!,

When ur boss attached a SQL 2k backup to a SQL 2K5 server it got upgraded in the process.

Now u have to set the DB Compatibility level to SQL...

Look Pattyn,

I have a scenaria where writes /read ratio is much higher as to the tune of 90/10.

I can't post the update query because it includes many...

Now what the hell is this fillfactor!

Somebody plz. explain me of this!

I tried disabling Boost Windows NT Fibers option but in vain! It aggravated the problem which i already had.

I think...

It seems you have got some sixth sense in knowing what others haven't said!

like you guessed what answer can be correct one.

Where is the Query mentioned in the Question? I don't know how to answer this question without having a look at the query it talks about.

Its bad!

Where is the Query mentioned in the Question? I don't know how to answer this question without having a look at the query it talks about.

Its bad!