How can I retrieve Description and other column information?

Hi, all..
I want to know the query to retrieve Column information that we can see from table Design view of Enterprise manager, such as Column name, Pk or not, FK table, Data Type, Null or not, Description(Specially Descrition).

Is there any sp for this or any query for this?

Thank you all...type

sp_help tablename|||select * from INFORMATION_SCHEMA.TABLES
select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

See BOL for more information about schema.|||You can also use
INFORMATION_SCHEMA.columns
cheers
-ss|||I too would like to get at the Description and I tried all of the above but Description doesn't seem to be there. I looked at all the INFORMATION_SCHEMA views and found nothing. I checked the system tables for the DB in question and found nothing. Could the Description be something internal to EM that isn't available to clients?|||What do you mean by description?|||I assume the Column Description you can enter in EM when designing a table. It's the first item on the Columns tab.|||OK...I usually maitain my data dictionary separatley...

You need to look up

fn_listextendedproperty

Never really used it....|||I assume the Column Description you can enter in EM when designing a table. It's the first item on the Columns tab.

Check this table:

select * from sysproperties|||Yup... Works fine.

Thanks Brett..|||select * from sysproperties

Works as well but may take extra coding to figure out the id and smallid so the data for the correct column can be identified.

Thanks...|||It works!!! Assuming a Table name of 'KB' and a column named 'Title' this gets the description.

declare @.tbid integer
declare @.colid integer

Select @.tbid=id from sysobjects where xtype='u' and name='KB'
Select @.colid = colid from syscolumns Where id=@.tbid And name='Title'
select value from sysproperties where id=@.tbid and smallid=@.colid and name='MS_Description'

Thanks snail for the pointer to sysProperties.|||Thanks all..
I think we have to know sysproperties table joined with which table..|||Can't help with the JOIN. There are three tables here and I haven't figured out how to JOIN two yet! :)|||Now I am finishing ...
This works! the following three tables joined gives what I asked.
I hope this helps all...
Thank you all for considering

Use Northwind
SELECT sysobjects.name AS [Table], syscolumns.name AS [Column], sysproperties.[value] AS Description
FROM (sysobjects INNER JOIN syscolumns
ON syscolumns.id = sysobjects.id) LEFT JOIN sysproperties
ON sysproperties.smallid = syscolumns.colid AND
sysproperties.id = syscolumns.id
where sysobjects.name = 'Orders'

-- PS
sysobjects.name : table Name (WHERE sysobjects.xtype = 'U')
sysobjects.id : table ID
sysproperties.smallid : Column id
sysproperties.[value] : Description

You can add following
WHERE sysobjects.xtype = 'U' xtype='U' means only select Table object

How can i remove a server from enterprise manager

Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks Alfred
I found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!
|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard
|||try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
..vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred
|||man forgot attachment - bad day ..
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:%23bs6bC4jEHA.1356@.TK2MSFTNGP09.phx.gbl...
> (sorry fat fingers)
> try attached vbscript uses DMO to delete the server registration - rename
to
> .vbs and run on the server with registration u want to delete by using :
> CSCRIPT DELSQLRegistration.vbs SERVER
> where SERVER is the name of the server Registration you want to delete
> Note for it to no longer appear in Enterprise Manager , you need to
restart
> Enterprise Manager.
> Andy.
> "Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
> news:8d338431.0408310515.7ae1d9d6@.posting.google.c om...
>
begin 666 DelSQLRegistration.txt
M)R J*BH@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B<R J*BH-"B<@.=7-I;F<@.1$U/
M(%-C<FEP="!O=70@.<F]L;"!T:')O=6=H(%-E<G9E<G,@.4F5G:7-T97)E9"!I
M;B!%;G1E<G!R:7-E($UA;F%G97(@.#0HG(&%N9"!T<GD@.86YD(&1E;&5T90T*
M)R!0<F5S=6UE(%-!($%C8V5S<PT*)R!!;F1Y($)A;&P@.,S$O."\R,# T#0H-
M"D]P=&EO;B!%>'!L:6-I= T*( T*#0I$:6T@.;T%R9W,@.(" @.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.(" @.)R!!<F=U;65N=',-"D1I;2!7<VA3:&5L;" @.
M(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G(&9O<B!7:6YD;W=S(%-C<FEP
M=&EN9R!(;W-T#0I$:6T@.3&]C86Q397)V97).86UE(" @.(" @.(" @.(" @.(" @.
M(" @.(" @.)R!T:&4@.4V5R=F5R#0I$:6T@.3&]C86Q$0DYA;64@.(" @.(" @.(" @.
M(" @.(" @.(" @.(" @.(" @.)R!T:&4@.9&%T86)A<V4-"D1I;2!,;V-A;%-13%5S
M97).86UE(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!5<V5R($YA;64-"D1I
M;2!,;V-A;%-13%!A<W-W;W)D(" @.(" @.(" @.(" @.(" @.(" @.(" G(%-13"!0
M87-S=V]R9 T*#0HG($YE960@.4'5B;&EC($%R<F%Y(&)E8V%U<V4@.=&AE(%-U
M8B!T;R!E;G5M97)A=&4@.=&AE(%-E<G9E<G,@.9G)O;2!$34\@.:7,@.<F5C=7)S
M:79E+BX-"E!U8FQI8R!397)V97)!<G)A>2@.I#0I0=6)L:6,@.07)R87E0;W ,-
M"D%R<F%Y4&]S/3 -"@.T*#0IS970@.5W-H4VAE;&P@./2!#<F5A=&5/8FIE8W0@.
M*")7<V-R:7!T+E-H96QL(BD-"@.T*)R!087)A;65T97)S#0IS970@.;T%R9W,@.
M/2!7<V-R:7!T+D%R9W5M96YT<PT*#0HG(&-H96-K(&-O<G)E8W0@.;G5M8F5R
M(&]F(&%R9W,-"DEF("AO07)G<RY#;W5N=" \/B Q*2!4:&5N#0H)5W-C<FEP
M="Y%8VAO(")5<V%G92 Z(&-S8W)I<'0@.1&5L4U%,4F5G:7-T<F%T:6]N+G9B
M<R \4V5R=F5R/B(-"@.E7<V-R:7!T+D5C:&\@.(FDN92X@.(#H@.8W-C<FEP="!$
M96Q344Q296=I<W1R871I;VXN=F)S($]L9%-E<G9E<B(-"@.E7<V-R:7!T+E%U
M:70@.(" @.#0I%;'-E#0H)"4QO8V%L4V5R=F5R3F%M92 @.(" @.(" @.(#T@.;T%R
M9W,H,"D-"D5N9"!)9@.T*#0HG("HJ*B!-86EN(%-C<FEP=" J*BH-"D-A;&P@.
M1&5L4U%,4F5G:7-T<F%T:6]N*$QO8V%L4V5R=F5R3F%M92P@.3F]T:&EN9RD-
M"B<@.*BHJ($5N9"!-86EN("HJ*@.T*#0HG(%-U8B!T;R!%;G5M97)A=&4@.=&AR
M;W5G:"!296=I<W1E<F5D4V5R=F5R<R M(&YO=&4@.8F5C875S92!O9B!T:&4@.
M:&EE<F%C:&%C86P@.;F%T=7)E(&]F(%-E<G9E<B!296=I<W1R871I;VYS( T*
M)R!T:&ES('-U8B!I<R!R96-U<G-I=F4N+@.T*4')I=F%T92!3=6(@.1&5L4U%,
M4F5G:7-T<F%T:6]N*%-E<G9E<DYA;64L(&]2;V]T3V)J96-T*0T*"2<@.5F%R
M:6%B;&5S#0H)1&EM(%-C<FEP=%-T<FEN9R @.(" @.(" @.(" @.(" @.(" G(')E
M='5R;G,@.:6YT;R!H97)E('1R86YS86-T('-Q;"!F;W(@.;V)J96-T#0H)1&EM
M(&9S(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" @.(" G($9I;&53>7-T96T@.;V)J
M96-T('9A<B M('1O(&%L;&]W(&9I;&4@.;W!E<F%T:6]N<RX-"@.E$:6T@.> D)
M"0DG('5S960@.:6X@.1F]R#0H)1&EM('(-"@.D-"@.E$:6T@.;T%P<&QI8V%T:6]N
M"0DG(%-13$1-3R!!<'!L:6-A=&EO;B!O8FIE8W0-"@.E$:6T@.;U)E9VES=&5R
M961397)V97)S"0T*"41I;2!O0W5R<F5N=%-E<G9E<D=R;W5P#0H-"@.E$:6T@.
M4F5G:7-T97)E9%-E<G9E<@.T*"41I;2!.=6U397)V97)'<F]U<',-"@.E$:6T@.
M8E-E<G9E<D9O=6YD#0H-"@.DG(&EE(&EF('1H92!F:7)S="!C86QL('=E(&YE
M960@.=&\@.8W)E871E(&$@.1$U/($%P<&QI8V%T:6]N(&]B:F5C="!T;R!S=&%R
M="!F<F]M(&%N9"!A<W-I9VX@.:70@.=&\@.;U)O;W1/8FIE8W0-"@.DG(&%L<V\@.
M<VAO=R!M97-S86=E('-A>6EN9R!I=&5R871I;F<@.<F5G:7-T97)E9"!S97)V
M97)S#0H)268@.;U)O;W1/8FIE8W0@.:7,@.3F]T:&EN9R!4:&5N( T*"0E7<V-R
M:7!T+D5C:&\@.(DET97)A=&EN9R!296=I<W1E<F5D(%-E<G9E<G,@.+BXN(@.T*
M"0E7<V-R:7!T+D5C:&\-"@.D)<V5T(&]2;V]T3V)J96-T(#T@.0W)E871E3V)J
M96-T*")344Q$34\N07!P;&EC871I;VXB*0T*"0E.=6U397)V97)'< F]U<',@.
M/2!O4F]O=$]B:F5C="Y397)V97)'<F]U<',N0V]U;G0-"@.E%;'-E#0H)"4YU
M;5-E<G9E<D=R;W5P<R ](&]2;V]T3V)J96-T+E-E<G9E<D=R;W5P<RY#;W5N
M= T*"45N9"!)9B -"@.T*"2<@.:2YE('-E="!S;R!397)V97(@.3F]T(&9O=6YD
M#0H)8E-E<G9E<D9O=6YD(#T@.," -"@.T*"2<@.:71E<F%T92!T:')O=6=H(%-E
M<G9E<D=R;W5P<R!S:&]W:6YG($YA;64-"@.E&;W(@.>" ](#$@.=&\@.3G5M4V5R
M=F5R1W)O=7!S#0H)"7-E="!O0W5R<F5N=%-E<G9E<D=R;W5P(#T@.;U)O;W1/
M8FIE8W0N4V5R=F5R1W)O=7!S*'@.I#0H)"5=38W)I<'0N16-H;R B1W)O=7 @.
M/2 B("L@.;T-U<G)E;G1397)V97)'<F]U<"Y.86UE#0H-"@.D)<V5T(&]296=I
M<W1E<F5D4V5R=F5R<R ](&]#=7)R96YT4V5R=F5R1W)O=7 N4F5G:7-T97)E
M9%-E<G9E<G,-"@.D)1F]R($5A8V@.@.4F5G:7-T97)E9%-E<G9E<B!I;B!O4F5G
M:7-T97)E9%-E<G9E<G,-"@.D)"5=38W)I<'0N16-H;R!V8E1!0B K(")397)V
M97(@./2 B("L@.4F5G:7-T97)E9%-E<G9E<BY.86UE#0H)"0D-"@.D)"2<@.*BHJ
M(%-E<G9E<B!&;W5N9"!H97)E("HJ*B -"@.D)"4EF(%5#05-%*%)E9VES=&5R
M961397)V97(N3F%M92D@./2!50T%312A397)V97).86UE*2!4:&5N#0H)"0D)
M5W-C<FEP="Y%8VAO('9B5$%"("L@.54-!4T4H4V5R=F5R3F%M92D@.*R B(&ES
M(')E9VES=&5R960N($1E;&5T:6YG(@.T*"0D)"5)E9VES=&5R9 61397)V97(N
M4F5M;W9E#0H)"0D)8E-E<G9E<D9O=6YD(#T@.,0T*"0D)"2<@.2&%V92!T;R!Q
M=6ET(&-O<R!R96-U<G-I=F4@.<W5B+"!%;F0@.4W5B('=O;B=T(&-U="!I= T*
M"0D)"5=S8W)I<'0N475I=" -"@.D)"45N9"!)9B -"@.D)3F5X= T*#0H)"2<@.
M:64@.=V4@.:&%V92!397)V97)'<F]U<',@.8F5L;W<@.=&AI<R!O;F4L('-O(')E
M8W5R<VEV96QY(&-A;&P@.=&AE(%-U8B!A9V%I;B!W:71H('1H92!C=7)R96YT
M(%-E<G9E<@.T*"0DG($=R;W5P(&%S('1H92!2;V]T3V)J96-T"0T*"0E)9B!O
M0W5R<F5N=%-E<G9E<D=R;W5P+E-E<G9E<D=R;W5P<RY#;W5N=" ^(# @.5&AE
M;B -"@.D)"4-A;&P@.1&5L4U%,4F5G:7-T<F%T:6]N("A397)V97).86UE+"!O
M0W5R<F5N=%-E<G9E<D=R;W5P*0T*"0E%;F0@.268@.#0H)3F5X= T*16YD(%-U
%8@.T*#0H`
`
end

How can i remove a server from enterprise manager

Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred

How can i remove a server from enterprise manager

Hello,
SQL-Server 2000:
how can I remove server registrations from enterprise manager, when
the servers are no more available?
For example there are several registrations from servers running under
a virtual pc (for developer purposes). Others are there from remote
support sessions. I'm not able to get in the context menu of that
servers.
Can you please help me?
Thanks AlfredI found this to be possible.
Using the mouse, if one "right clicks" on the server registration and waits
for what seems like an age, the menu appears allowing one to delete the
registration. Don't left-click first!|||"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
Does right-click, Delete SQL Server Registration not work?
Kind Regards, Howard|||try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete byusing
CSCRIPT DELSQLRegistration.vbs
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfred|||(sorry fat fingers)
try attached vbscript uses DMO to delete the server registration - rename to
.vbs and run on the server with registration u want to delete by using :
CSCRIPT DELSQLRegistration.vbs SERVER
where SERVER is the name of the server Registration you want to delete
Note for it to no longer appear in Enterprise Manager , you need to restart
Enterprise Manager.
Andy.
"Alfred Sehmueller" <alfred.sehmueller@.gmx.de> wrote in message
news:8d338431.0408310515.7ae1d9d6@.posting.google.com...
> Hello,
> SQL-Server 2000:
> how can I remove server registrations from enterprise manager, when
> the servers are no more available?
> For example there are several registrations from servers running under
> a virtual pc (for developer purposes). Others are there from remote
> support sessions. I'm not able to get in the context menu of that
> servers.
> Can you please help me?
> Thanks Alfredsql

how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>
|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>

how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>

how can i read the log file content in enterprise maanger?

how can i read the log file content in enterprise maanger?Hi
I am affraid you cannot.
Some of the options
DBCC LOGINFO (7) --database id
or
Visit at http://www.lumigent.com/
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>|||However you could use the tool from Lumigent ( Log Explorer )
www.lumigent.com
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Inamori" <test@.test.com> wrote in message
news:e3DyCi2rEHA.1272@.TK2MSFTNGP09.phx.gbl...
>sql

How Can I Install SQL Enterprise On Win Xp Pro.

How Can I Install SQL Enterprise On Win Xp Pro?

I Cann't Install SQL Enterprise On Win Xp Pro

help me ,thxYou can only install the SQL Personal edition, Developer Editioin and MSDE on Windows XP Pro. You need Windows 2000 or 2003 Server if you want to install the Enterprise Edition.

how can i install reporting services 2005

Hi,
I installed sql server 2005 enterprise edition and visual studion 2005
professional.
but i am unable to create any projects. how can i create a report project '
(i cant find a business intelligence project anyw here
thanks in advanceYou need to install the BI client tools from the SQL Server CD/DVD.
Note that you did not need VS 2005 unless you are writing custom assemblies
or using VS specific tools (like the new controls found in VS 2005).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> Hi,
> I installed sql server 2005 enterprise edition and visual studion 2005
> professional.
> but i am unable to create any projects. how can i create a report project
> '
> (i cant find a business intelligence project anyw here
> thanks in advance|||Bruce,
Can you tell me what options i have to select when installing sql server to
select BIclient tools ?
Thanks
"Bruce L-C [MVP]" wrote:
> You need to install the BI client tools from the SQL Server CD/DVD.
> Note that you did not need VS 2005 unless you are writing custom assemblies
> or using VS specific tools (like the new controls found in VS 2005).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RP" <RP@.discussions.microsoft.com> wrote in message
> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
> > Hi,
> > I installed sql server 2005 enterprise edition and visual studion 2005
> > professional.
> > but i am unable to create any projects. how can i create a report project
> > '
> > (i cant find a business intelligence project anyw here
> > thanks in advance
>
>|||I haven't installed it for awhile but it was obvious at the time.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RP" <RP@.discussions.microsoft.com> wrote in message
news:410BFD9A-F285-434A-985B-D18837488701@.microsoft.com...
> Bruce,
> Can you tell me what options i have to select when installing sql server
> to
> select BIclient tools ?
> Thanks
> "Bruce L-C [MVP]" wrote:
>> You need to install the BI client tools from the SQL Server CD/DVD.
>> Note that you did not need VS 2005 unless you are writing custom
>> assemblies
>> or using VS specific tools (like the new controls found in VS 2005).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RP" <RP@.discussions.microsoft.com> wrote in message
>> news:D06128B6-9838-47EE-A853-3BAD7187B66F@.microsoft.com...
>> > Hi,
>> > I installed sql server 2005 enterprise edition and visual studion 2005
>> > professional.
>> > but i am unable to create any projects. how can i create a report
>> > project
>> > '
>> > (i cant find a business intelligence project anyw here
>> > thanks in advance
>>

How can I insert a new field between existing field?

Dear all,
Is there any way can I insert a new field between existing fields through TS
QL or other means, without using Enterprise Manager?
Thanks a lot.
Regards,
Alex AUHi,
With out dropping and recreating the table you can not insert a column in be
tween 2 existing columns.
Actually enterprise manager internally does below events while inserting a n
ew field...
1. Pull data out
2. Generate script of table and dependants
3. Drop and recreate the table with new structure
4. Load the data
So while you do a schema change on huge tables; it will result in longer ex
ecution time...
Thanks
Hari
SQL Server MVP
"Alex AU" <acawh@.msn.com> wrote in message news:5003A40C-1603-4C8F-B591-DFFF
69DFC567@.microsoft.com...
Dear all,
Is there any way can I insert a new field between existing fields through TS
QL or other means, without using Enterprise Manager?
Thanks a lot.
Regards,
Alex AU|||The actual field order 'should' not matter. If you add a new column and it i
s at the 'end of the list', you can always retrieve the list of columns as y
ou want -with the new column in the 'middle'. Of course, that gets in the wa
y of using 'SELECT *' -but you shouldn't be doing that anyway!
(There some considerations that SQL Server will take in regard to field/data
type placement in the row on the datapage but that should not interfere with
your getting the data in the fashion you desire.)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Alex AU" <acawh@.msn.com> wrote in message news:5003A40C-1603-4C8F-B591-DFFF
69DFC567@.microsoft.com...
Dear all,
Is there any way can I insert a new field between existing fields through TS
QL or other means, without using Enterprise Manager?
Thanks a lot.
Regards,
Alex AU|||Thanks Hari,
If I want to mimic what Enterprise Manager do, what will be the right way?
Can I do as follows:-
- Create a temp table with the new fields inserted
- insert the data from old table to temp table
- drop the old table
- Create the table with the new structure
- insert the data back from temp table
- drop the temp table
Can I rename the temp table to the original table name to replace the last 3
steps?
Thanks a lot.
Regards,
Alex AU
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message news:uweZCACvGHA.
2260@.TK2MSFTNGP03.phx.gbl...
Hi,
With out dropping and recreating the table you can not insert a column in be
tween 2 existing columns.
Actually enterprise manager internally does below events while inserting a n
ew field...
1. Pull data out
2. Generate script of table and dependants
3. Drop and recreate the table with new structure
4. Load the data
So while you do a schema change on huge tables; it will result in longer ex
ecution time...
Thanks
Hari
SQL Server MVP
"Alex AU" <acawh@.msn.com> wrote in message news:5003A40C-1603-4C8F-B591-DFFF
69DFC567@.microsoft.com...
Dear all,
Is there any way can I insert a new field between existing fields through TS
QL or other means, without using Enterprise Manager?
Thanks a lot.
Regards,
Alex AU|||Alex AU wrote:
> Dear all,
> Is there any way can I insert a new field between existing fields
> through TSQL or other means, without using Enterprise Manager?
> Thanks a lot.
>
> Regards,
> Alex AU
Field order is irrelevant. Given two tables:
TableA: RowID, Value, Description, UpdateDate
TableB: RowID, Value, UpdateDate, Description
The field order means nothing, because your queries should always
specify a field list:
SELECT Value, Description, UpdateDate
FROM TableA
WHERE RowID = 1
SELECT Value, Description, UpdateDate
FROM TableB
WHERE RowID = 1
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Unless you're really lucky, it's far more complicated that than. You'll have
to take account of all constraints - Defaults, FKs etc and all indexes. The
se need to be dropped from the existing table and later readded to the tmp t
able. Also keep an eye out for any views created using select * from tablena
me, as they'll need to be refreshed afterwards. Finally, I'd also question w
hether it's worth it, when there's such little gain. Client apps should acce
ss columns by name rather than position, so typically the main gain is just
neatness for the DBA.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Paul Ibison SQL Server MVP said:
> "Client apps should access columns by name rather than position, so
> typically the main gain is just neatness for the DBA."
...Unless you're trying to do something completely off-the-wall and "crazy"
like writing a custom application to Bulk Load data into your table in which
case you have to specify columns by ordinal position...|||Then why not create a VIEW with the fields in the necessary order, and bulk
load the VIEW?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Mike C#" <xyz@.xyz.com> wrote in message
news:4X7Dg.6916$5L4.3133@.newsfe10.lga...
> Paul Ibison SQL Server MVP said:
> ...Unless you're trying to do something completely off-the-wall and
> "crazy" like writing a custom application to Bulk Load data into your
> table in which case you have to specify columns by ordinal position...
>|||"Arnie Rowland" <arnie@.1568.com> wrote in message
news:OiQESADwGHA.4460@.TK2MSFTNGP05.phx.gbl...
> Then why not create a VIEW with the fields in the necessary order, and
> bulk load the VIEW?
As long as the columns in the view are in the correct ordinal positions...
Table or view, bulk operations API's reference columns by ordinal position.

How can I get the table schema using Entreprise Library DAAB ?

Hello people,

i'm using the DAAB (Enterprise Library) to access the data in my system. But I need to use the schema from the tables i'm reading....

when I was using the default DataAdapter, I have used the FillSchema() method, but now, when I use de DAAB to fill de data, I couldn't get the primary keys columns, unique columns neither autoincrement columns...

This is the code that i'm using to get the data with DAAB:

===========================

Database db = DatabaseFactory.CreateDatabase();

DBCommandWrapper cmd = db.GetSqlStringCommandWrapper("SELECT * FROM Customer");

ds = db.ExecuteDataSet(cmd);

===========================

But this code don't return the schema from the "Customer" table.

Do you have any tip to do it?

thanks people

Andr

Since this is not a Data Mining question, can you try posting to one of these forums?:

.NET Framework Data Access and Storage (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=45)

SQL Server Data Access (http://forums.microsoft.com/msdn/ShowForum.aspx?ForumID=87)

Raman Iyer
SQL Server Data Mining
http://www.sqlserverdatamining.com

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:
> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>> I need to manage a SQL Server installation over the internet via a VPN
>> connection.
>>
>> Enterprise Manager can't see the server, when I put in the name, EM times
>> out.
>>
>> How can I Register this server if EM can't see it from here?
>>
>> If I Register the server while I'm at that site, should it then work from
>> my
>> remote office?
>>
>> Thanks
>>
>> Kelvin
>>

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
Kelvin
Not being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from my
> remote office?
>
> Thanks
>
> Kelvin
>
>
|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:

How can I get Enterprise Manager to see my remote server?

I need to manage a SQL Server installation over the internet via a VPN
connection.
Enterprise Manager can't see the server, when I put in the name, EM times
out.
How can I Register this server if EM can't see it from here?
If I Register the server while I'm at that site, should it then work from my
remote office?
Thanks
KelvinNot being able to connect to the SQL server in question may be due to a
couple of different issues.
Please try the below suggestions:
1 - Possibly due to latency in the VPN connection causing a connection
time-out.
- Increase the Enterprise Manager timeout for the connection
- In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
tab.
- Extend the value in the 'Login time-out' field (default of 10 seconds).
If the above doesn't work, then:
2 - Possibly a DNS/WINS resolution issue going over the VPN
- Run the Client Configuration Utility (CLICONFG.EXE) on your machine that
has the server registered in Enterprise Manager
- Click on the ALIAS tab
- Click ADD
- Type the name of the SQL Server (same name as you registered it with in
EM) in the 'Server Alias' field
- Click on the TCP/IP protocol (or applicable protocol if not using TCP/IP)
- In the 'Server Name' field, type the TCP/IP address for the server (or
the protocol's reference to the server if not using TCP/IP).
Dave
"Kelvin Beaton" wrote:

> I need to manage a SQL Server installation over the internet via a VPN
> connection.
>
> Enterprise Manager can't see the server, when I put in the name, EM times
> out.
>
> How can I Register this server if EM can't see it from here?
>
> If I Register the server while I'm at that site, should it then work from
my
> remote office?
>
> Thanks
>
> Kelvin
>
>|||thanks Dave
The second option worked!
Thanks a million
Kelvin
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:F2C00FEF-4800-4DE3-BAEC-E0125CE8BB7A@.microsoft.com...[vbcol=seagreen]
> Not being able to connect to the SQL server in question may be due to a
> couple of different issues.
> Please try the below suggestions:
> 1 - Possibly due to latency in the VPN connection causing a connection
> time-out.
> - Increase the Enterprise Manager timeout for the connection
> - In Enterprise Manager, select TOOLS, OPTIONS and click on the ADVANCED
> tab.
> - Extend the value in the 'Login time-out' field (default of 10 seconds).
> If the above doesn't work, then:
> 2 - Possibly a DNS/WINS resolution issue going over the VPN
> - Run the Client Configuration Utility (CLICONFG.EXE) on your machine
> that
> has the server registered in Enterprise Manager
> - Click on the ALIAS tab
> - Click ADD
> - Type the name of the SQL Server (same name as you registered it with in
> EM) in the 'Server Alias' field
> - Click on the TCP/IP protocol (or applicable protocol if not using
> TCP/IP)
> - In the 'Server Name' field, type the TCP/IP address for the server (or
> the protocol's reference to the server if not using TCP/IP).
> Dave
>
> "Kelvin Beaton" wrote:
>

How can I get another copy of RS2000? Need help ASAP!

I need another enterprise RS2000 CD. What is the quickest way to get one?
If you have a link or contact number please post. I am located in Atlanta
GA. I can't seem to find it on the website.
thanks in advance
OSOn Nov 26, 10:30 am, OriginalStealth
<OriginalStea...@.discussions.microsoft.com> wrote:
> I need another enterprise RS2000 CD. What is the quickest way to get one?
> If you have a link or contact number please post. I am located in Atlanta
> GA. I can't seem to find it on the website.
> thanks in advance
> OS
This link might be helpful.
http://technet.microsoft.com/en-us/sqlserver/bb331729.aspx
Regards,
Enrique Martinez
Sr. Software Consultant