Need to add additional NIC to SQL cluster - to enable teaming.

Hi
I have 2 questions, but related!
We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node
cluster.
Each node currently has 2 NICs installed, one NIC for the local heartbeat
and the other for the LAN connection.
We now need to add another NIC to each cluster node for failover resillience
on the LAN connection.
The idea is to add the extra NIC, so that we can implement teaming on 2
NICs.
1.What needs to be done to the cluster in order to achieve this and ensure
that the cluster still functions as per normal.
2. The installed NIC has 2 ports, so i assume that additional NIC purchased
may be different, my guess is that teaming different type NIC cards is not a
good idea, therefore i would like to reconfigure for the teaming to be on
the NIC with the 2 ports and the heartbeat on the newly purchased NIC. - Is
this a big job- what needs to be carried out in order to achive this!!!
Cheers Ray
Answers below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
<Ray> wrote in message news:eWEmvKBGFHA.2932@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have 2 questions, but related!
> We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2
> node
> cluster.
> Each node currently has 2 NICs installed, one NIC for the local heartbeat
> and the other for the LAN connection.
> We now need to add another NIC to each cluster node for failover
> resillience
> on the LAN connection.
> The idea is to add the extra NIC, so that we can implement teaming on 2
> NICs.
> 1.What needs to be done to the cluster in order to achieve this and ensure
> that the cluster still functions as per normal.
A properly configured TEAM is not seen by the cluster. In other words, its
seamless. It just works like a single NIC and the Cluster is never the wiser
Cool huh?

> 2. The installed NIC has 2 ports, so i assume that additional NIC
> purchased
> may be different, my guess is that teaming different type NIC cards is not
> a
> good idea, therefore i would like to reconfigure for the teaming to be on
> the NIC with the 2 ports and the heartbeat on the newly purchased NIC. -
> Is
> this a big job- what needs to be carried out in order to achive this!!!
>
Take everything offline - cluster services and all resources. Change the
IP's on the NIC - on each node. Do a few ping tests to verify things are
working. Start the cluster service and use "." to start the Cluster
Administrator.
Use these for information:
http://support.microsoft.com/default...b;en-us;244980
http://support.microsoft.com/default...b;en-us;230356
Good luck, its really not that bad.

> Cheers Ray

Need table of words/glossary/etc.

Hi!

I have a client who wants to have a function to have a system create a validation system for users who register for a system. It would email them a registration code, which they want to be two or three random words strewn together.

So, I'm looking for a big table of words - random, glossary terms, etc. Does anyone have anything like this? (A flat file that I can import would be fine.)

Thanks!I have a dictionary of words in an access db,... by why would you do this, why not generate some random sequence based on something like the data/time they subscribed??|||I have a dictionary of words in an access db,... by why would you do this, why not generate some random sequence based on something like the data/time they subscribed??

Because that would be logical and clients don't operate on logic :)

(They're afraid that random words would be too difficult for the users of the system, most of which are senior citizens.)|||A smart person would suggest sending them a validation link in the email that they can click and autovalidates... but there you go. ;)

So do you want this db? I think it is about 4 megs but I can't be sure...|||This is completely out of my hands. I've made my arguments and I've been shot down. Other people have offered alternatives, they've shot them down too. So, this is what I have to go with.

If you could provide the table, that'd be great.

Thanks!|||how do you want it? http download from somewhere? I can upload it in the next few hours (once I get home).|||Either post it somewhere or email it to rflagg@.gmail.com

Thanks!|||should be in your gmail|||Thanks! That table is great (and very extensive). Much appreciated!|||...sounds like a "lazy hacker" looking for a quick and dirty dictionary attack...maybe wrong though ;)|||And I just helped him,.. great,... ah well, if that is the case then people should protect themselves against such attacks anyway...|||I'm in a similar situation. Could you possible send me a copy of the db ?

[My Email] (laasunde@.online.no)

Thank you.|||Any way you can prove to me that it's not for dictionary attacks?|||Don't know how I could prove that over the Internet.

Need the db for an assignment at uni..|||I promise you that's not what it's for. I'm a professional, I do ASP.NET and SQL development for a living as full-time work, as contracts on the side, and I maintain two websites that I wrote myself for two non-profit animal rescue groups dedicated to the saving and placement of homeless and stray animals. One of which is Animal Allies (http://www.animalallies.com) which services the Washington D.C. metro area (where I live). If you'd like more evidence of this, you can email me at tarkon@.animalallies.com and I'll respond.

Besides that, there's very little I can do to assure you this is for honest and legitimate purposes other than my personal guarantee (and the fact that I don't even know what a dictionary attack is).

And lastly, it's been my experience most hackers are Linux people and not SQL Server 2000 developers.|||heheh no worries Tarkon, I wasn't that concerned to be honest,... just messing with your head. ;)sql

Need syntax help in join from two DB

Hi

I have two databases on my server, I need a simple query with one join between one table from each database.
I looked in the help of FROM clause and found the Argument "table_source" where it explains this :
"If the table or view exists in another database on the same computer running Microsoft SQL Server, use a fully qualified name in the form database.owner.object_name".

Can someone please help me fill the variants ??
My DB name is "Forum" the owner is "DBRND\Administrator" and the table name is "TblUsers", so I tried to write in the FROM clause :
"FROM Forum.DBRND\Administrator.TblUsers" but it doesn't work... so anyone have any idea how should it be ?

Thanks,

Inon.select a.col, b.col
from db1..table1 a, db2..table2 b
where a.colX = b.colX
etc...|||Your object owner is DBRND\Administrator?

Look at the list of tables in Enterprise Manager. They are most likely owned by dbo:

select * FROM Forum.dbo.TblUsers

AND PLEASE DON'T LINK TABLES IN THE WHERE CLAUSE! (My pet peeve...)

select a.col, b.col
from db1..table1 a
inner join db2..table2 b on a.colX = b.colX

Code like a pro!|||(My pet peeve...)Oh, oh! I had a peeve once! Everybody kept feeding it, until it almost ate me.

I've gotten a wee bit jaded since then, but I suspect that you'd noticed.

-PatP|||Thanks A LOT!

Sorry about pushing this thread up... :)

BTW, is joining from two databases on the same server is recommended ? Because I have an option to combine the two databases, so how bad is it (if at all) to leave it like it is.

Inon.

Need some reading material.

Hi

I was searching some books about SQL but all that i found was "Big books", i mean, i found books about all SQL Server and i just need to know a few things.

I'll need to make queries to a DB and make excel or acces reports based on the query result.

Well, thanks in advance

Querying Microsoft SQL Server 2000 with Transact-SQL will give you the basics of making the queries to the database. Microsoft printed it. Just use the help in access or excel to find out how to connect to the server to do your query.

Need some knowledge about indexes

Hi
I need to get my knowledge about indexes expanded a little bit...
What's the best/easiest way to view Indexes and their definition in SQL
server. I can look in sysindexes, but as I see it it only shows me the
different indexes by name, but not so much about the definition etc. (or
maybe I just don't know what to look for). I can also use sp_helpindex, but
that only shows me very little as well. I know I can look up the difinition
in EM, but that's a bit cumbersome to click through all tables to see it.
Reason for asking is that I have 2 almost identical databases, where on one
of them there's a number of indexes defined. These Indexes I'd like to
create in the second database as well.
Best Regards
Steen PerssonSteen
Run this script in QA on source database .
SELECT s1.name, s2.name,
INDEX_COL( s1.name, s2.indid, 1 ),
CASE INDEXPROPERTY( s1.id, s2.name, 'IsClustered' )
WHEN 1 THEN 'Clustered'
ELSE 'Non-clustered'
END
FROM sysobjects s1
INNER JOIN sysindexes s2
ON s1.id = s2.id
WHERE s1.xtype = 'U'
AND s2.indid > 0 AND s2.indid < 255
AND s2.name not like '_WA_Sys%'
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...
> Hi
> I need to get my knowledge about indexes expanded a little bit...
> What's the best/easiest way to view Indexes and their definition in SQL
> server. I can look in sysindexes, but as I see it it only shows me the
> different indexes by name, but not so much about the definition etc. (or
> maybe I just don't know what to look for). I can also use sp_helpindex,
but
> that only shows me very little as well. I know I can look up the
difinition
> in EM, but that's a bit cumbersome to click through all tables to see it.
> Reason for asking is that I have 2 almost identical databases, where on
one
> of them there's a number of indexes defined. These Indexes I'd like to
> create in the second database as well.
> Best Regards
> Steen Persson
>|||Hi,
You could join the below system tables to get all the details of Indexes:-
sysindexes (name and indid columns)
sysindexkeys (object_id,colid)
syscolumns (colid,name)
Note:-
Querying the system tables might not be a good option... But for your query
I could see only this solution
Thanks
Hari
MCDBA
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...
> Hi
> I need to get my knowledge about indexes expanded a little bit...
> What's the best/easiest way to view Indexes and their definition in SQL
> server. I can look in sysindexes, but as I see it it only shows me the
> different indexes by name, but not so much about the definition etc. (or
> maybe I just don't know what to look for). I can also use sp_helpindex,
but
> that only shows me very little as well. I know I can look up the
difinition
> in EM, but that's a bit cumbersome to click through all tables to see it.
> Reason for asking is that I have 2 almost identical databases, where on
one
> of them there's a number of indexes defined. These Indexes I'd like to
> create in the second database as well.
> Best Regards
> Steen Persson
>|||Great...that helps a lot...
Regards
Steen
Uri Dimant wrote:[vbcol=seagreen]
> Steen
> Run this script in QA on source database .
> SELECT s1.name, s2.name,
> INDEX_COL( s1.name, s2.indid, 1 ),
> CASE INDEXPROPERTY( s1.id, s2.name, 'IsClustered' )
> WHEN 1 THEN 'Clustered'
> ELSE 'Non-clustered'
> END
> FROM sysobjects s1
> INNER JOIN sysindexes s2
> ON s1.id = s2.id
> WHERE s1.xtype = 'U'
> AND s2.indid > 0 AND s2.indid < 255
> AND s2.name not like '_WA_Sys%'
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...

Need some knowledge about indexes

Hi
I need to get my knowledge about indexes expanded a little bit...
What's the best/easiest way to view Indexes and their definition in SQL
server. I can look in sysindexes, but as I see it it only shows me the
different indexes by name, but not so much about the definition etc. (or
maybe I just don't know what to look for). I can also use sp_helpindex, but
that only shows me very little as well. I know I can look up the difinition
in EM, but that's a bit cumbersome to click through all tables to see it.
Reason for asking is that I have 2 almost identical databases, where on one
of them there's a number of indexes defined. These Indexes I'd like to
create in the second database as well.
Best Regards
Steen Persson
Steen
Run this script in QA on source database .
SELECT s1.name, s2.name,
INDEX_COL( s1.name, s2.indid, 1 ),
CASE INDEXPROPERTY( s1.id, s2.name, 'IsClustered' )
WHEN 1 THEN 'Clustered'
ELSE 'Non-clustered'
END
FROM sysobjects s1
INNER JOIN sysindexes s2
ON s1.id = s2.id
WHERE s1.xtype = 'U'
AND s2.indid > 0 AND s2.indid < 255
AND s2.name not like '_WA_Sys%'
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...
> Hi
> I need to get my knowledge about indexes expanded a little bit...
> What's the best/easiest way to view Indexes and their definition in SQL
> server. I can look in sysindexes, but as I see it it only shows me the
> different indexes by name, but not so much about the definition etc. (or
> maybe I just don't know what to look for). I can also use sp_helpindex,
but
> that only shows me very little as well. I know I can look up the
difinition
> in EM, but that's a bit cumbersome to click through all tables to see it.
> Reason for asking is that I have 2 almost identical databases, where on
one
> of them there's a number of indexes defined. These Indexes I'd like to
> create in the second database as well.
> Best Regards
> Steen Persson
>
|||Hi,
You could join the below system tables to get all the details of Indexes:-
sysindexes (name and indid columns)
sysindexkeys (object_id,colid)
syscolumns (colid,name)
Note:-
Querying the system tables might not be a good option... But for your query
I could see only this solution
Thanks
Hari
MCDBA
"Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...
> Hi
> I need to get my knowledge about indexes expanded a little bit...
> What's the best/easiest way to view Indexes and their definition in SQL
> server. I can look in sysindexes, but as I see it it only shows me the
> different indexes by name, but not so much about the definition etc. (or
> maybe I just don't know what to look for). I can also use sp_helpindex,
but
> that only shows me very little as well. I know I can look up the
difinition
> in EM, but that's a bit cumbersome to click through all tables to see it.
> Reason for asking is that I have 2 almost identical databases, where on
one
> of them there's a number of indexes defined. These Indexes I'd like to
> create in the second database as well.
> Best Regards
> Steen Persson
>
|||Great...that helps a lot...
Regards
Steen
Uri Dimant wrote:[vbcol=seagreen]
> Steen
> Run this script in QA on source database .
> SELECT s1.name, s2.name,
> INDEX_COL( s1.name, s2.indid, 1 ),
> CASE INDEXPROPERTY( s1.id, s2.name, 'IsClustered' )
> WHEN 1 THEN 'Clustered'
> ELSE 'Non-clustered'
> END
> FROM sysobjects s1
> INNER JOIN sysindexes s2
> ON s1.id = s2.id
> WHERE s1.xtype = 'U'
> AND s2.indid > 0 AND s2.indid < 255
> AND s2.name not like '_WA_Sys%'
>
> "Steen Persson" <SPE@.REMOVEdatea.dk> wrote in message
> news:uqbvCcTeEHA.720@.TK2MSFTNGP11.phx.gbl...

Need JDBC Driver for MS SQL 7.00.847

Hi
I just downloaded the Microsoft JDBC Driver for SQL Server 2000. Now it tells me SQL Server 7 is not supported. :o I already checked the JDBC Driver list on suns site. Its quite long and only states MS SQL Server without any version number. Can you recommend a particular driver? Preferrably without any cost. :D
Or am I better of with the jdbc/odbc bridge?

Thanks

ShabassaWe have multiple MS Sql Servers. Some are version 2000 (8). Is it possible to connect to such a server via jdbc and access the server with ms sql 7 using this server as a gateway?

Need Information about Processing and Aggregations (Update / Referenced Dimensions / Many to Man

HI!

I am looking for some information about processing of complex big models with partitioning.

facts:

we need a lot of aggreations

have several dimension with 2 mio. members

have partitioned the cube and want to process only a few and not all partitions

want to process dimension by update (does not unporcess old partitions) or increment update

have some dimensions with references relationship to the partitions

may have linked measuregroups

questions:

update dimensions processing

does this unprocess a cube or partition?

we have the problem that our partitions get unprocessed?

maybe if its referenced by ohter dimension

or it is an parent child dimensions

are there any circumstances where an update dimension unprocess the cube?

how well are aggregations if we process update dimension

how well are aggregations if we process update referenced dimension

howto aggregate with a many to many measuregroup and update dimension

Links to any good documentation would be really interesting.

THANKS

HANNES

Some good material about AS2005 processing model: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp

First. In AS2005 you have 2 types of processing that update dimension.

One is ProcessUpdate and another one is ProcessAdd.

update dimensions processing|||

Hi Hannes,

Did you find what was the problem that your partitions become unprocessed?

I have the same problem, i'm doing processing to new partitions and the old ones become 'Unprocessed'

Thanks in advance.

|||

It was because this was a test environment and we changed metadata. Added some attributes. This always need to be a full process.

LG, HANNES

|||

thanks for your answer.

I'm doing Process Full to the partitions, and I have the problem above.

the source database was changed but my query that reads the data hasn't changed, means that i have new columns in the fact table and i haven't add it to my query, does it matter? , i didn't changed my measure group at all.

Do you have any suggestion?

Do I need to do ProcessFull to dimensions as well?

thanks.

|||

If you do a full process of a partition the processing state of a cube does not change

(if the cube was prcessed before if is processed after

if the cube was not processed before it is not processed after - als log as you process by the xmla commands!)

Hannes

Need Information about Processing and Aggregations (Update / Referenced Dimensions / Many to

HI!

I am looking for some information about processing of complex big models with partitioning.

facts:

we need a lot of aggreations

have several dimension with 2 mio. members

have partitioned the cube and want to process only a few and not all partitions

want to process dimension by update (does not unporcess old partitions) or increment update

have some dimensions with references relationship to the partitions

may have linked measuregroups

questions:

update dimensions processing

does this unprocess a cube or partition?

we have the problem that our partitions get unprocessed?

maybe if its referenced by ohter dimension

or it is an parent child dimensions

are there any circumstances where an update dimension unprocess the cube?

how well are aggregations if we process update dimension

how well are aggregations if we process update referenced dimension

howto aggregate with a many to many measuregroup and update dimension

Links to any good documentation would be really interesting.

THANKS

HANNES

Some good material about AS2005 processing model: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5_asprocarch.asp

First. In AS2005 you have 2 types of processing that update dimension.

One is ProcessUpdate and another one is ProcessAdd.

update dimensions processing|||

Hi Hannes,

Did you find what was the problem that your partitions become unprocessed?

I have the same problem, i'm doing processing to new partitions and the old ones become 'Unprocessed'

Thanks in advance.

|||

It was because this was a test environment and we changed metadata. Added some attributes. This always need to be a full process.

LG, HANNES

|||

thanks for your answer.

I'm doing Process Full to the partitions, and I have the problem above.

the source database was changed but my query that reads the data hasn't changed, means that i have new columns in the fact table and i haven't add it to my query, does it matter? , i didn't changed my measure group at all.

Do you have any suggestion?

Do I need to do ProcessFull to dimensions as well?

thanks.

|||

If you do a full process of a partition the processing state of a cube does not change

(if the cube was prcessed before if is processed after

if the cube was not processed before it is not processed after - als log as you process by the xmla commands!)

Hannes