Looking for tool

I'm looking for a MSSQL diagramming tool to replace the one in SQL2K.
A straight schema-import is okay, or if I can do round-trip design or
totally replace Enteprise Manager and have even more value add, that's great
too. A DB-specific tool would be better than a diagrammer w/import - but
I'm open to that if I find one that suites. (I have Viso, but not
enteprise - I'll check it out.) The main diagramming feature I want is nicer
and more informative gfx, especailly the ability to have the relationship
lines point to/from the exact field positions. Free is good, but don't mind
paying a few hundred bucks -- don't want to pay thousands. Any
recommendations?
thanks, m
Visio Enterprise might be a good option.
WinSQL has the ability to draw ER diagrams. http://www.synametrics.com/
--=20
Keith
"Mike" <vimakefile@.yahoo.com> wrote in message =
news:OQff0hdOEHA.1456@.TK2MSFTNGP09.phx.gbl...
> I'm looking for a MSSQL diagramming tool to replace the one in SQL2K.
> A straight schema-import is okay, or if I can do round-trip design or
> totally replace Enteprise Manager and have even more value add, that's =
great
> too. A DB-specific tool would be better than a diagrammer w/import - =
but
> I'm open to that if I find one that suites. (I have Viso, but not
> enteprise - I'll check it out.) The main diagramming feature I want is =
nicer
> and more informative gfx, especailly the ability to have the =
relationship
> lines point to/from the exact field positions. Free is good, but don't =
mind
> paying a few hundred bucks -- don't want to pay thousands. Any
> recommendations?
>=20
> thanks, m
>=20
>

Looking for some examples link server, excel file

I have excel file and need to create a link server so I can read excel file
from sql2k.
Server where file is residing is SERVER1
Excel file name is ABC
User name is XYZ
password is PASSWORD
and the column that I want to retreive is Price.
I would appreciate if someone please show me an example for Link server
Thanks
msnews.microsoft.com wrote:
> I have excel file and need to create a link server so I can read excel file
> from sql2k.
> Server where file is residing is SERVER1
> Excel file name is ABC
> User name is XYZ
> password is PASSWORD
>
> and the column that I want to retreive is Price.
> I would appreciate if someone please show me an example for Link server
> Thanks
>
>
Hi
Try to look up "sp_addlinkedserver" in Books On Line. Here you have the
syntax for adding an Excel file as a linked server.
Regards
Steen

Looking for some examples link server, excel file

I have excel file and need to create a link server so I can read excel file
from sql2k.
Server where file is residing is SERVER1
Excel file name is ABC
User name is XYZ
password is PASSWORD
and the column that I want to retreive is Price.
I would appreciate if someone please show me an example for Link server
Thanksmsnews.microsoft.com wrote:
> I have excel file and need to create a link server so I can read excel fil
e
> from sql2k.
> Server where file is residing is SERVER1
> Excel file name is ABC
> User name is XYZ
> password is PASSWORD
>
> and the column that I want to retreive is Price.
> I would appreciate if someone please show me an example for Link server
> Thanks
>
>
Hi
Try to look up "sp_addlinkedserver" in Books On Line. Here you have the
syntax for adding an Excel file as a linked server.
Regards
Steen

Looking for server and db monitoring scripts

Hello ladies and gentlemen.

I am scouring the net to find SQL2k admin scripts. I am interested in both monitoring of the server as well as the rdbms.

I'm sure this question has been presented many times, but I did not find referenct to it. I'm sorry if this is a very old subject.

I am change rdbms from oracle to sql2k and am having to put in extra effort to change my mind set. Though similar, there are many, many differences.

Any help would be very appreciated.

I will be getting my ms dba certifications soon, and look forward to helping with your dbforums communnity.

Thank youI reccomend a couple good books for monitoring and performance type thigns, I would not reccomend using a bunch of scripts until you know what they are doing.

Two books - Inside SQL Server 2000 by Kalen Delaney and Performance Monitoring with SQL Server 2000 by MSPress.

HTH|||I've been looking for good SQL2k books as well. Thank you for your help.
<br><Br>

Originally posted by rhigdon
I reccomend a couple good books for monitoring and performance type thigns, I would not reccomend using a bunch of scripts until you know what they are doing.

Two books - Inside SQL Server 2000 by Kalen Delaney and Performance Monitoring with SQL Server 2000 by MSPress.

HTH

Looking for examples for link server, excel file

I have excel file and need to create a link server so I can read excel file
from sql2k.
Server where file is residing is SERVER1
Excel file name is ABC
User name is XYZ
password is PASSWORD
and the column that I want to retreive is Price.
I would appreciate if someone please show me an example for Link server
Thanks
msnews.microsoft.com schrieb:
> I have excel file and need to create a link server so I can read excel file
> from sql2k.
> Server where file is residing is SERVER1
> Excel file name is ABC
> User name is XYZ
> password is PASSWORD
>
> and the column that I want to retreive is Price.
> I would appreciate if someone please show me an example for Link server
> Thanks
>
EXEC sp_addlinkedserver 'XLSSource', 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0', 'c:\yourDocument.xls',NULL, 'Excel 8.0'
hth
Stefka