When running SQL2K5 on W2K3 and creating a sql server login w/ both
CHECK_EXPIRATION and CHECK_POLICY set to ON, which password plicy will take
effect if there is both a local policy on that server and a domain policy
affecting that server? Generally, domain policy will take precedence over a
local policy, but SQL2K5 does not address this detail and which will take
effect. I've hunted down lots of documentation, but none of it seems clear.
Thanks.SQL Server doesn't deal with this issue. It simply hits the security API.
The domain policy will override the local policy which is by design in
Windows. SQL Server simply abides by what Windows enforces.
Mike Hotek
MHS Enterprises, Inc
http://www.mssqlserver.com
"DisgruntledTechGuy" <DisgruntledTechGuy@.discussions.microsoft.com> wrote in
message news:12CC258C-C990-47C0-A36D-6EEC39E42A03@.microsoft.com...
> When running SQL2K5 on W2K3 and creating a sql server login w/ both
> CHECK_EXPIRATION and CHECK_POLICY set to ON, which password plicy will
> take
> effect if there is both a local policy on that server and a domain policy
> affecting that server? Generally, domain policy will take precedence over
> a
> local policy, but SQL2K5 does not address this detail and which will take
> effect. I've hunted down lots of documentation, but none of it seems
> clear.
> Thanks.|||Thanks Mike. That's what I figured, but documentation out there was ambiguo
us.
"Michael Hotek" wrote:
> SQL Server doesn't deal with this issue. It simply hits the security API.
> The domain policy will override the local policy which is by design in
> Windows. SQL Server simply abides by what Windows enforces.
> --
> Mike Hotek
> MHS Enterprises, Inc
> http://www.mssqlserver.com
>
> "DisgruntledTechGuy" <DisgruntledTechGuy@.discussions.microsoft.com> wrote
in
> message news:12CC258C-C990-47C0-A36D-6EEC39E42A03@.microsoft.com...
>
>sql
Showing posts with label creating. Show all posts
Showing posts with label creating. Show all posts
Wednesday, March 28, 2012
Wednesday, March 21, 2012
POSTING AGAIN Transaction Replication - Identity column
Hi,
I am using transaction replication and the identity column is not included
for replication.
After creating the snapshot, i manually copying the data through stored
procedure from publishing database to subscription database. Then,if we run
the distribution agent,i am getting the following error. what will be the
process involved in applying the initial snapshot since i have already
copied the data. Will SQL server do bcp again? How can i avoid it?
Error Message: The process could not bulk copy into table '"hsassbtr"'.
Error Details:
Numeric value out of range
(Source: INFOSYS6 (ODBC); Error number: 22003)
Numeric value out of range
(Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
Unexpected EOF encountered in BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
key in object 'hsassbtr'.
(Source: INFOSYS6 (Data source); Error number: 2627)
Aritcle is added as follows:
--added all the columns
exec sp_articlecolumn @.publication = 'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = NULL,
@.operation = N'add',
@.force_invalidate_snapshot = 1
--dropped identity('DEX_ROW_ID') columns
exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = N'DEX_ROW_ID',
@.operation = N'drop',
@.force_invalidate_snapshot = 1
I have created the subscription as follows:
exec sp_addpullsubscription
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.independent_agent = N'true',
@.subscription_type = N'anonymous',
@.description = N'InfoSys POC Setup Table Publication',
@.update_mode = N'read only',
@.immediate_sync = 1
exec sp_addpullsubscription_agent
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.distributor = @.distributor,
@.subscriber_security_mode = @.security_mode,
@.distributor_security_mode = @.security_mode,
@.frequency_type = 8, --Weekly
@.frequency_interval = 1, --Sunday
@.frequency_recurrence_factor = 1, --Every Week
@.frequency_subday = 1, --Once a Day
@.active_start_time_of_day = 220000, --10 PM
@.enabled_for_syncmgr = N'false',
@.use_ftp = N'false',
@.publication_type = 0,
@.offloadagent = N'false'
Any help?
Thanks,
Vijay
Can you check and make sure the subscribing table is empty?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Vijay" <vijay@.infosysusa.com> wrote in message
news:OEiWoNSkFHA.2852@.TK2MSFTNGP15.phx.gbl...
Hi,
I am using transaction replication and the identity column is not included
for replication.
After creating the snapshot, i manually copying the data through stored
procedure from publishing database to subscription database. Then,if we run
the distribution agent,i am getting the following error. what will be the
process involved in applying the initial snapshot since i have already
copied the data. Will SQL server do bcp again? How can i avoid it?
Error Message: The process could not bulk copy into table '"hsassbtr"'.
Error Details:
Numeric value out of range
(Source: INFOSYS6 (ODBC); Error number: 22003)
Numeric value out of range
(Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
Unexpected EOF encountered in BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
key in object 'hsassbtr'.
(Source: INFOSYS6 (Data source); Error number: 2627)
Aritcle is added as follows:
--added all the columns
exec sp_articlecolumn @.publication = 'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = NULL,
@.operation = N'add',
@.force_invalidate_snapshot = 1
--dropped identity('DEX_ROW_ID') columns
exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = N'DEX_ROW_ID',
@.operation = N'drop',
@.force_invalidate_snapshot = 1
I have created the subscription as follows:
exec sp_addpullsubscription
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.independent_agent = N'true',
@.subscription_type = N'anonymous',
@.description = N'InfoSys POC Setup Table Publication',
@.update_mode = N'read only',
@.immediate_sync = 1
exec sp_addpullsubscription_agent
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.distributor = @.distributor,
@.subscriber_security_mode = @.security_mode,
@.distributor_security_mode = @.security_mode,
@.frequency_type = 8, --Weekly
@.frequency_interval = 1, --Sunday
@.frequency_recurrence_factor = 1, --Every Week
@.frequency_subday = 1, --Once a Day
@.active_start_time_of_day = 220000, --10 PM
@.enabled_for_syncmgr = N'false',
@.use_ftp = N'false',
@.publication_type = 0,
@.offloadagent = N'false'
Any help?
Thanks,
Vijay
|||Vyas,
Subscribing table has data because i have manually copied the data through
stored procedure from Publising database.
Thanks,
Vijay
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OFnpAcSkFHA.3256@.TK2MSFTNGP12.phx.gbl...
> Can you check and make sure the subscribing table is empty?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:OEiWoNSkFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am using transaction replication and the identity column is not
included
> for replication.
> After creating the snapshot, i manually copying the data through stored
> procedure from publishing database to subscription database. Then,if we
run
> the distribution agent,i am getting the following error. what will be the
> process involved in applying the initial snapshot since i have already
> copied the data. Will SQL server do bcp again? How can i avoid it?
>
> Error Message: The process could not bulk copy into table '"hsassbtr"'.
> Error Details:
> Numeric value out of range
> (Source: INFOSYS6 (ODBC); Error number: 22003)
> ----
--
> --
> Numeric value out of range
> (Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
> ----
--
> --
> Unexpected EOF encountered in BCP data-file
> (Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
> ----
--
> --
> Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
> key in object 'hsassbtr'.
> (Source: INFOSYS6 (Data source); Error number: 2627)
> ----
--
> --
> Aritcle is added as follows:
> --added all the columns
> exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
> @.article = @.table_name,
> @.column = NULL,
> @.operation = N'add',
> @.force_invalidate_snapshot = 1
> --dropped identity('DEX_ROW_ID') columns
> exec sp_articlecolumn @.publication =
> 'InfoSys_Point_of_Care_Master_Tables',
> @.article = @.table_name,
> @.column = N'DEX_ROW_ID',
> @.operation = N'drop',
> @.force_invalidate_snapshot = 1
>
> I have created the subscription as follows:
> exec sp_addpullsubscription
> @.publisher = @.publisher,
> @.publisher_db = @.publisher_db,
> @.publication = N'InfoSys_Point_of_Care_Master_Tables',
> @.independent_agent = N'true',
> @.subscription_type = N'anonymous',
> @.description = N'InfoSys POC Setup Table Publication',
> @.update_mode = N'read only',
> @.immediate_sync = 1
> exec sp_addpullsubscription_agent
> @.publisher = @.publisher,
> @.publisher_db = @.publisher_db,
> @.publication = N'InfoSys_Point_of_Care_Master_Tables',
> @.distributor = @.distributor,
> @.subscriber_security_mode = @.security_mode,
> @.distributor_security_mode = @.security_mode,
> @.frequency_type = 8, --Weekly
> @.frequency_interval = 1, --Sunday
> @.frequency_recurrence_factor = 1, --Every Week
> @.frequency_subday = 1, --Once a Day
> @.active_start_time_of_day = 220000, --10 PM
> @.enabled_for_syncmgr = N'false',
> @.use_ftp = N'false',
> @.publication_type = 0,
> @.offloadagent = N'false'
> Any help?
>
> Thanks,
> Vijay
>
>
|||Why did you copy data manually, when you are configuring replication with
automatic sync?
You should either subscrine with nosync option or delete the data from
subscriber before the snapshot is applied (if the snapshot is not configure
to truncate/delete table).
If there are any special requirements for this subscriber, pelase post the
complete info, and someone will be able to assist.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Vijay" <vijay@.infosysusa.com> wrote in message
news:uHJ%23ZgSkFHA.708@.TK2MSFTNGP09.phx.gbl...
> Vyas,
> Subscribing table has data because i have manually copied the data through
> stored procedure from Publising database.
> Thanks,
> Vijay
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OFnpAcSkFHA.3256@.TK2MSFTNGP12.phx.gbl...
> included
> run
> --
> --
> --
> --
> 'InfoSys_Point_of_Care_Master_Tables',
>
I am using transaction replication and the identity column is not included
for replication.
After creating the snapshot, i manually copying the data through stored
procedure from publishing database to subscription database. Then,if we run
the distribution agent,i am getting the following error. what will be the
process involved in applying the initial snapshot since i have already
copied the data. Will SQL server do bcp again? How can i avoid it?
Error Message: The process could not bulk copy into table '"hsassbtr"'.
Error Details:
Numeric value out of range
(Source: INFOSYS6 (ODBC); Error number: 22003)
Numeric value out of range
(Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
Unexpected EOF encountered in BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
key in object 'hsassbtr'.
(Source: INFOSYS6 (Data source); Error number: 2627)
Aritcle is added as follows:
--added all the columns
exec sp_articlecolumn @.publication = 'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = NULL,
@.operation = N'add',
@.force_invalidate_snapshot = 1
--dropped identity('DEX_ROW_ID') columns
exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = N'DEX_ROW_ID',
@.operation = N'drop',
@.force_invalidate_snapshot = 1
I have created the subscription as follows:
exec sp_addpullsubscription
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.independent_agent = N'true',
@.subscription_type = N'anonymous',
@.description = N'InfoSys POC Setup Table Publication',
@.update_mode = N'read only',
@.immediate_sync = 1
exec sp_addpullsubscription_agent
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.distributor = @.distributor,
@.subscriber_security_mode = @.security_mode,
@.distributor_security_mode = @.security_mode,
@.frequency_type = 8, --Weekly
@.frequency_interval = 1, --Sunday
@.frequency_recurrence_factor = 1, --Every Week
@.frequency_subday = 1, --Once a Day
@.active_start_time_of_day = 220000, --10 PM
@.enabled_for_syncmgr = N'false',
@.use_ftp = N'false',
@.publication_type = 0,
@.offloadagent = N'false'
Any help?
Thanks,
Vijay
Can you check and make sure the subscribing table is empty?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Vijay" <vijay@.infosysusa.com> wrote in message
news:OEiWoNSkFHA.2852@.TK2MSFTNGP15.phx.gbl...
Hi,
I am using transaction replication and the identity column is not included
for replication.
After creating the snapshot, i manually copying the data through stored
procedure from publishing database to subscription database. Then,if we run
the distribution agent,i am getting the following error. what will be the
process involved in applying the initial snapshot since i have already
copied the data. Will SQL server do bcp again? How can i avoid it?
Error Message: The process could not bulk copy into table '"hsassbtr"'.
Error Details:
Numeric value out of range
(Source: INFOSYS6 (ODBC); Error number: 22003)
Numeric value out of range
(Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
Unexpected EOF encountered in BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
key in object 'hsassbtr'.
(Source: INFOSYS6 (Data source); Error number: 2627)
Aritcle is added as follows:
--added all the columns
exec sp_articlecolumn @.publication = 'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = NULL,
@.operation = N'add',
@.force_invalidate_snapshot = 1
--dropped identity('DEX_ROW_ID') columns
exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
@.article = @.table_name,
@.column = N'DEX_ROW_ID',
@.operation = N'drop',
@.force_invalidate_snapshot = 1
I have created the subscription as follows:
exec sp_addpullsubscription
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.independent_agent = N'true',
@.subscription_type = N'anonymous',
@.description = N'InfoSys POC Setup Table Publication',
@.update_mode = N'read only',
@.immediate_sync = 1
exec sp_addpullsubscription_agent
@.publisher = @.publisher,
@.publisher_db = @.publisher_db,
@.publication = N'InfoSys_Point_of_Care_Master_Tables',
@.distributor = @.distributor,
@.subscriber_security_mode = @.security_mode,
@.distributor_security_mode = @.security_mode,
@.frequency_type = 8, --Weekly
@.frequency_interval = 1, --Sunday
@.frequency_recurrence_factor = 1, --Every Week
@.frequency_subday = 1, --Once a Day
@.active_start_time_of_day = 220000, --10 PM
@.enabled_for_syncmgr = N'false',
@.use_ftp = N'false',
@.publication_type = 0,
@.offloadagent = N'false'
Any help?
Thanks,
Vijay
|||Vyas,
Subscribing table has data because i have manually copied the data through
stored procedure from Publising database.
Thanks,
Vijay
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OFnpAcSkFHA.3256@.TK2MSFTNGP12.phx.gbl...
> Can you check and make sure the subscribing table is empty?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Vijay" <vijay@.infosysusa.com> wrote in message
> news:OEiWoNSkFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am using transaction replication and the identity column is not
included
> for replication.
> After creating the snapshot, i manually copying the data through stored
> procedure from publishing database to subscription database. Then,if we
run
> the distribution agent,i am getting the following error. what will be the
> process involved in applying the initial snapshot since i have already
> copied the data. Will SQL server do bcp again? How can i avoid it?
>
> Error Message: The process could not bulk copy into table '"hsassbtr"'.
> Error Details:
> Numeric value out of range
> (Source: INFOSYS6 (ODBC); Error number: 22003)
> ----
--
> --
> Numeric value out of range
> (Source: ODBC SQL Server Driver (ODBC); Error number: 22003)
> ----
--
> --
> Unexpected EOF encountered in BCP data-file
> (Source: ODBC SQL Server Driver (ODBC); Error number: S1000)
> ----
--
> --
> Violation of PRIMARY KEY constraint 'PKhsassbtr'. Cannot insert duplicate
> key in object 'hsassbtr'.
> (Source: INFOSYS6 (Data source); Error number: 2627)
> ----
--
> --
> Aritcle is added as follows:
> --added all the columns
> exec sp_articlecolumn @.publication =
'InfoSys_Point_of_Care_Master_Tables',
> @.article = @.table_name,
> @.column = NULL,
> @.operation = N'add',
> @.force_invalidate_snapshot = 1
> --dropped identity('DEX_ROW_ID') columns
> exec sp_articlecolumn @.publication =
> 'InfoSys_Point_of_Care_Master_Tables',
> @.article = @.table_name,
> @.column = N'DEX_ROW_ID',
> @.operation = N'drop',
> @.force_invalidate_snapshot = 1
>
> I have created the subscription as follows:
> exec sp_addpullsubscription
> @.publisher = @.publisher,
> @.publisher_db = @.publisher_db,
> @.publication = N'InfoSys_Point_of_Care_Master_Tables',
> @.independent_agent = N'true',
> @.subscription_type = N'anonymous',
> @.description = N'InfoSys POC Setup Table Publication',
> @.update_mode = N'read only',
> @.immediate_sync = 1
> exec sp_addpullsubscription_agent
> @.publisher = @.publisher,
> @.publisher_db = @.publisher_db,
> @.publication = N'InfoSys_Point_of_Care_Master_Tables',
> @.distributor = @.distributor,
> @.subscriber_security_mode = @.security_mode,
> @.distributor_security_mode = @.security_mode,
> @.frequency_type = 8, --Weekly
> @.frequency_interval = 1, --Sunday
> @.frequency_recurrence_factor = 1, --Every Week
> @.frequency_subday = 1, --Once a Day
> @.active_start_time_of_day = 220000, --10 PM
> @.enabled_for_syncmgr = N'false',
> @.use_ftp = N'false',
> @.publication_type = 0,
> @.offloadagent = N'false'
> Any help?
>
> Thanks,
> Vijay
>
>
|||Why did you copy data manually, when you are configuring replication with
automatic sync?
You should either subscrine with nosync option or delete the data from
subscriber before the snapshot is applied (if the snapshot is not configure
to truncate/delete table).
If there are any special requirements for this subscriber, pelase post the
complete info, and someone will be able to assist.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Vijay" <vijay@.infosysusa.com> wrote in message
news:uHJ%23ZgSkFHA.708@.TK2MSFTNGP09.phx.gbl...
> Vyas,
> Subscribing table has data because i have manually copied the data through
> stored procedure from Publising database.
> Thanks,
> Vijay
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OFnpAcSkFHA.3256@.TK2MSFTNGP12.phx.gbl...
> included
> run
> --
> --
> --
> --
> 'InfoSys_Point_of_Care_Master_Tables',
>
Monday, March 12, 2012
Possible to setup SQL Mail w/o installing Outlook?
I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
mail
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;263556
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315886
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> > I just installed Windows 2003 Server and SQL Server 2000. I would like
to
> > use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a
> > profile in Outlook.
> >
> > Is it possible to setup SQL Server Mail services without installing
> Outlook?
> > I remember in NT there was a mail icon in the Control Panel, this isn't
> > there anymore in 2003.
> >
> > Thanks
> > ckaneko
> >
> >
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
Possible to setup SQL Mail w/o installing Outlook?
I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckaneko
You don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/default...b;en-us;263556
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to use a MAPI client and you only need to send mail take a look at xpsmtp. http://sqldev.net/xp/xpsmtp.htm
|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/default...;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.[vbcol=seagreen]
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
> Outlook?
>
|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
Possible to setup SQL Mail w/o installing Outlook?
I just installed Windows 2003 Server and SQL Server 2000. I would like to
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
profile in Outlook.
Is it possible to setup SQL Server Mail services without installing Outlook?
I remember in NT there was a mail icon in the Control Panel, this isn't
there anymore in 2003.
Thanks
ckanekoYou don't have to have Exchange, but it is my understanding to set up SQL
Mail you need have the Outlook client installed so you can create a mail
profile. Here is an article that might help:
http://support.microsoft.com/defaul...kb;en-us;263556
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||Yes, you still need to install a MAPI client (eg Outlook 2003). If you don't wish to u
se a MAPI client and you only need to send mail take a look at xpsmtp. dev.net/xp/xpsmtp.htm" target="_blank">http://sql
dev.net/xp/xpsmtp.htm|||Ive found that Outlook XP and 2003 wont work because they prompt the user
"Another application is trying to send email on behalf of you...do you want
to allow?" Maybe someone knows a way around this? So...I use Outlook 2000.
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message
news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing
Outlook?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>|||It's possible to get around this with the help of your Exchange
administrator (there's a link in the KB below)
INF: Common SQL Mail Problems
http://support.microsoft.com/defaul...b;en-us;Q315886
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JL Morrison" <jl_morrison@.hotmail.com> wrote in message
news:e9cVW%23dSEHA.3552@.TK2MSFTNGP09.phx.gbl...
> Ive found that Outlook XP and 2003 wont work because they prompt the user
> "Another application is trying to send email on behalf of you...do you
want
> to allow?" Maybe someone knows a way around this? So...I use Outlook
2000.
> "ckaneko" <ckaneko@.ffi-hq.com> wrote in message
> news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
mail[vbcol=seagreen]
> Outlook?
>|||Some options:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ckaneko" <ckaneko@.ffi-hq.com> wrote in message news:OoPd13bSEHA.2716@.tk2msftngp13.phx.gbl..
.
> I just installed Windows 2003 Server and SQL Server 2000. I would like to
> use SQL Mail. We had did this on our WinNt/SQL 7 boxes by creating a mail
> profile in Outlook.
> Is it possible to setup SQL Server Mail services without installing Outloo
k?
> I remember in NT there was a mail icon in the Control Panel, this isn't
> there anymore in 2003.
> Thanks
> ckaneko
>
Monday, February 20, 2012
Possibility of creating multiple join between two tables
Pls could someone help me out on the downside of creating two or more join relationships between two tables in a database and in business objects universe creation. Is it really ok and possible to create more than one join?
Thanks a lot .
Olusoga
Systems Analyst
If you mean that you want to have more than one column in the relationship, the answer is yes. That possible in SQL Server and very common as PK can contain more than one column. I doubt that this is not supported in any OR mapper like Business Objects.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Positive Pay Files in SSRS
I have been tasked with creating a Positive Pay (also known as Safe Pay) file
using SSRS. I was wondering if anyone here has had any experience doing this
or has any idea on the feasibility of this project. I am specifically
wondering whether SSRS is suitable for this type of task.
Thanks
Zack GallingerFirst, I haven't ever heard of Positive Pay so I googled it:"Positive Pay Is
a Way To Successfully Combat Check Fraud
Banks and large businesses are protecting themselves and are promoting a
technique called positive pay as a method of fighting check fraud artists.
Generally speaking, positive pay works like this:
a.. 1. Using accounting and database software, a company regularly sends
its bank a positive pay file that lists all the checks written against that
company's account(s). That file includes a record of each check's issue
date, amount, check number/account and payee name.
b.. 2. When a check reaches the bank for payment, the bank compares the
check against the positive pay file. Any discrepancies in a check's
information trigger a flag that the check in question may have been altered.
c.. 3. The bank notifies its corporate customer that the discrepancy has
been noted and asks the company to verify the authenticity of that check. "
Assuming you can create the query that gets the data then the issue is what
format the bank wants the data. It is very easy to create a CSV file.
You might find a SSIS job would be easier if the data format is complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Zack" <Zack@.discussions.microsoft.com> wrote in mes
sage news:90685B31-1551-4F34-BF3A-A63D0DF181F5@.microsoft.com...
>I have been tasked with creating a Positive Pay (also known as Safe Pay)
>file
> using SSRS. I was wondering if anyone here has had any experience doing
> this
> or has any idea on the feasibility of this project. I am specifically
> wondering whether SSRS is suitable for this type of task.
> Thanks
> Zack Gallinger
using SSRS. I was wondering if anyone here has had any experience doing this
or has any idea on the feasibility of this project. I am specifically
wondering whether SSRS is suitable for this type of task.
Thanks
Zack GallingerFirst, I haven't ever heard of Positive Pay so I googled it:"Positive Pay Is
a Way To Successfully Combat Check Fraud
Banks and large businesses are protecting themselves and are promoting a
technique called positive pay as a method of fighting check fraud artists.
Generally speaking, positive pay works like this:
a.. 1. Using accounting and database software, a company regularly sends
its bank a positive pay file that lists all the checks written against that
company's account(s). That file includes a record of each check's issue
date, amount, check number/account and payee name.
b.. 2. When a check reaches the bank for payment, the bank compares the
check against the positive pay file. Any discrepancies in a check's
information trigger a flag that the check in question may have been altered.
c.. 3. The bank notifies its corporate customer that the discrepancy has
been noted and asks the company to verify the authenticity of that check. "
Assuming you can create the query that gets the data then the issue is what
format the bank wants the data. It is very easy to create a CSV file.
You might find a SSIS job would be easier if the data format is complicated.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Zack" <Zack@.discussions.microsoft.com> wrote in mes
sage news:90685B31-1551-4F34-BF3A-A63D0DF181F5@.microsoft.com...
>I have been tasked with creating a Positive Pay (also known as Safe Pay)
>file
> using SSRS. I was wondering if anyone here has had any experience doing
> this
> or has any idea on the feasibility of this project. I am specifically
> wondering whether SSRS is suitable for this type of task.
> Thanks
> Zack Gallinger
Positioning Tables and Graphs On A Page using Rectangles (or anything!)
I am creating a report that contains several tables and graphs. The report should fit on one page. It is a dashboard type of report that gives a quick look at key information.I have several sections that have related objects - a table and a graph for the same subject. I grouped the subjects into rectangles so that I could have a nice border around each section. However, when the report is rendered in IE, the rectangles do not stay together, and I have white space between them. I tried putting a background color on the body, but the background color does not show when the report is rendered in IE.
I tried a work-around using lines, not rectangles, to separate sections. The spacing seems to be working, but again the background color is not showing on the rendered report, so that is not a viable option.
As a work-around for my work-around, I put the objects within one rectangle, again using lines to separate sections. However, the spacing of the objects within the rectangle is not working - I am left with large blank spaces again.
Has anyone run into the same problems?
TIA,
eBeth
I haven't used rectangles, but I have had luck using the table control. Even when I only needed a label and textbox, I found adding these to a table kept my data where I wanted it. This might be an option for you as well. For the report where this was the most useful I had a main table across the top, in the middle I have 3 more tables (small, 2 are single lines) spaced appropriately, and the bottom of the report has yet another table similar to the main table. I know its hard to visualize, but all the objects remain in the correct position.
Simone
|||Hi, eBeth,
See if this helps: Rendering Considerations for Automatic Sizing and Positioning .
In short, the position of report items in relation to each other influences how they behave when the report is rendered. Also, the white space on the background of the report design surface is preserved, so check that the rectangle border you create around the table & graph is not pushing the rendered report over the page boundary, and eliminate any of the white surface past the edges of your report items.
======================================
New: Search scoped to just SQL Server Books OnLine: http://search.live.com/macros/sql_server_user_education/booksonline
|||Hi,
Well, the answer seems to be trial and error with tables and other graphical elements. I have the page looking "OK," and am in the process of putting more information in tables. I now have section headings in the first table of the section, and am using tranparent rows in tables to space elements. It is not the best solution, but there it is. I read the online references; they didn't help very much. One of the main problems is that it has to look good on the web and when downloaded to Excel or PDF.
Thanks,
eBeth
Positioning Tables and Graphs On A Page using Rectangles (or anything!)
I am creating a report that contains several tables and graphs. The report should fit on one page. It is a dashboard type of report that gives a quick look at key information.I have several sections that have related objects - a table and a graph for the same subject. I grouped the subjects into rectangles so that I could have a nice border around each section. However, when the report is rendered in IE, the rectangles do not stay together, and I have white space between them. I tried putting a background color on the body, but the background color does not show when the report is rendered in IE.
I tried a work-around using lines, not rectangles, to separate sections. The spacing seems to be working, but again the background color is not showing on the rendered report, so that is not a viable option.
As a work-around for my work-around, I put the objects within one rectangle, again using lines to separate sections. However, the spacing of the objects within the rectangle is not working - I am left with large blank spaces again.
Has anyone run into the same problems?
TIA,
eBeth
I haven't used rectangles, but I have had luck using the table control. Even when I only needed a label and textbox, I found adding these to a table kept my data where I wanted it. This might be an option for you as well. For the report where this was the most useful I had a main table across the top, in the middle I have 3 more tables (small, 2 are single lines) spaced appropriately, and the bottom of the report has yet another table similar to the main table. I know its hard to visualize, but all the objects remain in the correct position.
Simone
|||Hi, eBeth,
See if this helps: Rendering Considerations for Automatic Sizing and Positioning .
In short, the position of report items in relation to each other influences how they behave when the report is rendered. Also, the white space on the background of the report design surface is preserved, so check that the rectangle border you create around the table & graph is not pushing the rendered report over the page boundary, and eliminate any of the white surface past the edges of your report items.
======================================
New: Search scoped to just SQL Server Books OnLine: http://search.live.com/macros/sql_server_user_education/booksonline
|||Hi,
Well, the answer seems to be trial and error with tables and other graphical elements. I have the page looking "OK," and am in the process of putting more information in tables. I now have section headings in the first table of the section, and am using tranparent rows in tables to space elements. It is not the best solution, but there it is. I read the online references; they didn't help very much. One of the main problems is that it has to look good on the web and when downloaded to Excel or PDF.
Thanks,
eBeth
Subscribe to:
Posts (Atom)