Adding a Linked Server

HI,

There is a requirement to transfer a table data from a oracle view to a SQL Server table. These both reside on the same box. I am trying to add the oracle instance as a linked server, like this:

EXEC sp_addlinkedserver @.server = @.SOURCE_SERVER_NAME, @.srvproduct = '', @.provider = @.PROVIDER_NAME, @.datasrc = @.DATA_SOURCE_NAME

The server gets added. But When I use this string as part of a stored procedure (or even not use it there), which does the work of transfering the data as required, I get this error:

Server: Msg 7399, Level 16, State 1, Procedure UBS_PULL_HR_DATA, Line 125
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

I have added this Name in the System DSM also. I dont know how to go about it. Can any one please help?

Thanks a lot and let me know if the question is not clear.

Mannu.

When the server gets added, check the security tab. I'm guessing it's blank as you aren't adding the login information. Error 0x80004005 is access is denied. That looks like it's one of the problems anyway. If you want to script the login for the linked server, you would use sp_addlinkedsrvlogin.

-Sue

|||

Hi Sue, Thanks for the reply. I have overcome this problem. However, I am now getting this error:

The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

Any ideas to solve this? Thanks a lot.

Mannu.

sql

Adding a Linked Server

HI,

There is a requirement to transfer a table data from a oracle view to a SQL Server table. These both reside on the same box. I am trying to add the oracle instance as a linked server, like this:

EXEC sp_addlinkedserver @.server = @.SOURCE_SERVER_NAME, @.srvproduct = '', @.provider = @.PROVIDER_NAME, @.datasrc = @.DATA_SOURCE_NAME

The server gets added. But When I use this string as part of a stored procedure (or even not use it there), which does the work of transfering the data as required, I get this error:

Server: Msg 7399, Level 16, State 1, Procedure UBS_PULL_HR_DATA, Line 125
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

I have added this Name in the System DSM also. I dont know how to go about it. Can any one please help?

Thanks a lot and let me know if the question is not clear.

Mannu.

When the server gets added, check the security tab. I'm guessing it's blank as you aren't adding the login information. Error 0x80004005 is access is denied. That looks like it's one of the problems anyway. If you want to script the login for the linked server, you would use sp_addlinkedsrvlogin.

-Sue

|||

Hi Sue, Thanks for the reply. I have overcome this problem. However, I am now getting this error:

The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

Any ideas to solve this? Thanks a lot.

Mannu.

Adding a check box to a report

I need to create a nice fomatted report in RS and part of that is checking a box if the data = Yes. Is there a way to add controlsOk try this, I spent a little time but was able to find a way to make it work with a list control,
Add the list,
Drag and drop the Image control, bring in a checked and unchecked image and have them embedded in the report. You can even have the images stacked ontop of eachother, so that they will have the same alignment in the report row for row,
Go to the properties area for the image, go to the visibilty area, and choose Expression,
I find that the expression box works a little counter intuitive, so for the unchecked/other than "yes" box do this
=Fields!YourField.Value = "Yes"
Then If the field value is = "Yes" (make sure its cased correctly) then the unchecked box will appear,
=Fields!YourField.Value <> "Yes"
Conversley have it check for if it is not equal to "Yes" and It will have the checked box appear. It seems backwards but i guess the visibility expression takes the negative or something funny, Heres a lil screen shot of what i got,...


I dont see why this couldnt work in a table or matrix control if it came to that
Happy Reporting!!

Adding 2nd instance of SQL

I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
clarify a few things for me?
1. Can this be done during productions hours - does it requre a reboot?
2. Does it actually install another full version of SQL - I only have a CD
that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
will this affect the production instance default instance)
3. Does it use a different service account to start?
4. Can it use a second bound IP address?
Any other tips I should be aware of? Thanks for your time.
Hi
"Bad Beagle" wrote:

> I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
> clarify a few things for me?
> 1. Can this be done during productions hours - does it requre a reboot?
It should not require a re-boot, but it would not be a good idea to do it on
a production server whilst it is being used.

> 2. Does it actually install another full version of SQL - I only have a CD
> that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
> will this affect the production instance default instance)
Yes you would need to apply a service pack separately.

> 3. Does it use a different service account to start?
This is however you configure it, the can be the same if required.

> 4. Can it use a second bound IP address?
You could do this via a firewall and filter on tcp/ip ports or possibly by
using the TCP/IP filtering in the advanced options of the network connection.
> Any other tips I should be aware of? Thanks for your time.
>
>
Having a second instance will use resources on this machine, you should not
(really) have a second instance on a production server if you can avoid it,
and certainly test/development instances should be kept separate.
John
|||Hello,
Thank you for posting. Also, thanks very much to John for his contribution.
It seems that John has essentially answered all the questions appropriately.
You can install the instance without re-booting the system. Application of
SP4 does require a reboot. I would also recommend that, regardless, you do
reboot the system simply to refresh services and what not. You can
install the instance followed by SP4 then reboot.
My understanding is that the root of this question is "Can you do the
installation on a production server while it is being used?" While it
should work without issue, there are a number of reasons not to attempt
this. First, if something does go wrong, you may unexpectedly bring down
your production server while people are using it, thus potentially losing
data and incurring user and executive wrath: something we all generally
want to avoid. Secondly, and particularly with SP updates, installations
have been known to fail silently and return a successful message without
properly updating services. It's very much recommended to do any such type
of major administration while the database is not being accessed.
You can configure the service account either during the installation of the
SQL Server, or you can update it later through SQL Enterprise manager. As
John mentioned, you can set it to a different account or the same account
depending on your requirements.
You can bind each instance that you install to a separate port, but you can
not specify an IP address for each instance. Instead, the port for the
TCP/IP network protocal is dynamically configured during installation. As
John suggests you can manage this using NAT at your Router/Firewall. To
check/change the port for the instance, you can open SQL Enterprise Manger,
Right click the instance you want to change, select Properties > Network
Configuration... > TCP/IP > Properties...
John also brings up a very good point about the performance implications of
running an extra instance on a production server. Basically, when you add
an instance, all the following are replicated, taking up additional
resources:

> SQL Server database engine
> System and user databases.
> The SQL Server and SQL Server Agent services.
> The registry keys associated with the database engine and the SQL Server
and SQL Server Agent services.
> Network connection addresses
(*see:
http://msdn.microsoft.com/library/de...us/architec/8_
ar_cs_9i5u.asp)
Please also review the BOL section on 'multiple instance of SQL Server' in
the index for BOL. See particularly the sections "best practices', 'memory
usage', and 'when to use' to better determine if installing separate
instances is actually in your best interest.
Hope this helps!
Sincerely,
Dana Brash [MSFT]
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>
|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>
|||Hi,
Just a followup on this post. I am wondering if you have any questions or
concerns about this issue. If you need further assistance, please do not
hesitate to let me know.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>

Adding 2nd instance of SQL

I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
clarify a few things for me?
1. Can this be done during productions hours - does it requre a reboot?
2. Does it actually install another full version of SQL - I only have a CD
that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
will this affect the production instance default instance)
3. Does it use a different service account to start?
4. Can it use a second bound IP address?
Any other tips I should be aware of? Thanks for your time.Hi
"Bad Beagle" wrote:
> I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
> clarify a few things for me?
> 1. Can this be done during productions hours - does it requre a reboot?
It should not require a re-boot, but it would not be a good idea to do it on
a production server whilst it is being used.
> 2. Does it actually install another full version of SQL - I only have a CD
> that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
> will this affect the production instance default instance)
Yes you would need to apply a service pack separately.
> 3. Does it use a different service account to start?
This is however you configure it, the can be the same if required.
> 4. Can it use a second bound IP address?
You could do this via a firewall and filter on tcp/ip ports or possibly by
using the TCP/IP filtering in the advanced options of the network connection.
> Any other tips I should be aware of? Thanks for your time.
>
>
Having a second instance will use resources on this machine, you should not
(really) have a second instance on a production server if you can avoid it,
and certainly test/development instances should be kept separate.
John|||Hello,
Thank you for posting. Also, thanks very much to John for his contribution.
It seems that John has essentially answered all the questions appropriately.
You can install the instance without re-booting the system. Application of
SP4 does require a reboot. I would also recommend that, regardless, you do
reboot the system simply to refresh services and what not. You can
install the instance followed by SP4 then reboot.
My understanding is that the root of this question is "Can you do the
installation on a production server while it is being used?" While it
should work without issue, there are a number of reasons not to attempt
this. First, if something does go wrong, you may unexpectedly bring down
your production server while people are using it, thus potentially losing
data and incurring user and executive wrath: something we all generally
want to avoid. Secondly, and particularly with SP updates, installations
have been known to fail silently and return a successful message without
properly updating services. It's very much recommended to do any such type
of major administration while the database is not being accessed.
You can configure the service account either during the installation of the
SQL Server, or you can update it later through SQL Enterprise manager. As
John mentioned, you can set it to a different account or the same account
depending on your requirements.
You can bind each instance that you install to a separate port, but you can
not specify an IP address for each instance. Instead, the port for the
TCP/IP network protocal is dynamically configured during installation. As
John suggests you can manage this using NAT at your Router/Firewall. To
check/change the port for the instance, you can open SQL Enterprise Manger,
Right click the instance you want to change, select Properties > Network
Configuration... > TCP/IP > Properties...
John also brings up a very good point about the performance implications of
running an extra instance on a production server. Basically, when you add
an instance, all the following are replicated, taking up additional
resources:
> SQL Server database engine
> System and user databases.
> The SQL Server and SQL Server Agent services.
> The registry keys associated with the database engine and the SQL Server
and SQL Server Agent services.
> Network connection addresses
(*see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_cs_9i5u.asp)
Please also review the BOL section on 'multiple instance of SQL Server' in
the index for BOL. See particularly the sections "best practices', 'memory
usage', and 'when to use' to better determine if installing separate
instances is actually in your best interest.
Hope this helps!
Sincerely,
Dana Brash [MSFT]
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just a followup on this post. I am wondering if you have any questions or
concerns about this issue. If you need further assistance, please do not
hesitate to let me know.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>

Adding 2nd instance of SQL

I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
clarify a few things for me?
1. Can this be done during productions hours - does it requre a reboot?
2. Does it actually install another full version of SQL - I only have a CD
that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
will this affect the production instance default instance)
3. Does it use a different service account to start?
4. Can it use a second bound IP address?
Any other tips I should be aware of? Thanks for your time.Hi
"Bad Beagle" wrote:

> I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
> clarify a few things for me?
> 1. Can this be done during productions hours - does it requre a reboot?
It should not require a re-boot, but it would not be a good idea to do it on
a production server whilst it is being used.

> 2. Does it actually install another full version of SQL - I only have a C
D
> that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
> will this affect the production instance default instance)
Yes you would need to apply a service pack separately.

> 3. Does it use a different service account to start?
This is however you configure it, the can be the same if required.

> 4. Can it use a second bound IP address?
You could do this via a firewall and filter on tcp/ip ports or possibly by
using the TCP/IP filtering in the advanced options of the network connection.">
> Any other tips I should be aware of? Thanks for your time.
>
>
Having a second instance will use resources on this machine, you should not
(really) have a second instance on a production server if you can avoid it,
and certainly test/development instances should be kept separate.
John|||Hello,
Thank you for posting. Also, thanks very much to John for his contribution.
It seems that John has essentially answered all the questions appropriately.
You can install the instance without re-booting the system. Application of
SP4 does require a reboot. I would also recommend that, regardless, you do
reboot the system simply to refresh services and what not. You can
install the instance followed by SP4 then reboot.
My understanding is that the root of this question is "Can you do the
installation on a production server while it is being used?" While it
should work without issue, there are a number of reasons not to attempt
this. First, if something does go wrong, you may unexpectedly bring down
your production server while people are using it, thus potentially losing
data and incurring user and executive wrath: something we all generally
want to avoid. Secondly, and particularly with SP updates, installations
have been known to fail silently and return a successful message without
properly updating services. It's very much recommended to do any such type
of major administration while the database is not being accessed.
You can configure the service account either during the installation of the
SQL Server, or you can update it later through SQL Enterprise manager. As
John mentioned, you can set it to a different account or the same account
depending on your requirements.
You can bind each instance that you install to a separate port, but you can
not specify an IP address for each instance. Instead, the port for the
TCP/IP network protocal is dynamically configured during installation. As
John suggests you can manage this using NAT at your Router/Firewall. To
check/change the port for the instance, you can open SQL Enterprise Manger,
Right click the instance you want to change, select Properties > Network
Configuration... > TCP/IP > Properties...
John also brings up a very good point about the performance implications of
running an extra instance on a production server. Basically, when you add
an instance, all the following are replicated, taking up additional
resources:

> SQL Server database engine
> System and user databases.
> The SQL Server and SQL Server Agent services.
> The registry keys associated with the database engine and the SQL Server
and SQL Server Agent services.
> Network connection addresses
(*see:
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_cs_9i5u.asp)
Please also review the BOL section on 'multiple instance of SQL Server' in
the index for BOL. See particularly the sections "best practices', 'memory
usage', and 'when to use' to better determine if installing separate
instances is actually in your best interest.
Hope this helps!
Sincerely,
Dana Brash [MSFT]
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. It is my pleasure to be of
assistance.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>|||Hi,
Just a followup on this post. I am wondering if you have any questions or
concerns about this issue. If you need further assistance, please do not
hesitate to let me know.
Hope this helps!
Sincerely,
Dana Brash
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Bad Beagle" <maxwelli@.nospam.postalias>
>Subject: Adding 2nd instance of SQL
>Date: Fri, 13 Jan 2006 07:29:45 -0700
>Lines: 12
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <eScgO3EGGHA.3944@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 199.213.91.1
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:417520
>X-Tomcat-NG: microsoft.public.sqlserver.server
>I am adding a 2nd instance of SQL on a SQL SP4 box. Can someone please
>clarify a few things for me?
>1. Can this be done during productions hours - does it requre a reboot?
>2. Does it actually install another full version of SQL - I only have a
CD
>that has SQL 2000 on it so I would have to apply the SP 4 after the fact -
>will this affect the production instance default instance)
>3. Does it use a different service account to start?
>4. Can it use a second bound IP address?
>Any other tips I should be aware of? Thanks for your time.
>
>sql

Add Version to Custom Report

Hello
Has anybody found a good way to add version control to a report? I could
add a text box to the report and enter Version:20060927. Because this is a
manual operation some developers may forget and it will become unreliable.
If someone found a better way please let me know.
Thanks
Johnuse Globals!ExecutionTime expression. It will display the date and time
when the report is generated. Playing around with it will help you produce
what you wanted.
hth,
"John A Kushwarra" <jkushwarra@.empire.edu> wrote in message
news:uMVVWyj4GHA.4352@.TK2MSFTNGP03.phx.gbl...
> Hello
> Has anybody found a good way to add version control to a report? I could
> add a text box to the report and enter Version:20060927. Because this is
> a manual operation some developers may forget and it will become
> unreliable. If someone found a better way please let me know.
> Thanks
> John
>sql

Add Titles to columns in a matrix report

I have a matrix report and it doesn't add titles to the different groupings. And when you try and add a text box it spans across all grouping columns. How do you add titles to these columns?

Cheers
Damien

When you use a matrix, the titles for the column groups are going to be the values specified in that group. For example, if you group the columns by State, then you will have each state listed at the top of each column.

I'm not sure of any way to add an extra row at the top of a matrix for a title. However, if nothing else, you could add a textbox right before the matrix to add a title. The only problem is this wouldn't be displayed on each page.

|||In a matrix report I need a way to provide titles for the groupings not the detail listings. There doesn't appear to be a way to do this in reporting services 2005?

Add replication component

Hello,
I have a publication that is pushed from a SQL 2005 Standard box to
about 40 SQL express subscribers. One of the servers went down and was
rebuild and I reran the same install script as I ran on the other
servers ( I made the script). I pushed out the same subscription as
before to it, and it is running smoothly (transactional). I then
needed to set up a snapshot subscription to all servers, and this
server was the only one that would not allow me to. When I try and set
up a new subscription to it I get this message:
"Replication components are not installed on this server. Run SQL
Server SETUP again and select the option to install replication.
(Microsoft SQL Server, Error: 21028).
So I thought I would just redo the setup and only pick the replication
component, but you cant, it makes you pick the whole database engine
tree to get it, and then the install says that it is already installed
and won't let you continue. Same happens if I go through add/remove
programs and use the add component link.
Any thoughts or ideas on this error. Right now the only solution I
have is reinstall from scratch.
OK, that error message was totally wrong. Since adding it through the
UI was not working, I added another subscription through the UI and at
the end generated a script file instead of actually finishing it. I
then changed the script file to point at my stubborn server that
supposedly did not have replication components, and the script ran fine
and the subscription was created, and worked.
PT
|||Can you try to create a local publication on this server? I am not sure if
this message is erroneous or not.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul T." <weluvpaul@.hotmail.com> wrote in message
news:1168454660.767978.320110@.p59g2000hsd.googlegr oups.com...
> Hello,
> I have a publication that is pushed from a SQL 2005 Standard box to
> about 40 SQL express subscribers. One of the servers went down and was
> rebuild and I reran the same install script as I ran on the other
> servers ( I made the script). I pushed out the same subscription as
> before to it, and it is running smoothly (transactional). I then
> needed to set up a snapshot subscription to all servers, and this
> server was the only one that would not allow me to. When I try and set
> up a new subscription to it I get this message:
> "Replication components are not installed on this server. Run SQL
> Server SETUP again and select the option to install replication.
> (Microsoft SQL Server, Error: 21028).
> So I thought I would just redo the setup and only pick the replication
> component, but you cant, it makes you pick the whole database engine
> tree to get it, and then the install says that it is already installed
> and won't let you continue. Same happens if I go through add/remove
> programs and use the add component link.
> Any thoughts or ideas on this error. Right now the only solution I
> have is reinstall from scratch.
>

add an sql 2000 instance to a production server

Hi,
If I add an sql 2000 instance to a existing prod sql box used as a
developping sql instance.
The developers don't need to tough the production box..
Is it feasible? it will reduce the production performance?
What's the side effect?
What about creating a virtual server -- 2-3 virtual sql servers in a one
physical box.
Thanksmecn wrote:
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
Don't do that. Production and developing (or test) environment should be
separated. Separation means that there is no influence between them.
Unfortunately, when two instances are installed on the same server, one
instance can easily affect performance of other instance.
> What's the side effect?
When you add another (dev) instance, it will use common system
resources. Dev instance will consume RAM memory potentially available
for prod instance, it will also utilize processor(s) and IO.
IMHO it's a risky move.
> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
Better idea, because virtualization introduces much higher separation
level, but I think that's still not enough. Let production SQL Server
work on dedicated machine.
Best regards,
Marcin Guzowski
http://guzowski.info|||Thanks. I got it.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ufol$grr$1@.news.onet.pl...
> mecn wrote:
>> Hi,
>> If I add an sql 2000 instance to a existing prod sql box used as a
>> developping sql instance.
>> The developers don't need to tough the production box..
>> Is it feasible? it will reduce the production performance?
> Don't do that. Production and developing (or test) environment should be
> separated. Separation means that there is no influence between them.
> Unfortunately, when two instances are installed on the same server, one
> instance can easily affect performance of other instance.
>> What's the side effect?
> When you add another (dev) instance, it will use common system resources.
> Dev instance will consume RAM memory potentially available for prod
> instance, it will also utilize processor(s) and IO.
> IMHO it's a risky move.
>> What about creating a virtual server -- 2-3 virtual sql servers in a one
>> physical box.
> Better idea, because virtualization introduces much higher separation
> level, but I think that's still not enough. Let production SQL Server work
> on dedicated machine.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info|||Do I need more sql licenses for virtual servers
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uWMC86OuHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
> What's the side effect?
> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
> Thanks
>|||mecn wrote:
> Do I need more sql licenses for virtual servers
I don't know if it is true for SQL Server 2000 (probably not), but in
SQL Server 2005 it depends on SQL Server version (edition). If you have
SQL Server 2005 Enterprise Edition, you don't need additional licenses
for each virtual server.
In other cases, you must buy new licenses.
Best regards,
Marcin Guzowski
http://guzowski.info|||Thanks a lot dfor your help!!
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ui6o$pu8$1@.news.onet.pl...
> mecn wrote:
>> Do I need more sql licenses for virtual servers
> I don't know if it is true for SQL Server 2000 (probably not), but in SQL
> Server 2005 it depends on SQL Server version (edition). If you have SQL
> Server 2005 Enterprise Edition, you don't need additional licenses for
> each virtual server.
> In other cases, you must buy new licenses.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

add an sql 2000 instance to a production server

Hi,
If I add an sql 2000 instance to a existing prod sql box used as a
developping sql instance.
The developers don't need to tough the production box..
Is it feasible? it will reduce the production performance?
What's the side effect?
What about creating a virtual server -- 2-3 virtual sql servers in a one
physical box.
Thanks
mecn wrote:
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
Don't do that. Production and developing (or test) environment should be
separated. Separation means that there is no influence between them.
Unfortunately, when two instances are installed on the same server, one
instance can easily affect performance of other instance.

> What's the side effect?
When you add another (dev) instance, it will use common system
resources. Dev instance will consume RAM memory potentially available
for prod instance, it will also utilize processor(s) and IO.
IMHO it's a risky move.

> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
Better idea, because virtualization introduces much higher separation
level, but I think that's still not enough. Let production SQL Server
work on dedicated machine.
Best regards,
Marcin Guzowski
http://guzowski.info
|||Thanks. I got it.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ufol$grr$1@.news.onet.pl...
> mecn wrote:
> Don't do that. Production and developing (or test) environment should be
> separated. Separation means that there is no influence between them.
> Unfortunately, when two instances are installed on the same server, one
> instance can easily affect performance of other instance.
>
> When you add another (dev) instance, it will use common system resources.
> Dev instance will consume RAM memory potentially available for prod
> instance, it will also utilize processor(s) and IO.
> IMHO it's a risky move.
>
> Better idea, because virtualization introduces much higher separation
> level, but I think that's still not enough. Let production SQL Server work
> on dedicated machine.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info
|||Do I need more sql licenses for virtual servers
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uWMC86OuHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
> What's the side effect?
> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
> Thanks
>
|||mecn wrote:
> Do I need more sql licenses for virtual servers
I don't know if it is true for SQL Server 2000 (probably not), but in
SQL Server 2005 it depends on SQL Server version (edition). If you have
SQL Server 2005 Enterprise Edition, you don't need additional licenses
for each virtual server.
In other cases, you must buy new licenses.
Best regards,
Marcin Guzowski
http://guzowski.info
|||Thanks a lot dfor your help!!
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ui6o$pu8$1@.news.onet.pl...
> mecn wrote:
> I don't know if it is true for SQL Server 2000 (probably not), but in SQL
> Server 2005 it depends on SQL Server version (edition). If you have SQL
> Server 2005 Enterprise Edition, you don't need additional licenses for
> each virtual server.
> In other cases, you must buy new licenses.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

add an sql 2000 instance to a production server

Hi,
If I add an sql 2000 instance to a existing prod sql box used as a
developping sql instance.
The developers don't need to tough the production box..
Is it feasible? it will reduce the production performance?
What's the side effect?
What about creating a virtual server -- 2-3 virtual sql servers in a one
physical box.
Thanksmecn wrote:
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
Don't do that. Production and developing (or test) environment should be
separated. Separation means that there is no influence between them.
Unfortunately, when two instances are installed on the same server, one
instance can easily affect performance of other instance.

> What's the side effect?
When you add another (dev) instance, it will use common system
resources. Dev instance will consume RAM memory potentially available
for prod instance, it will also utilize processor(s) and IO.
IMHO it's a risky move.

> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
Better idea, because virtualization introduces much higher separation
level, but I think that's still not enough. Let production SQL Server
work on dedicated machine.
Best regards,
Marcin Guzowski
http://guzowski.info|||Thanks. I got it.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ufol$grr$1@.news.onet.pl...
> mecn wrote:
> Don't do that. Production and developing (or test) environment should be
> separated. Separation means that there is no influence between them.
> Unfortunately, when two instances are installed on the same server, one
> instance can easily affect performance of other instance.
>
> When you add another (dev) instance, it will use common system resources.
> Dev instance will consume RAM memory potentially available for prod
> instance, it will also utilize processor(s) and IO.
> IMHO it's a risky move.
>
> Better idea, because virtualization introduces much higher separation
> level, but I think that's still not enough. Let production SQL Server work
> on dedicated machine.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info|||Do I need more sql licenses for virtual servers
"mecn" <mecn2002@.yahoo.com> wrote in message
news:uWMC86OuHHA.1184@.TK2MSFTNGP04.phx.gbl...
> Hi,
> If I add an sql 2000 instance to a existing prod sql box used as a
> developping sql instance.
> The developers don't need to tough the production box..
> Is it feasible? it will reduce the production performance?
> What's the side effect?
> What about creating a virtual server -- 2-3 virtual sql servers in a one
> physical box.
> Thanks
>|||mecn wrote:
> Do I need more sql licenses for virtual servers
I don't know if it is true for SQL Server 2000 (probably not), but in
SQL Server 2005 it depends on SQL Server version (edition). If you have
SQL Server 2005 Enterprise Edition, you don't need additional licenses
for each virtual server.
In other cases, you must buy new licenses.
Best regards,
Marcin Guzowski
http://guzowski.info|||Thanks a lot dfor your help!!
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:f5ui6o$pu8$1@.news.onet.pl...
> mecn wrote:
> I don't know if it is true for SQL Server 2000 (probably not), but in SQL
> Server 2005 it depends on SQL Server version (edition). If you have SQL
> Server 2005 Enterprise Edition, you don't need additional licenses for
> each virtual server.
> In other cases, you must buy new licenses.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

Add AM or PM to date in text box

How do i add eith AM or PM at the end of the date in the expression of a
textbox
this is what i currently have
format(Globals!ExecutionTime, "dd/MM/yy hh:mm")
but i want it to output 02/08/06 5:02 PM
thanks in advanceTango wrote:
> How do i add eith AM or PM at the end of the date in the expression of a
> textbox
> this is what i currently have
> format(Globals!ExecutionTime, "dd/MM/yy hh:mm")
> but i want it to output 02/08/06 5:02 PM
> thanks in advance
Remove the Format and just give Globals!ExecutionTime.it will do what
you want
Regards
Raj Deep.A|||Thanks
but the date is round the wrong way, its outputting 02/08/06 5:02 PM (ie
MM/dd/yy)
"RajDeep" wrote:
> Tango wrote:
> > How do i add eith AM or PM at the end of the date in the expression of a
> > textbox
> >
> > this is what i currently have
> >
> > format(Globals!ExecutionTime, "dd/MM/yy hh:mm")
> >
> > but i want it to output 02/08/06 5:02 PM
> >
> > thanks in advance
> Remove the Format and just give Globals!ExecutionTime.it will do what
> you want
> Regards
> Raj Deep.A
>|||Oh Sorry,
You can achieve that by format(Globals!ExecutionTime, "dd/MM/yy
hh:mm:ss tt")
regards
Raj Deep.A
Tango wrote:
> Thanks
> but the date is round the wrong way, its outputting 02/08/06 5:02 PM (ie
> MM/dd/yy)
> "RajDeep" wrote:
> >
> > Tango wrote:
> > > How do i add eith AM or PM at the end of the date in the expression of a
> > > textbox
> > >
> > > this is what i currently have
> > >
> > > format(Globals!ExecutionTime, "dd/MM/yy hh:mm")
> > >
> > > but i want it to output 02/08/06 5:02 PM
> > >
> > > thanks in advance
> >
> > Remove the Format and just give Globals!ExecutionTime.it will do what
> > you want
> >
> > Regards
> > Raj Deep.A
> >
> >|||Thanks heaps Raj.
"RajDeep" wrote:
> Oh Sorry,
> You can achieve that by format(Globals!ExecutionTime, "dd/MM/yy
> hh:mm:ss tt")
> regards
> Raj Deep.A
> Tango wrote:
> > Thanks
> >
> > but the date is round the wrong way, its outputting 02/08/06 5:02 PM (ie
> > MM/dd/yy)
> >
> > "RajDeep" wrote:
> >
> > >
> > > Tango wrote:
> > > > How do i add eith AM or PM at the end of the date in the expression of a
> > > > textbox
> > > >
> > > > this is what i currently have
> > > >
> > > > format(Globals!ExecutionTime, "dd/MM/yy hh:mm")
> > > >
> > > > but i want it to output 02/08/06 5:02 PM
> > > >
> > > > thanks in advance
> > >
> > > Remove the Format and just give Globals!ExecutionTime.it will do what
> > > you want
> > >
> > > Regards
> > > Raj Deep.A
> > >
> > >
>

Add a text box in parameter section

I want to text box in the paramter section, can I do this?
the purpose of this it to display a mesage to users.
thanksHi
Display a message to users?
you can display a message in a body of the Report or by giving a text
box using Customcode which requires some classes like Windows.Forms
What is the other way you want to do? can you be little more clear!
Thank you
Raj Deep.A
SQLKen wrote:
> I want to text box in the paramter section, can I do this?
> the purpose of this it to display a mesage to users.
> thanks