Req: how to deploy a SQL Client Alias to multiple clients

Hi there,
I'm looking for a quick way to setup/deploy an SQL alias on multiple
clients?
Due to an hw upgrade, we are moving our cluster to a new server, and we need
to setup on multiple clients a new SQL Client Alias and an ODBC System DSN.
I found that Sql Client Alias configuration are stored in a registry key,
but I don't know if exporting the hive from the first client and importing
in the remaining other will be ok
Thanks in advance
---
Silvio Accomando
Torre Informatica Srl
---Use regedit to expot the registry key and then use regedit to apply it to
the client.
Rand
This posting is provided "as is" with no warranties and confers no rights.

REQ: Help needed with extracting SP_WHO data

I need to be able to break down sp_who and pull the count of the BLK
column when it's greater than 0.
any assistance is appreciated."BobMarley" <brianh*REMOVEFOREMAIL*@.conterra.com> wrote in message
news:17l9tvg0c7vkiid1g17oatrd1ch0vio0c5@.4ax.com...
> I need to be able to break down sp_who and pull the count of the BLK
> column when it's greater than 0.
> any assistance is appreciated.
>
CREATE TABLE #sp_who (
spid smallint NOT NULL ,
ecid smallint NOT NULL ,
status nchar (30) NOT NULL ,
loginame nchar (128) NOT NULL ,
hostname nchar (128) NOT NULL ,
blk char(5),
dbname nvarchar(128),
cmd nchar (16) NOT NULL)
insert into #sp_who exec sp_who
select * from #sp_who
where blk > 0
drop table #sp_who
--David|||select * from master..sysprocesses where blk > 0?
see
http://www.nigelrivett.net/sp_nrSpidByStatus.html
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Req help with data types/domains

Hi,

I have a data type called ModelElement_t, the type contains 2 attributes: name & visibility. name can be represented as a string, only visibility is to be represented as an adt visibilityKind

CREATE TYPE ModelElement_t AS (name varchar, visibility visibilityKind)

CREATE TYPE visibilityKind_t AS (??

visibilitykind can be of 5 possible settings:vk_public, vk_protected, vk_private, vk_package, & vk_notapplicable. the default setting is vk_public.

could anyone give me any suggestions how to represent this, in conformance with the relational model? Im wondering if an array may be appropriate (only im not sure how to do this) or use constraint settings. I'd be appreciative if someone could display the SQL code. Any suggestions welcome.

Thanks in advance,

FAC51 :)I believe the SQL approach would be like:
create domain visibilityKind_t varchar2(16)
constraint visibilityKind_chk check value in ('vk_public', 'vk_protected', 'vk_private', 'vk_package', 'vk_notapplicable');
I am less clear about the OO "create type" approach. This tends to vary from vendor to vendor. The way it works in Oracle, there can be no constraint on the TYPE itself, only on columns of the TYPE - i.e.:

CREATE TYPE visibilityKind_t AS OBJECT (kind VARCHAR2(16));

CREATE TYPE ModelElement_t AS OBJECT (name varchar, visibility visibilityKind);

CREATE TABLE x (id INT, ModelElement ModelElement_t,
CONSTRAINT visibilityKind_chk CHECK ModelElement.kind IN ('vk_public', 'vk_protected', 'vk_private', 'vk_package', 'vk_notapplicable')
);
... which is poor, in my opinion.|||hi andrew, thanks for your reply, it was quite a tricky one i put out, i have a much better understanding now, thanks!

I believe the SQL approach would be like:
create domain visibilityKind_t varchar2(16)
constraint visibilityKind_chk check value in ('vk_public', 'vk_protected', 'vk_private', 'vk_package', 'vk_notapplicable');
I am less clear about the OO "create type" approach. This tends to vary from vendor to vendor. The way it works in Oracle, there can be no constraint on the TYPE itself, only on columns of the TYPE - i.e.:

CREATE TYPE visibilityKind_t AS OBJECT (kind VARCHAR2(16));

CREATE TYPE ModelElement_t AS OBJECT (name varchar, visibility visibilityKind);

CREATE TABLE x (id INT, ModelElement ModelElement_t,
CONSTRAINT visibilityKind_chk CHECK ModelElement.kind IN ('vk_public', 'vk_protected', 'vk_private', 'vk_package', 'vk_notapplicable')
);
... which is poor, in my opinion.

Req code example of selecting MS sql MSDE database stored locally TIA sal

Hello,
I'm trying to find an example in vb.net of how I can have a user select a MS
SQL database stored locally
created using MSDE.
TIAStart with this:
http://www.microsoft.com/downloads/...&displaylang=en
<sal@.spp.net> wrote in message
news:KK5id.35893$Tq1.10254@.bignews1.bellsouth.net...
> Hello,
> I'm trying to find an example in vb.net of how I can have a user select a
MS SQL database stored locally
> created using MSDE.
> TIA
>
>

Req code example of selecting MS sql MSDE database stored locally TIA sal

Hello,
I'm trying to find an example in vb.net of how I can have a user select a MS SQL database stored locally
created using MSDE.
TIA
Start with this:
http://www.microsoft.com/downloads/d...displaylang=en
<sal@.spp.net> wrote in message
news:KK5id.35893$Tq1.10254@.bignews1.bellsouth.net. ..
> Hello,
> I'm trying to find an example in vb.net of how I can have a user select a
MS SQL database stored locally
> created using MSDE.
> TIA
>
>

Req code example of selecting MS sql MSDE database stored locally TIA sal

Hello,
I'm trying to find an example in vb.net of how I can have a user select a MS SQL database stored locally
created using MSDE.
TIAStart with this:
http://www.microsoft.com/downloads/details.aspx?familyid=08e3d5f8-033d-420b-a3b1-3074505c03f3&displaylang=en
<sal@.spp.net> wrote in message
news:KK5id.35893$Tq1.10254@.bignews1.bellsouth.net...
> Hello,
> I'm trying to find an example in vb.net of how I can have a user select a
MS SQL database stored locally
> created using MSDE.
> TIA
>
>