Marking Multiple Records?

I have a crystal report that I have been asked to modify for a new process.

This report will take a look at our scheduling system and display which Dies are needed for each order. The Problem I am running into is I need a way to be able to denote that a Die is at another operation if the die number is previously listed in the report. This would be fine if I could sort by Die number, but the report has to be sorted by time so our Die room staff knows when a die is due to a machine and are able to just run through the list without having to search through the report for the next order.

This report is currently grouped by run date (so we can keep shifts straight) and sorted by Run Start Time and then by machine number.
This is the order is has to be in, and I cannot deviate from that.

Attached is an example of the current layout of the report

My issue is that I need some way to Denote that the die for the last order 278381-1 is at another machine (the First 2 orders 278385-1) so our Die Room staff are not searching for the Die on Rack 51 when they go to get the dies for the the last order.

I have thought long and hard about this, and I cannot figure out a way to get through this issue without reordering the report, which I cant do.

Any assistance or direction would be greatly appreciatedProblem has been resolved
The solution involved creating a Sub-Report and filtering out the extra records that did not match and then adding a Formatting to the Field to denote a Duplicate record.

Marking a table as a System Table

Okay, most peoples answer to this may be "Gaaah. Why would you do
this?", or the like, but here's the question anyway:

Are there any stability issues if I mark one of my user tables as a
system table (by switching xtype in sysobjects from 'S' to 'U')?

I'm not doing this as "a cleved bit of security" or some such - my
actual reason for doing this is so that some of my automatic generation
tools do not process this particular table, and I want a method that
will not mean updating each of the tools if I ever add another table
like this.

It APPEARS to work, based on a quick trial, but has anybody got any
direct experience of this? Any horror stories like "Well, it worked
fine for two weeks, then it shot my co-workers, set fire to the company
accounts, and urinated in a corner. Then things got worse"

Also, yes, yes, yes, I do not necessarily expect this to work in future
releases of SQL Server (currently on 2000), but I should avoid naming
conflicts by the fact that the owner isn't dbo.
Thanks in advance for any insights."Damien" wrote:

> Okay, most peoples answer to this may be "Gaaah. Why would you do
> this?", or the like, but here's the question anyway:
> Are there any stability issues if I mark one of my user tables as a
> system table (by switching xtype in sysobjects from 'S' to 'U')?
> I'm not doing this as "a cleved bit of security" or some such - my
> actual reason for doing this is so that some of my automatic generation
> tools do not process this particular table, and I want a method that
> will not mean updating each of the tools if I ever add another table
> like this.
> It APPEARS to work, based on a quick trial, but has anybody got any
> direct experience of this? Any horror stories like "Well, it worked
> fine for two weeks, then it shot my co-workers, set fire to the company
> accounts, and urinated in a corner. Then things got worse"
> Also, yes, yes, yes, I do not necessarily expect this to work in future
> releases of SQL Server (currently on 2000), but I should avoid naming
> conflicts by the fact that the owner isn't dbo.
> Thanks in advance for any insights.

Well I changed a system table once and all the workers recovered, the
building only smoldered, no one noticed the puddle, and then things seemed
to clear up on their own :)

Seriously, though, why not use extended properties for this purpose? For
your table that you don't want to process, use...

exec sp_addextendedproperty
'DoNotProcess',
'1',
'USER',
'dbo',
'TABLE',
'TableThatIsntProcessed',
NULL,
NULL

...Then before you process any table you can...

if not exists (
select null
from ::fn_listextendedproperty(
'DoNotProcess',
'USER', 'dbo',
'TABLE', 'TableThatIsntProcessed',
NULL, NULL
)
where value = '1'
)
begin
print 'process table'
end

This way any table can be selectively set up for processing or not without
touching the system tables and you have a better chance of not getting
broken with succesive releases of SQL Server.

Craig|||Thanks, I'll look into that. I've not used extended properties before
(then again, we've only just upgraded from 7 (as in, last weekend), was
it available in 7?)|||"Damien" wrote:

<snip>
> was it available in 7?

<snip
http://www.microsoft.com/sql/techin...dproperties.asp

According to this link, no (the page above also contains links to articles
on using extended properties, although I didn't follow them to see if they
were still good). It's been a while since we upgraded from 7 to 2K, but
that also seems sync with my memory.

Craigsql

MAPI (SQL Mail) Client on SQL 2000 Itanium System... How can I do

http://support.microsoft.com/?kbid=908360
I see there is a KB for this on 2005, but Microsoft Great Plains will not
work with 2005 (yet) so I am stuck with 2000.
I have gotten my hands on a HP RX5670 pretty cheap and would like to host
our SQL Server there, but I am having issues setting up SQL Mail.
Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
Thanks in advance.
I don't know if extended stored procs for SQL 32 bit work with 64 bit but
I'd recommend xp_smtp_sendmail.
http://www.sqldev.net/xp/xpsmtp.htm
It works flawlessly. I have often had problems with MAPI based email. I've
been told that MS have rewritten the emailing in SQL 2005.
Paul
"Gjeret Stein" <Gjeret Stein@.discussions.microsoft.com> wrote in message
news:83777CDA-47E6-4141-AD60-873BC7F81F0A@.microsoft.com...
> http://support.microsoft.com/?kbid=908360
> I see there is a KB for this on 2005, but Microsoft Great Plains will not
> work with 2005 (yet) so I am stuck with 2000.
> I have gotten my hands on a HP RX5670 pretty cheap and would like to host
> our SQL Server there, but I am having issues setting up SQL Mail.
> Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
> Thanks in advance.
>

MAPI (SQL Mail) Client on SQL 2000 Itanium System... How can I do

http://support.microsoft.com/?kbid=908360
I see there is a KB for this on 2005, but Microsoft Great Plains will not
work with 2005 (yet) so I am stuck with 2000.
I have gotten my hands on a HP RX5670 pretty cheap and would like to host
our SQL Server there, but I am having issues setting up SQL Mail.
Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
Thanks in advance.I don't know if extended stored procs for SQL 32 bit work with 64 bit but
I'd recommend xp_smtp_sendmail.
http://www.sqldev.net/xp/xpsmtp.htm
It works flawlessly. I have often had problems with MAPI based email. I've
been told that MS have rewritten the emailing in SQL 2005.
Paul
"Gjeret Stein" <Gjeret Stein@.discussions.microsoft.com> wrote in message
news:83777CDA-47E6-4141-AD60-873BC7F81F0A@.microsoft.com...
> http://support.microsoft.com/?kbid=908360
> I see there is a KB for this on 2005, but Microsoft Great Plains will not
> work with 2005 (yet) so I am stuck with 2000.
> I have gotten my hands on a HP RX5670 pretty cheap and would like to host
> our SQL Server there, but I am having issues setting up SQL Mail.
> Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
> Thanks in advance.
>sql

MAPI (SQL Mail) Client on SQL 2000 Itanium System... How can I do

http://support.microsoft.com/?kbid=908360
I see there is a KB for this on 2005, but Microsoft Great Plains will not
work with 2005 (yet) so I am stuck with 2000.
I have gotten my hands on a HP RX5670 pretty cheap and would like to host
our SQL Server there, but I am having issues setting up SQL Mail.
Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
Thanks in advance.I don't know if extended stored procs for SQL 32 bit work with 64 bit but
I'd recommend xp_smtp_sendmail.
http://www.sqldev.net/xp/xpsmtp.htm
It works flawlessly. I have often had problems with MAPI based email. I've
been told that MS have rewritten the emailing in SQL 2005.
Paul
"Gjeret Stein" <Gjeret Stein@.discussions.microsoft.com> wrote in message
news:83777CDA-47E6-4141-AD60-873BC7F81F0A@.microsoft.com...
> http://support.microsoft.com/?kbid=908360
> I see there is a KB for this on 2005, but Microsoft Great Plains will not
> work with 2005 (yet) so I am stuck with 2000.
> I have gotten my hands on a HP RX5670 pretty cheap and would like to host
> our SQL Server there, but I am having issues setting up SQL Mail.
> Can someone point me at a RTFM to get SQL Mail working on IA64 SQL 2000?
> Thanks in advance.
>

many "or" operation make system choose incorrect index

Hi All,

I have one question about many "or" operation make system choose
incorrect index

There is one table TT (
C1 VARCHAR(15) NOT NULL,
C2 VARCHAR(15) NOT NULL,
C3 VARCHAR(15) NOT NULL,
C4 VARCHAR(15) NOT NULL
C5 VARCHAR2(200),
)

Primary Key TT_PK (C1, C2, C3, C4)

SELECT C1, C2, C3, C4 FROM TT WHERE C1 = 'TEST' AND ((C2 =
'07RES' AND C3 = '00000' AND C4 = '02383') OR (C2 = '07RES' AND
C3 = '00000' AND C4 = '02382') OR (C2 = '07RES' AND C3 = '00000'
AND C4 = '02381') OR (C2 = '07RES' AND C3 = '00000' AND C4 =
'02380') OR (C2 = '07RES' AND C3 = '00000' AND C4 = '02379') OR
(C2 = '07RES' AND C3 = '00000' AND C4 = '02378') OR (C2 = '07RES'
AND C3 = '00000' AND C4 = '02377') OR (C2 = '07RES' AND C3 =
'00000' AND C4 = '02376') OR (C2 = '07RES' AND C3 = '00000' AND
C4 = '02375') OR (C2 = '07RES' AND C3 = '00000' AND C4 =
'02374') OR (C2 = '07RES' AND C3 = '00000' AND C4 = '02373') OR
(C2 = '07RES' AND C3 = '00000' AND C4 = '02372')
... about 100 or operations
OR (C2 = '07COM' AND C3 = '00000' AND C4 = '00618') OR (C2 =
'07COM' AND C3 = '00000' AND C4 = '00617') OR (C2 = '07COM' AND
C3 = '00000' AND C4 = '00616') OR (C2 = '07COM' AND C3 = '00000'
AND C4 = '00608') )

The system choose index prefix, and query all index leaf with
C1='TEST'

Prefix: [dbo].[TT].C1 = 'TEST'

After I reduce the OR operators to 50, it use choose

Prefix: [dbo].[TT].C1, [dbo].[TT].C2,[dbo].[TT].C3,[dbo].[TT].C4=
'TEST, '07RES', '00000', '02383'
Then Merge Join, it is very quick,

Can anyone help on this, do I have to reduce the OR operator to 50?

Thanks in advance!lsllcm,

Is there a join in the query? I get the feeling you did not post all
relevant parts of the query. Why would you get a merge join? And what
does "The system choose index prefix" mean?

There is no hard or fast rule for this. Although I could imagine that
too many predicates would disqualify index seeks, in general it is all
about selectivity. During compilation the optimizer will try to
determine whether index seeks (followed by bookmark lookups) are faster
than (partially) scanning the (clustered) index, based on the estimate
of the number of qualifying rows.

Please note that there is a certain point at which the compilation time
grows a lot for each addition predicate you add to the WHERE clause. If
the compilation time exceeds the estimated gains, the optimizer will
stop compilation and simply choose a "good enough" plan.

If the performance of this query is very important to you, and the
structure of the predicates is as "simple" and predictable as your
example, then you could consider rewriting the query as below:

SELECT C1, C2, C3, C4
FROM TT
WHERE C1 = 'TEST'
AND C2 = '07RES'
AND C3 = '00000'
AND C4 IN ('02383','02382','02381','02380','02379', ...)
UNION ALL
SELECT C1, C2, C3, C4
FROM TT
WHERE C1 = 'TEST'
AND C2 = '07COM'
AND C3 = '00000'
AND C4 IN ('00618','00617','00616', ...)

--
Gert-Jan

lsllcm wrote:

Quote:

Originally Posted by

>
Hi All,
>
I have one question about many "or" operation make system choose
incorrect index
>
There is one table TT (
C1 VARCHAR(15) NOT NULL,
C2 VARCHAR(15) NOT NULL,
C3 VARCHAR(15) NOT NULL,
C4 VARCHAR(15) NOT NULL
C5 VARCHAR2(200),
)
>
Primary Key TT_PK (C1, C2, C3, C4)
>
SELECT C1, C2, C3, C4 FROM TT WHERE C1 = 'TEST' AND ((C2 =
'07RES' AND C3 = '00000' AND C4 = '02383') OR (C2 = '07RES' AND
C3 = '00000' AND C4 = '02382') OR (C2 = '07RES' AND C3 = '00000'
AND C4 = '02381') OR (C2 = '07RES' AND C3 = '00000' AND C4 =
'02380') OR (C2 = '07RES' AND C3 = '00000' AND C4 = '02379') OR
(C2 = '07RES' AND C3 = '00000' AND C4 = '02378') OR (C2 = '07RES'
AND C3 = '00000' AND C4 = '02377') OR (C2 = '07RES' AND C3 =
'00000' AND C4 = '02376') OR (C2 = '07RES' AND C3 = '00000' AND
C4 = '02375') OR (C2 = '07RES' AND C3 = '00000' AND C4 =
'02374') OR (C2 = '07RES' AND C3 = '00000' AND C4 = '02373') OR
(C2 = '07RES' AND C3 = '00000' AND C4 = '02372')
... about 100 or operations
OR (C2 = '07COM' AND C3 = '00000' AND C4 = '00618') OR (C2 =
'07COM' AND C3 = '00000' AND C4 = '00617') OR (C2 = '07COM' AND
C3 = '00000' AND C4 = '00616') OR (C2 = '07COM' AND C3 = '00000'
AND C4 = '00608') )
>
The system choose index prefix, and query all index leaf with
C1='TEST'
>
Prefix: [dbo].[TT].C1 = 'TEST'
>
After I reduce the OR operators to 50, it use choose
>
Prefix: [dbo].[TT].C1, [dbo].[TT].C2,[dbo].[TT].C3,[dbo].[TT].C4=
'TEST, '07RES', '00000', '02383'
Then Merge Join, it is very quick,
>
Can anyone help on this, do I have to reduce the OR operator to 50?
>
Thanks in advance!

|||Gert-Jan Strik (sorry@.toomuchspamalready.nl) writes:

Quote:

Originally Posted by

Please note that there is a certain point at which the compilation time
grows a lot for each addition predicate you add to the WHERE clause. If
the compilation time exceeds the estimated gains, the optimizer will
stop compilation and simply choose a "good enough" plan.

Indeed. Many OR clauses, or many values in IN can result in horrendeous
compilation times. SQL 2005 fare a lot better than SQL 2000, but the cost
is still high.

One thing I've notice that when there are more than 63 values (I think
that was the value), SQL Server stashes all the constants into a work
table, and you get the same result as you had the values in a temp table.
At least that was what I saw in a test that I ran.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Gert-Jan,

Is there a join in the query? I get the feeling you did not post all
relevant parts of the query. Why would you get a merge join? And what
does "The system choose index prefix" mean?

There is no join in the query, I think the merge join is to merge the
results of different OR.

The system choose run the partial index of beginning "SERV_PROV_CODE".

Thanks
Jacky|||Thank you|||The version mssql 2005 sp1

Manuel Identity system

Hi,
I have a table (TABLE_A) like this:

MY_ID int unique
Field1 varchar(10)

I am using manuel identity system like this:
INSERT INTO TABLE_A (MY_ID, Field1) SELECT MAX(MY_ID) + 1, 'Field1 Value'

One row insert there is no problem, but more than one row how can I use insert statement?
(TABLE_B have more than one record)

INSERT INTO TABLE_A (MY_ID, Field1)
SELECT (SELECT MAX(MY_ID) + 1 FROM TABLE_A), FieldX FROM TABLE_B

Iron:

I normally use a stored procedure for retrieving identity values from identity tables. In this way I can have the procedure retrieve single identifiers or a list of identifiers and maintain the identity table.

|||

Hi,

Why not using the identity in table_A like this:

create table A

(

My_ID int identity(1,1)

Field1 varchar(10)

)

any way you intend to insert the max id each time - here in this way every time you will make an insert the

table A will get an id automatically.

so if you want to insert to table A field from table B you can do the following:

insert into table A

select Field from table B

when you will do that each time your new record will get a new max id.

i.e:

insert into table A

select 'test' from B

union

select 'test1' from B

your table A will look like the following:

1 test

2 test1

|||

Something that may or may not matter to you is that using IDENTITY to create incremental values can result in range gaps if an INSERT is rolled back for whatever reason. If you cannot tolerate gaps in your range of values then stick with a custom generation method. If gaps are acceptable then why not consider using IDENTITY?

To create incrementing values for several rows at once you could use SQL Server 2005's ROW_NUMBER() function added to an offset obtained from a seed table. You could then take the existing seed value, add the value of @.@.ROWCOUNT then store the new value in the seed table. Note that if using @.@.ROWCOUNT then you will need to be careful if you have triggers on the table as these could cause @.@.ROWCOUNT not to reflect the number of rows inserted into the base table. You also need to be careful if you are using SNAPSHOT isolation or if you are using the READ UNCOMMITTED isolation level. I've included an example of this method below.

Chris

/*

--Create and populate the test tables.

CREATE TABLE dbo.TestTable

(

TestTableID INT NOT NULL PRIMARY KEY,

TestValue VARCHAR(8000) NOT NULL

)

GO

CREATE TABLE dbo.TestTableSeed

(

SeedValue INT NOT NULL

)

GO

--Populate the seed table - arbitrary number for demo purposes.

INSERT INTO dbo.TestTableSeed(SeedValue)

VALUES(425)

GO

*/

--Repeatedly run this batch to insert new rows into dbo.TestTable and

--increment the seed to the most recent value inserted into the TestTableID column.

DECLARE @.SeedValue INT

DECLARE @.SeedValueOffset INT

BEGIN TRANSACTION

--Obtain the current seed value - hold an exclusive lock

--on the table so that other connections cannot read the table's data.

--Be careful if using the SNAPSHOT and READ UNCOMMITTED isolation levels.

SELECT @.SeedValue = SeedValue

FROM dbo.TestTableSeed WITH (TABLOCKX, HOLDLOCK)

--Insert of sample data - substitute your actual INSERT statement into here

--and add in the ROW_NUMBER function.

--Important: ensure that the columns specified in both 'ORDER BY' clauses are the same.

INSERT INTO dbo.TestTable(TestTableID, TestValue)

SELECT TOP 10

@.SeedValue + ROW_NUMBER() OVER (ORDER BY [name] ASC) AS TestTableID,

[Name]

FROM sys.objects

ORDER BY [name]

--Obtain the number of rows affected by the INSERT statement.

--Be careful if you have triggers on the table into which the INSERT was performed.

SET @.SeedValueOffset = @.@.ROWCOUNT

--Update the seed table.

UPDATE dbo.TestTableSeed

SET SeedValue = @.SeedValue + @.SeedValueOffset

COMMIT TRANSACTION

--Return our new rows.

SELECT TestTableID,

TestValue

FROM dbo.TestTable

GO

/*

--Clean up.

DROP TABLE dbo.TestTable

GO

DROP TABLE dbo.TestTableSeed

GO

*/

Manipulating a reports visual appearance

Hi,
we are changing at the moment our reporting system from crystal report to MS
Reporting services. Our reports are highly customizable during display. In
Crystal Reports we were using scripts into the reports to set the text align
and the column back- and foreground color by user decisions. It was also
possible to choose whether the report should be displayed in landscape or
portrait format. Now I need to give the reports with MS Reporting Services
the same abilities but I didn't find any possiblity to that yet. Because our
main application in which the reports are shown is written in good old MFC
we are using URL access to render and display the reports.
Does anyone here knows how to solve one or all of my issues described above?
Thanks in Advance
Markus
P.S. I'm a really newbie in MS Reporting Services.Style properties (like text alignment and color) can be expressions. These
expressions can depend on parameters to the report.
For example:
<TextAlign>=Parameters!TextAlign.Value</TextAlign>
Or:
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
Color>
For page orientation, you can set the page height and width via parameters
in the URL (something like rc:PageHeight=8.5... Check the documentation for
details)
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||TextAlign, BackgroundColor, and ForegroundColor can be expressions, so you
can make them user-driven using user-entered parameters. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_3983.asp
for details.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus Heid" <markus.heid@.logasys.com> wrote in message
news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> we are changing at the moment our reporting system from crystal report to
MS
> Reporting services. Our reports are highly customizable during display. In
> Crystal Reports we were using scripts into the reports to set the text
align
> and the column back- and foreground color by user decisions. It was also
> possible to choose whether the report should be displayed in landscape or
> portrait format. Now I need to give the reports with MS Reporting Services
> the same abilities but I didn't find any possiblity to that yet. Because
our
> main application in which the reports are shown is written in good old MFC
> we are using URL access to render and display the reports.
> Does anyone here knows how to solve one or all of my issues described
above?
> Thanks in Advance
> Markus
> P.S. I'm a really newbie in MS Reporting Services.
>|||Thank you very much. It is much easier than I though!
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:uetiBzFZEHA.2972@.tk2msftngp13.phx.gbl...
> Style properties (like text alignment and color) can be expressions.
These
> expressions can depend on parameters to the report.
> For example:
> <TextAlign>=Parameters!TextAlign.Value</TextAlign>
> Or:
>
<Color>=iif(Parameters!ColorScheme.Value="Rainbow","HotPink","LightBrown")</
> Color>
> For page orientation, you can set the page height and width via parameters
> in the URL (something like rc:PageHeight=8.5... Check the documentation
for
> details)
>
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Markus Heid" <markus.heid@.logasys.com> wrote in message
> news:efgHn3$YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > we are changing at the moment our reporting system from crystal report
to
> MS
> > Reporting services. Our reports are highly customizable during display.
In
> > Crystal Reports we were using scripts into the reports to set the text
> align
> > and the column back- and foreground color by user decisions. It was also
> > possible to choose whether the report should be displayed in landscape
or
> > portrait format. Now I need to give the reports with MS Reporting
Services
> > the same abilities but I didn't find any possiblity to that yet. Because
> our
> > main application in which the reports are shown is written in good old
MFC
> > we are using URL access to render and display the reports.
> > Does anyone here knows how to solve one or all of my issues described
> above?
> >
> > Thanks in Advance
> >
> > Markus
> >
> > P.S. I'm a really newbie in MS Reporting Services.
> >
> >
>

Managing MS SQL on Linux

Hi everyone,

I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.

Thanks for any suggestions or ideas ...

AlexAlex wrote:

Quote:

Originally Posted by

Hi everyone,
>
I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.
>
Thanks for any suggestions or ideas ...
>
Alex

Using "is" with the -m flag you can query MS SQL Server databases. is
also has a whole bunch of other useful and cool stuff:

<http://gagne.homedns.org/~tgagne/is/>|||ZeldorBlat wrote:

Quote:

Originally Posted by

Alex wrote:

Quote:

Originally Posted by

Hi everyone,

I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL

Use RDP or any method like UltraVNC, TightVNC, etc. etc. that allows
you to log in to the SQL server itself and do your stuff...then you can
use SSMS and all its goodness...I RDP all the time to my servers. No
harm done.

HTH tom|||tlyczko wrote:

Quote:

Originally Posted by

ZeldorBlat wrote:

Quote:

Originally Posted by

>Alex wrote:

Quote:

Originally Posted by

>>Hi everyone,
>>>
>>I'm looking into moving my desktop system at work to Linux from Windows
>>XP, and one tool I've yet to find a suitable replacement for is MS SQL

Why not Oracle Database 10g Express Edition? It is completely free and,
it runs on both Windows and Linux. It is a fully functional Oracle
database engine.

http://www.oracle.com/technology/so...e10g/index.html
--
Daniel Morgan
University of Washington|||Alex wrote:

Quote:

Originally Posted by

Hi everyone,
>
I'm looking into moving my desktop system at work to Linux from Windows
XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager. I mainly need to query MS SQL databases from
Linux, and management tasks (monitor backups, services, etc) can be
done on the MS SQL servers themselves. THere was an application I used
to use on OSX which would connect to a variety of databases, including
MS SQL, and they had a Linux version of the client .. but can't
remember the name. But really any Sybase client that can connect to MS
SQL with some ease will work.

If you are mainly querying SQL you can use FreeTDS which comes with a
command line query tool aka osql IIRC. Other than that there are some
free Java based tools around that can execute SQL on any DB with a JDBC
driver and some of them are even capable of displaying meta data. One
of them is http://www.sql-workbench.net/ - you may find more here:
http://www.databaseanswers.com/modelling_tools.htm
http://www.javaskyline.com/database.html
Kind regards

robert|||I'm looking into moving my desktop system at work to Linux from Windows

Quote:

Originally Posted by

Quote:

Originally Posted by

XP, and one tool I've yet to find a suitable replacement for is MS SQL
Enterprise Manager.

Try Squirrel SQL http://squirrel-sql.sourceforge.net with jtds that
someone else mentioned. It's the best open source database admin tool
I've found so far.

tim