How Can I Rename a Reportin Service Folder using Code

Using Reporting Service Web service

It is possible to create folder and delete folder. But I couldn't rename the folder using code it tried with setProperties method but name is ready only property. Please help me to resolve the issue.

Thanks in Advance.

Krishna kumar.M

hi all,

Later I found if use the rs.MoveItem we can achive the same

sql

How can I programmatically know if RS is installed on a server or not

Hi,,
I have a list of SQL servers available in our network in a ComboBox ,I want
to show a message if there is no reporting service installed on a server of
user choice ,I tried to use listChildern ,,but when there is no RS ,,it
thows an Exception inside the web referenc.
ThanksOne suggestion would be to put the code calling ListChildren inside of
a Try Catch block. If you catch the exception you can display a
message box saying reporting services was not found.
More info on Try Catch can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingtrycatchblocktocatchexceptions.asp
The problem with this approach is you'll have to set the Url property
of the web reference and assume the report server is installed at the
default location (http://machinename/reportserver). If someone
installed the report server at a different location you'll need a more
robust mechanism to find it. I'd suggest trying WMI (windows
management instrumentation). There is an example in the docs showing
how to connect to a remote report server:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_wmi_6iua.asp
Note: the sample code in the docs also needs a try / catch in case the
server does not have SSRS installed.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 12 Nov 2004 11:25:32 -0800, "ALI-R" <newbie@.microsoft.com>
wrote:
>Hi,,
>I have a list of SQL servers available in our network in a ComboBox ,I want
>to show a message if there is no reporting service installed on a server of
>user choice ,I tried to use listChildern ,,but when there is no RS ,,it
>thows an Exception inside the web referenc.
>Thanks
>

How can I make a DTS get data from an XML web services

Hello there
I want to know if there is a way I can make a DTS package log to an xml web
service and query a functions for data that i can insert into a table ?
thanksHi
You may be able to use the sp_OA* procedures to do this.
John
"Simo Sentissi" wrote:
> Hello there
> I want to know if there is a way I can make a DTS package log to an xml web
> service and query a functions for data that i can insert into a table ?
> thanks
>
>|||Also... you could use an activeX task and set a global variable.
John
"John Bell" wrote:
> Hi
> You may be able to use the sp_OA* procedures to do this.
> John
> "Simo Sentissi" wrote:
> > Hello there
> >
> > I want to know if there is a way I can make a DTS package log to an xml web
> > service and query a functions for data that i can insert into a table ?
> >
> > thanks
> >
> >
> >

How can I know who inserted a certain record?

Dears,
I have either a service or even a user who keeps adding records to a certain table. Is there any way to know who added the records? Other than using the SQL Profiler.
Thanks,To collect statistical information about users, use either SQL Profiler or System Monitor (Windows NT Performance Monitor in Windows NT 4.0). Use the SQL Server Enterprise Manager Current Activity window to perform ad hoc monitoring of SQL Server, which allows you to determine user activity on the system.

Also, type this into the Books Online Search "Monitoring with SQL Server Enterprise Manager"

Also, is there a lock for the INSERT?

Hope it helps...|||Just add a column with as default User

How can I know the "SQL Server" Service is down ?

Dear,
How can I make a SQL Server able to send me an email alert if its SQL Server
Service and/or SQL Server Agent Service is down automatically ?
SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they can
monitor themselves.
Are there any other way to monitor them ? Either from Microsoft Windows
system or third party softwares.The simplest solution is to configure MOM (assuming you have deployed it).
Otherwise you need to do this in Windows. In the Computer Management -
Services node, display the properties pages of the services of interest and
configure the recovery page.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ff47de$1@.127.0.0.1...
> Dear,
> How can I make a SQL Server able to send me an email alert if its SQL
> Server
> Service and/or SQL Server Agent Service is down automatically ?
> SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> can
> monitor themselves.
> Are there any other way to monitor them ? Either from Microsoft Windows
> system or third party softwares.
>|||Dear Yudkin,
What does MOM stand for ?
Please tell me, thanks a lot.
"Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> The simplest solution is to configure MOM (assuming you have deployed it).
> Otherwise you need to do this in Windows. In the Computer Management -
> Services node, display the properties pages of the services of interest
and
> configure the recovery page.
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ff47de$1@.127.0.0.1...
> > Dear,
> >
> > How can I make a SQL Server able to send me an email alert if its SQL
> > Server
> > Service and/or SQL Server Agent Service is down automatically ?
> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
> > can
> > monitor themselves.
> >
> > Are there any other way to monitor them ? Either from Microsoft Windows
> > system or third party softwares.
> >
> >
>|||> What does MOM stand for ?
Microsoft Operations Manager. See
http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffa2bc$1@.127.0.0.1...
> Dear Yudkin,
> What does MOM stand for ?
> Please tell me, thanks a lot.
> "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> The simplest solution is to configure MOM (assuming you have deployed
>> it).
>> Otherwise you need to do this in Windows. In the Computer Management -
>> Services node, display the properties pages of the services of interest
> and
>> configure the recovery page.
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ff47de$1@.127.0.0.1...
>> > Dear,
>> >
>> > How can I make a SQL Server able to send me an email alert if its SQL
>> > Server
>> > Service and/or SQL Server Agent Service is down automatically ?
>> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they
>> > can
>> > monitor themselves.
>> >
>> > Are there any other way to monitor them ? Either from Microsoft Windows
>> > system or third party softwares.
>> >
>> >
>>
>|||Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
> > What does MOM stand for ?
> Microsoft Operations Manager. See
> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:46ffa2bc$1@.127.0.0.1...
> > Dear Yudkin,
> >
> > What does MOM stand for ?
> > Please tell me, thanks a lot.
> >
> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
> >> The simplest solution is to configure MOM (assuming you have deployed
> >> it).
> >>
> >> Otherwise you need to do this in Windows. In the Computer Management -
> >> Services node, display the properties pages of the services of interest
> > and
> >> configure the recovery page.
> >>
> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
> >> news:46ff47de$1@.127.0.0.1...
> >> > Dear,
> >> >
> >> > How can I make a SQL Server able to send me an email alert if its SQL
> >> > Server
> >> > Service and/or SQL Server Agent Service is down automatically ?
> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
they
> >> > can
> >> > monitor themselves.
> >> >
> >> > Are there any other way to monitor them ? Either from Microsoft
Windows
> >> > system or third party softwares.
> >> >
> >> >
> >>
> >>
> >
> >
>|||Or (the poor man's approach) you can also write a WMI script using VBScript
that monitors the SQL Server service and sends an email when it goes down.
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:46ffb47d$1@.127.0.0.1...
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:Od9MKe2AIHA.288@.TK2MSFTNGP02.phx.gbl...
>> > What does MOM stand for ?
>> Microsoft Operations Manager. See
>> http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> news:46ffa2bc$1@.127.0.0.1...
>> > Dear Yudkin,
>> >
>> > What does MOM stand for ?
>> > Please tell me, thanks a lot.
>> >
>> > "Mark Yudkin" <DoNotContactMe@.boingboing.org> wrote in message
>> > news:OUbFU7zAIHA.5752@.TK2MSFTNGP02.phx.gbl...
>> >> The simplest solution is to configure MOM (assuming you have deployed
>> >> it).
>> >>
>> >> Otherwise you need to do this in Windows. In the Computer Management -
>> >> Services node, display the properties pages of the services of
>> >> interest
>> > and
>> >> configure the recovery page.
>> >>
>> >> "cpchan" <cpchaney@.netvigator.com> wrote in message
>> >> news:46ff47de$1@.127.0.0.1...
>> >> > Dear,
>> >> >
>> >> > How can I make a SQL Server able to send me an email alert if its
>> >> > SQL
>> >> > Server
>> >> > Service and/or SQL Server Agent Service is down automatically ?
>> >> > SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because
> they
>> >> > can
>> >> > monitor themselves.
>> >> >
>> >> > Are there any other way to monitor them ? Either from Microsoft
> Windows
>> >> > system or third party softwares.
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>

How can I install SSIS on client side?

Hi,

We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?

Thanks in advance,

Jie

Hi Jwei,

Take That CD 1 and choose Workstation components, Books Online and development tools.

That'll install the following components:

.BOL

.Native client

.BIDS

.SQLXML4

.MSXML6

.OWCL11 (Office Windows Components)

.SQL Server Backward-Compatibility Files

HTH

|||

Stop! Make sure you understand the license changes for SSIS compared to DTS. Put simply you can no longer redistribute SSIS as a client component, like you could with DTS. SSIS is a server component, so machines must be licensed with server license, not just a CAL.

|||you're right...|||

Thanks a lot for taking time to respond to my post.

I had problem with the license change, just could not believe it.

"no longer redistribute SSIS as a client component, like you could with DTS" is a key to me.

|||

Then, how can I install only SSIS Client on my work station?

Please help

Thanks

|||Run setup. Choose the Integration Services and Workstation components options.|||

TDRao wrote:

Then, how can I install only SSIS Client on my work station?

SSIS client components are installed when you install Workstation components - that gives you BIDS (with ability to design and debug SSIS projects and packages) and SSMS (with ability to connect to SSIS service and monitor package execution).

To run packages in production you need SSIS server components, which are installed when you install Integration Services. That requires server license.

|||

Thanks a lot for the solution

How can I install SSIS on client side?

Hi,

We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?

Thanks in advance,

Jie

Hi Jwei,

Take That CD 1 and choose Workstation components, Books Online and development tools.

That'll install the following components:

.BOL

.Native client

.BIDS

.SQLXML4

.MSXML6

.OWCL11 (Office Windows Components)

.SQL Server Backward-Compatibility Files

HTH

|||

Stop! Make sure you understand the license changes for SSIS compared to DTS. Put simply you can no longer redistribute SSIS as a client component, like you could with DTS. SSIS is a server component, so machines must be licensed with server license, not just a CAL.

|||you're right...|||

Thanks a lot for taking time to respond to my post.

I had problem with the license change, just could not believe it.

"no longer redistribute SSIS as a client component, like you could with DTS" is a key to me.

|||

Then, how can I install only SSIS Client on my work station?

Please help

Thanks

|||Run setup. Choose the Integration Services and Workstation components options.|||

TDRao wrote:

Then, how can I install only SSIS Client on my work station?

SSIS client components are installed when you install Workstation components - that gives you BIDS (with ability to design and debug SSIS projects and packages) and SSMS (with ability to connect to SSIS service and monitor package execution).

To run packages in production you need SSIS server components, which are installed when you install Integration Services. That requires server license.

|||

Thanks a lot for the solution

how can I include Full Text Search service in my program setup silently?

heloo..

if I want to use full text search in my program, can I include Full Text Search service in my program setup silently in the same way as including SQL Express and .Net Framework to the setup project, Or I have to Install MS Sql Server 2005 on my customer computer?

Full text search is included with the SQL Server Express Advanced edition (but not SQL Server Express). You can add "ADDLOCAL=SQL_FullText " to your addlocal parameter during silent install or use "ADDLOCAL=All" to get everything.

Here's a link showing what Express and Express Advanced include:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Thanks,
Sam Lester (MSFT)

how can i give customize dataset to sql report

hi
i am new to sql reporting service, i am using for financial reporting,
in one of my requirement i have to calculate how much year customer's fund
will last and i have to show each year's balance.
in crystal report i get directly assign dataset, but how can i
assign dataset in reporting service, plz so urgentIn SSRS, you can assign an application dataset to server-based report only
if you use a custom dataset extension. In your case, I will gravitate toward
performing the data manipulation at the data source level, e.g. inside a
stored procedure. If you use SQL Server 2005 as a data source, consider
using a CLR stored procedure.
I demonstrate how this could be done in this code sample
(http://www.prologika.com/downloads/Pass/). The report invokes a CLR stored
procedure that uses data mining for sales forecasting.
As a side note, for financial reporting, I strongly suggest you evaluate
Analysis Services especially if you need to support account charts where
values substract or add (income, expenses, etc). Otherwise, you may find
yourself reinventing the wheel. I know from personal experience.
HTH
--
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Lovenish" <Lovenish@.discussions.microsoft.com> wrote in message
news:CE811BDF-1C05-4C34-9853-166E60A39D65@.microsoft.com...
> hi
> i am new to sql reporting service, i am using for financial reporting,
> in one of my requirement i have to calculate how much year customer's fund
> will last and i have to show each year's balance.
> in crystal report i get directly assign dataset, but how can i
> assign dataset in reporting service, plz so urgent|||Thx Teo Lachev,
but the code you have send is i think in visual studio 2005, i am
using 2003. so can u help me further,
u were talking about customize dataset extension but i cant get how to use
this so plz plz help me

How can I get the port of a named instance of SQL Server

Thanks for Microsoft's Windows XP Service Pack 2 and Windows Server 2003 that make the security much stronger. However, besides the invisible benefit so far, I have become the victim of this security policy.

I have several named instances of SQL 7/2000 installed in my machine. They are not visible out of the Microsoft new fire wall. I need to access the instances from outside the fire wall, but I don't know which port I should open for the instances.

From SQL online, the default instance of SQL server is connected through TCP/IP by default port 1433. I could successful open that port and made the default instance visible to outside. However, the port 1433 doesn't work for the named instances. SQL online said, the port for named instance is dynamically (by default) chosen the first time the instance is started. So, actually, I have no way to know the port.

Is there anyway that I can check the database or somewhere to get the port that is used by the named instance?

Thanks for any input and recommendation.> I am the first victim of this security policy.

don't kid yourself. a lot of people have been caught out - many by inadequate preparation or by a simple naivete. your problem seems more of an actual gotcha though.

try turning off the firewall and doing a netstat -a|||Hi, Atrax, thanks for your input. But, ...|||wtf? I didn't follow that at all.|||Never mind.

By the way, I got the solution for the original question. Using SQL Server Network Utility can find all ports for default and named instances.