Emailing

Not sure if this can be done but I have a report that gets run that has a
different page for each client it is run for. It doesnt necessarily have a
parameter. What my question is, is there a way to email each different page
to the specific client it is run for. Say I ran the report and it had 10
pages and on each page was a separate client. After the report is ran, how
can I get it to automatically send each specific page to its respectful
owner?I dont think it is a proper approach to do if the client doesn;t mind
or you Either seeing others information.
The proper approach should be have a parameter, Create subscriptions
for the 10 users.
Thats good
Thanks
Raj deep.A|||Clients dont want to see each others info and dont want others seeing their
info!
"RajDeep" <rajalapati@.gmail.com> wrote in message
news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>I dont think it is a proper approach to do if the client doesn;t mind
> or you Either seeing others information.
> The proper approach should be have a parameter, Create subscriptions
> for the 10 users.
> Thats good
> Thanks
> Raj deep.A|||On Apr 30, 5:58=A0pm, "Ben Watts" <lunuticsho...@.hotmail.com> wrote:
> Clients dont want to see each others info and dont want others seeing thei=r
> info!
> "RajDeep" <rajalap...@.gmail.com> wrote in message
> news:c63098f5-ed9b-405d-851a-7f6e29f12769@.q27g2000prf.googlegroups.com...
>
> >I dont think it is a proper approach to do if the client doesn;t mind
> > or you =A0Either seeing others information.
> > The proper approach should be have a parameter, Create subscriptions
> > for the 10 users.
> > Thats good
> > Thanks
> > Raj deep.A- Hide quoted text -
> - Show quoted text -
Are you running the Enterprise Editon? If so you MAY (running
Developer Edition here so don't know for sure whether you can or not)
be able to accomplish what you want with a data driven subscription.
Even if you can, I'm thinking you'll still need to parameterize your
query.
Without Enterprise, I agree with Rajdeep. You're going to have to use
a parameter for client ID and then probably create separate
subscriptions for each client.sql

email using

hi
can any one guide me, how to send email using stored procedure in sql server
2000 in windows 2003 o/s without using mail client installed on server.
Thanks
KalyanUse xp_smtp_sendmail, all you need is the ability to install an extended
procedure, and an SMTP server you can control.
http://www.aspfaq.com/2403
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
> hi
> can any one guide me, how to send email using stored procedure in sql
> server
> 2000 in windows 2003 o/s without using mail client installed on server.
> Thanks
> Kalyan
>|||Aaron
My operating system is windows 2003, Is smtp comes with IIS?
Thanks
Kalyan
"Aaron Bertrand [SQL Server MVP]" wrote:

> Use xp_smtp_sendmail, all you need is the ability to install an extended
> procedure, and an SMTP server you can control.
> http://www.aspfaq.com/2403
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:6CF632BE-9936-4E86-8477-297EBEFC952A@.microsoft.com...
>
>|||> My operating system is windows 2003, Is smtp comes with IIS?
IIS has its own SMTP server, so yes, I guess it is compatible. However, you
do not have to have SMTP running on the same server as SQL Server, in fact I
recommend it be separate.

Email Clients

Anyone using an email client other than MS Outlook so that Sql Server can
send mail?| Anyone using an email client other than MS Outlook so that Sql Server can
| send mail?
--
According to:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
NOTE: Due to the limitation of only providing extended MAPI support, SQL
Server 2000 requires a Microsoft Outlook 2000 client (or later version).
--
Eric Cárdenas
SQL Server support|||I prefer going SMTP without installing a mail client. Check out xp_smtp_sendmail from
www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"marle" <marleInfo@.mescobar.com> wrote in message news:ONffNA0wDHA.1060@.TK2MSFTNGP12.phx.gbl...
> Anyone using an email client other than MS Outlook so that Sql Server can
> send mail?
>

Email based subscription - need to change the from address

I have multiple reports being sent to various clients. I need to change the
from address on each report based on report's category and client. Is there
anyway I can change the "from" attribute of email report? I checked the
RSServerConfig.xml, and looked the Email configuration section, but If I
change there its going to change for all the report, I want a different from
address for each of my report.
Please help.
vipul ShahThere is no way to change the from address per delivery. You can only
change it globally. You can however change the reply-to field.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:3BA19CAC-2614-47AC-8A77-49ED8ACA5270@.microsoft.com...
>I have multiple reports being sent to various clients. I need to change
>the
> from address on each report based on report's category and client. Is
> there
> anyway I can change the "from" attribute of email report? I checked the
> RSServerConfig.xml, and looked the Email configuration section, but If I
> change there its going to change for all the report, I want a different
> from
> address for each of my report.
> Please help.
> vipul Shah|||That is very disappointing. I think it is very important feature to have in
reporting tool. Most of the report requirements would be for departmental
reports and each department would like to have their group email as a from
address. Is there anyway to have this feature in next release of reporting
services?
Also, how can I change "reply-to" address? Please advice.
Thanks
"Vipul Shah" wrote:
> I have multiple reports being sent to various clients. I need to change the
> from address on each report based on report's category and client. Is there
> anyway I can change the "from" attribute of email report? I checked the
> RSServerConfig.xml, and looked the Email configuration section, but If I
> change there its going to change for all the report, I want a different from
> address for each of my report.
> Please help.
> vipul Shah|||If you have Manage all subscription permission you will see the reply-to
field.
Changing the from clause is on the wish list already. Several customers
have asked for it.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vipul Shah" <VipulShah@.discussions.microsoft.com> wrote in message
news:C0664333-BFD0-498E-B333-D264B61A6C57@.microsoft.com...
> That is very disappointing. I think it is very important feature to have
> in
> reporting tool. Most of the report requirements would be for departmental
> reports and each department would like to have their group email as a from
> address. Is there anyway to have this feature in next release of
> reporting
> services?
> Also, how can I change "reply-to" address? Please advice.
> Thanks
> "Vipul Shah" wrote:
>> I have multiple reports being sent to various clients. I need to change
>> the
>> from address on each report based on report's category and client. Is
>> there
>> anyway I can change the "from" attribute of email report? I checked the
>> RSServerConfig.xml, and looked the Email configuration section, but If I
>> change there its going to change for all the report, I want a different
>> from
>> address for each of my report.
>> Please help.
>> vipul Shah

EM showing (No Items)

Having made no changes to the database server we are now getting no
database list when connecting via EM from client machines, as well as
locally on the database server. I've researched the problem to no
success. The database list shows up fine in QA, however. I used the
following script in QA:
use master
go
select * from sysdatabases
go
And this is the error message I received:
(36 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 51805.
I saw a similar message when trying to delete an outdated Login
account.
Anyone have any ideas? Thanks in advance!
Jon Brookins
Paragon New Media, Inc.What version? Have you run DBCC CHECKDB recently?
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.|||CHECKDB sounds like a good suggestion. Also, you might want to prepare yourself for restoring a
clean backup of the master database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.

EM registration info not sticking

My Window XP professional PC has SQL 2000 Client tools
installed.
SQL Client tools : SQL 2000 SP3
SQL Servers : SQL 2000 SP3
I also registered a few SQL servers in the Enterprise
Manager. Whenever I logged off and logged back on again,
I lost all the servers registration.
I noticed that when I exited Enterprise Manager, it
modified the file "C:\Program Files\Microsoft SQL Server\80
\Tools\BINN\SQL Server Enterprise Manager.MSC"
Is there any other files to be modified to keep the
registered settings e.g registry etc ?
Any ideas to save the settings when I log back on again ?
Thanks.I don't think I am the administrator of my machine. All
the machines here have to be applied "Local security
policy".
And I needed to know what registry settings and files
needed to keep the SQL server registration settings of
Enterprise Manager. Thus I can tell the network
administrator of what kind of permissions I needed.

eliechucrallah@hotmail.com

i was trying to register a new server in enterprise manager i got the
following message : "the client and server codepages do not match. some
ansi character mappings may not be possible" but under sql server
properties,general tab i have the same code page, just different product
version because of the installed service pack. i've used other then the
default collation and i am using replication between these two server.
the application is working fine not sure if the replication will work
fine. maybe other other settings in the same page where i choose
collation during setup don't match how can i check these settings after
setup is done ? i am using sql 7
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
elie,
What service pack levels are you running on the client and the server?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> i was trying to register a new server in enterprise manager i got the
> following message : "the client and server codepages do not match. some
> ansi character mappings may not be possible" but under sql server
> properties,general tab i have the same code page, just different product
> version because of the installed service pack. i've used other then the
> default collation and i am using replication between these two server.
> the application is working fine not sure if the replication will work
> fine. maybe other other settings in the same page where i choose
> collation during setup don't match how can i check these settings after
> setup is done ? i am using sql 7
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||select @.@.version
gave me this
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
on 1 server and this
Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
on the other
and sp_helpsort gave me the same result on both servers
i just downloaded sql 7 sp4 should i install it ?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||elie,
You should install SP4 on both machines.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> select @.@.version
> gave me this
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> on 1 server and this
> Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
> Mar 2 2000 06:49:37
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> on the other
> and sp_helpsort gave me the same result on both servers
> i just downloaded sql 7 sp4 should i install it ?
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
>

eliechucrallah@hotmail.com

i was trying to register a new server in enterprise manager i got the
following message : "the client and server codepages do not match. some
ansi character mappings may not be possible" but under sql server
properties,general tab i have the same code page, just different product
version because of the installed service pack. i've used other then the
default collation and i am using replication between these two server.
the application is working fine not sure if the replication will work
fine. maybe other other settings in the same page where i choose
collation during setup don't match how can i check these settings after
setup is done ? i am using sql 7
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!elie,
What service pack levels are you running on the client and the server?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> i was trying to register a new server in enterprise manager i got the
> following message : "the client and server codepages do not match. some
> ansi character mappings may not be possible" but under sql server
> properties,general tab i have the same code page, just different product
> version because of the installed service pack. i've used other then the
> default collation and i am using replication between these two server.
> the application is working fine not sure if the replication will work
> fine. maybe other other settings in the same page where i choose
> collation during setup don't match how can i check these settings after
> setup is done ? i am using sql 7
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!