Recent SSRS books?

I will be starting a new project using SS2005 Reporting Services. Can
someone recommend 2 or 3 books on the subject? I am interested in a
book beyond the basics. (I believe I don't need the hand holding, or
"step by step," as that most of that can be found online.)
We will be applying report security and integrating with SharePoint in
the near future as well.
I found these so far.
1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
(Joseph L. Jorden - Sybex, Published 2007)
2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
Hill, Published 2005)
The first book listed above has a section discussing role based
security and SharePoint deployment. Are these mostly a slam dunk and
I don't need this in a book?
Has much changed since 2005? There are many books from 2005/2006 and
a few published more recently.
Thanks in advance!
DanI can recomend :-
http://www.amazon.co.uk/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625/ref=sr_1_1?ie=UTF8&s=books&qid=1196846573&sr=8-1
It covers most topics and starts at a level where you are expected to have
had a play with reporting services and mastered some of the basics of
creating reports.
Cheers
Dale
"ZCSI" <danzemmels@.gmail.com> wrote in message
news:f07e2e87-d3f8-4cd4-a9db-db259766e31d@.y43g2000hsy.googlegroups.com...
>I will be starting a new project using SS2005 Reporting Services. Can
> someone recommend 2 or 3 books on the subject? I am interested in a
> book beyond the basics. (I believe I don't need the hand holding, or
> "step by step," as that most of that can be found online.)
> We will be applying report security and integrating with SharePoint in
> the near future as well.
> I found these so far.
> 1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
> (Joseph L. Jorden - Sybex, Published 2007)
> 2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
> Hill, Published 2005)
> The first book listed above has a section discussing role based
> security and SharePoint deployment. Are these mostly a slam dunk and
> I don't need this in a book?
> Has much changed since 2005? There are many books from 2005/2006 and
> a few published more recently.
> Thanks in advance!
> Dan|||I have the Brian Larson book on my desk, and it's really helpful, but I'm not
a developper but a DBA. So I'm more interested in the technical en security
side of RS.
But it's a good book, and it does the trick for me.
"Dale" wrote:
> I can recomend :-
> http://www.amazon.co.uk/Hitchhikers-Guide-Visual-Studio-Server/dp/0321243625/ref=sr_1_1?ie=UTF8&s=books&qid=1196846573&sr=8-1
> It covers most topics and starts at a level where you are expected to have
> had a play with reporting services and mastered some of the basics of
> creating reports.
> Cheers
> Dale
>
> "ZCSI" <danzemmels@.gmail.com> wrote in message
> news:f07e2e87-d3f8-4cd4-a9db-db259766e31d@.y43g2000hsy.googlegroups.com...
> >I will be starting a new project using SS2005 Reporting Services. Can
> > someone recommend 2 or 3 books on the subject? I am interested in a
> > book beyond the basics. (I believe I don't need the hand holding, or
> > "step by step," as that most of that can be found online.)
> >
> > We will be applying report security and integrating with SharePoint in
> > the near future as well.
> >
> > I found these so far.
> > 1) Mastering SQL Server 2005 Reporting Services Infrastructure Design
> > (Joseph L. Jorden - Sybex, Published 2007)
> > 2) Microsoft SQL Server 2005 Reporting Services (Brian Larson - McGraw-
> > Hill, Published 2005)
> >
> > The first book listed above has a section discussing role based
> > security and SharePoint deployment. Are these mostly a slam dunk and
> > I don't need this in a book?
> >
> > Has much changed since 2005? There are many books from 2005/2006 and
> > a few published more recently.
> >
> > Thanks in advance!
> > Dan
>
>

Receive notification on several clients at the same time

Hello.
I'd like to reveive notifications on the client application when table
data is changed.
How could I use Service Broker, queues and services? In my tests I
have test queue (NotifyTestQueue), test service (NotifyTestService).
If only one client application instance is running - all works fine.
Application runs sql query
WAITFOR (Receive convert(xml, message_body) from NotifyTestQueue)
in the separate thread and thread execution is continued after message
in the queue is available.
But if I run two ore more client application instance only one of them
receives notification :(
Help me please - how could I set up service broker or queue or service
to enalbe notification for several client about the same event in the
queue?
Should I give up and use individual table with records as events for
clients?
Thank you.I think the problem is when your client polls the Q and does a RECEIVE, the
message is lost, thus if another client is also looking for the same
message, it will not be there.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"oleksa borodie" <oleksa.borodie@.gmail.com> wrote in message
news:1140520111.673015.124620@.z14g2000cwz.googlegroups.com...
> Hello.
> I'd like to reveive notifications on the client application when table
> data is changed.
> How could I use Service Broker, queues and services? In my tests I
> have test queue (NotifyTestQueue), test service (NotifyTestService).
> If only one client application instance is running - all works fine.
> Application runs sql query
> WAITFOR (Receive convert(xml, message_body) from NotifyTestQueue)
> in the separate thread and thread execution is continued after message
> in the queue is available.
> But if I run two ore more client application instance only one of them
> receives notification :(
> Help me please - how could I set up service broker or queue or service
> to enalbe notification for several client about the same event in the
> queue?
> Should I give up and use individual table with records as events for
> clients?
> Thank you.
>|||Consider using Notification Services.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"oleksa borodie" <oleksa.borodie@.gmail.com> wrote in message
news:1140520111.673015.124620@.z14g2000cwz.googlegroups.com...
Hello.
I'd like to reveive notifications on the client application when table
data is changed.
How could I use Service Broker, queues and services? In my tests I
have test queue (NotifyTestQueue), test service (NotifyTestService).
If only one client application instance is running - all works fine.
Application runs sql query
WAITFOR (Receive convert(xml, message_body) from NotifyTestQueue)
in the separate thread and thread execution is continued after message
in the queue is available.
But if I run two ore more client application instance only one of them
receives notification :(
Help me please - how could I set up service broker or queue or service
to enalbe notification for several client about the same event in the
queue?
Should I give up and use individual table with records as events for
clients?
Thank you.|||The easiest thing is to use QueryNotification which is one of the new
features within SQL Server 2005.
HTH, jens Suessmeyer.|||Hello Jens.
I've use query notification but it works only for last client. Here is
the code:

code:

private static void NotificationTest()
{
using (SqlConnection connection = new
SqlConnection(_connectionStringLocal))
{
connection.Open();
SqlCommand cmd = new SqlCommand(
"SELECT GenderID, IsActive, DescrLocal FROM dbo.cls_Genders",
connection);
SqlNotificationRequest notifyRequest = new SqlNotificationRequest();
notifyRequest.UserData = "Any User Data";
notifyRequest.Options = "service=NotifyTestService";
notifyRequest.Timeout = 600;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
Console.WriteLine(rdr[0] + "\t" + rdr[2] + "\t" + rdr[1]);
}
Console.WriteLine("notifyRequest was sent");
Console.ReadKey();
WaitForChanges();
}
private static void WaitForChanges()
{
using (SqlConnection connection = new
SqlConnection(_connectionStringLocal))
{
connection.Open();
SqlCommand cmd = new SqlCommand(
"WAITFOR (Receive convert(xml, message_body) from NotifyTestQueue)",
connection);
cmd.CommandTimeout = 0;
object o = cmd.ExecuteScalar();
Console.WriteLine(o);
}
}

So after key is pressed and event is fired on the server only one
client gots event.|||I should explain what is happened with the code above.
So when one client executes NotificationTest method all works fine.
Client gets notification from the SQL server.
But when two or more client were started only one (last started)
receives notification - all others don't. As SriSamp says one client
application polls the queue and other clients miss event. How could I
leave message in the queue when RECEIVE statement is executed? I cann't
find anything that may help me with it :(
Thank you.|||A message can only be dequeued once. There's no way around this.
What you want to do is to multiply that one message into N messages, for the
N clients. Instead of clients waiting on the NotifyTestQueue, each client
waits on a dedicated queue, NotifyClient1...NoifyClientN. Create activated
stored procedure on the NotifyTestQueue that when it receives a message it
forwards this message to all clients (by SENDing the message N times). This
is basically a pub-sub system implemented on top of dialogs. A practical
example on how to do this is at
http://blogs.msdn.com/remusrusanu/a.../12/502942.aspx
Note that you cannot do this if you have too many clients (hundreds). If
each client has a WAIFOR(RECEIVE) blocked waiting for a notification, each
of these statements will block one thread on the server, and you'll hit the
upper configured limit max_worker_threads
http://msdn.microsoft.com/library/d... />
g_09wu.asp
If you need a large number of clients the solution must involve partitioning
out the N client services/queues on a number of different SQL Instances,
since SSB can deliver the notification remotely.
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"oleksa borodie" <oleksa.borodie@.gmail.com> wrote in message
news:1140536881.331233.150770@.f14g2000cwb.googlegroups.com...
>I should explain what is happened with the code above.
> So when one client executes NotificationTest method all works fine.
> Client gets notification from the SQL server.
> But when two or more client were started only one (last started)
> receives notification - all others don't. As SriSamp says one client
> application polls the queue and other clients miss event. How could I
> leave message in the queue when RECEIVE statement is executed? I cann't
> find anything that may help me with it :(
> Thank you.
>|||Hello Remus.
Thank you for fast reply.
Can I use RETENTION = ON parameter on queue?

> Instead of clients waiting on the NotifyTestQueue, each client
waits on a dedicated queue, NotifyClient1...NoifyClientN.
Its not suitable for me - I don't know how many clients will be
connected to the database at future.

> Note that you cannot do this if you have too many clients (hundreds). If
each client has a WAIFOR(RECEIVE) blocked waiting for a notification,
each
of these statements will block one thread on the serve
I'd like to perform RECEIVE without WAITFOR from time to time in the
separate thread on the client.
It seems to me that there is still only one method to notify connected
clients that changes in data occured. Fill some special notify table
and polls this table from time to time at the client. Is it true?
Thank you.|||See inline
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"oleksa borodie" <oleksa.borodie@.gmail.com> wrote in message
news:1140594793.299405.111750@.g44g2000cwa.googlegroups.com...
> Hello Remus.
> Thank you for fast reply.
> Can I use RETENTION = ON parameter on queue?
Remus: No, retention does not allow for a message to be receive more than
one time. Retention keeps a copy of the message in the queue if compensation
is needed, but this copy is not receivable.

> waits on a dedicated queue, NotifyClient1...NoifyClientN.
> Its not suitable for me - I don't know how many clients will be
> connected to the database at future.
Remus: That's manageable, clients can create a queue and then
subscribe/unsubscribe. Separate queues allow for clients to fan out and be
partitioned on several machines for scalability.

>
> each client has a WAIFOR(RECEIVE) blocked waiting for a notification,
> each
> of these statements will block one thread on the serve
> I'd like to perform RECEIVE without WAITFOR from time to time in the
> separate thread on the client.
Remus: Any reason for this? Pooling is in general worse than WAITFOR. Note
that
WAITFOR (RECEIVE) does not pool, it uses a notification mechanism.

> It seems to me that there is still only one method to notify connected
> clients that changes in data occured. Fill some special notify table
> and polls this table from time to time at the client. Is it true?
Remus: No, this is not true. Pooling for changes or pooling for change
notifications is limited in scalability. There is the potential to overload
the server with just answering the queries that are pooling for changes. The
way to address this is to fan out change notifications for each subscribed
client.
You can actually decide which approach is better, based on the specifics of
you case. Some back of the envelope cacluclation will give you a rough
answer:
First, lets figure out the pooling case. Consider you have N clients, each
pooling at an interval of t seconds and the pooling query batch consumes r
seconds on the server. On any interval of time T you are gonna consume a
total pooling runtime on the server R = r x t/N x T . The R/T ratio gives
how much of the total server runtime is consumed serving the pooling
queries. So basically the r x t/N number is giving you this ratio.
In the case of WAITFOR (RECEIVE), you're gonna have N clients blocked on the
server waiting for notifications. Considering each individual client is
going to be notified (per second) with a probability p and the server
runtime consumed for seting up the WAITFOR, delivering the notification and
returning the result is w, then the total runtime consumed on the server
during the interval T will be w x p x T x N. Again, dividing this by T gives
you the ratio of server runtime consumed in servicing these notifications.
So basically the ratio is w x p x N.
So in the end you're left comparing the r x t/N versus w x p x N.
If you consider the pool query runtime r as being based on a SELECT over one
clustered index and the WAITFOR w time as a RECEIVE from a queue, a rough
approximation of w vs. r should be w = 3 x r (maybe 4 x r), because the
WAITFOR will execute a similar scan as the SELECT, but twice (once before
suspending itself, once when is notified) and it also executes a write
operation (the dequeue)
So is all about comparing t/N vs. 3 x p x N.
- smaller t means clients cannot tolerate dirty cache, they need to pool
frequently, larger t means clients are OK with presenting potentially
outdated data. A large t favors the pooling model.
- larger p means the data is updated often and the cache will be invalidated
often for each client, smaller p means the cache invalidation is unfrequent.
A small p favors the WAITFOR.
Is also important if there is a corelation between p and N. If
each client is interested in a separate partition of the possible data
changes, then increasing N will likely decrease p, favouring the WAITFOR (or
at least hurting it less than the pooling). If all clients are interested in
same changes p does not decrease with an increase of N, this case hurst both
models.
Also, given a sufficient large N both models will crumble as the ratio
approaches 1, meaning all of the server resources are required just to
service the notifications. This case must reside to a fan-out mechanism the
WAITFOR model is better suited for.

> Thank you.
>|||Hello.
I cann't ever express how you post helps me. Thank you very much.
I should read more about Notification services and how it could be
connected with Service borker.
Good luck.

Receive "Must declare the variable" When Upgrading to Reporting Services 2005

We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success.

However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet).

When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection string to be a OLE DB type.

Well ... the reports contain parameters (i.e. @.plant, @.employee, etc). So when I attempt to run the query, I get a message saying "Must declare the variable '@.plant'". I have searched for a work around until we migrate the database but I am coming up empty.

Is there a way for me to run a report with parameters from Reporting Services 2005 to a SQL Server database that is prior to SQL Server 2000?

Thanks in advance.

OLE DB Parameters are not named. Instead of @.foo for parameters in the SELECT statement, you use ? I thought the managed provider should work, though. What is the exact error?|||

Thank you for replying. The exact error that is displayed is as follows:

An error occurred during the local report processing

An error has occurred during report processing

Query execution failed for data set 'Journal'

Must declare the variable '@.plant'.

So if OLE DB does not support named parameters, can I use multiple parameters in this report? The report contains seven different parameters.

|||

According to documentation...

The OLE DB provider for SQL Server does not support named variables. Use the question mark (?) character to specify a variable. Parameters passed to the OLE DB provider must be passed in the order they occur in the WHERE clause. For example, PM.Name LIKE ('%' + ? + '%').

http://msdn2.microsoft.com/en-us/library/aa337223.aspx

Other providers may support.

However, you should be able to use query expression & a Reporting Services parameter.

eg. ="Select value from table where value = " + Parameters!MyParam.Value

cheers,

Andrew

|||

Hi,

Did you get the solution to this error ?

I'm getting the same error when I try to pass a multi-list of values from SRS2005 to a storeprocedure.

Please let me know if your report in the dataset has a query or SP.

Thanks

Pepe

Receive "Must declare the variable" When Upgrading to Reporting Services 2005

We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success.

However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet).

When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection string to be a OLE DB type.

Well ... the reports contain parameters (i.e. @.plant, @.employee, etc). So when I attempt to run the query, I get a message saying "Must declare the variable '@.plant'". I have searched for a work around until we migrate the database but I am coming up empty.

Is there a way for me to run a report with parameters from Reporting Services 2005 to a SQL Server database that is prior to SQL Server 2000?

Thanks in advance.

OLE DB Parameters are not named. Instead of @.foo for parameters in the SELECT statement, you use ? I thought the managed provider should work, though. What is the exact error?|||

Thank you for replying. The exact error that is displayed is as follows:

An error occurred during the local report processing

An error has occurred during report processing

Query execution failed for data set 'Journal'

Must declare the variable '@.plant'.

So if OLE DB does not support named parameters, can I use multiple parameters in this report? The report contains seven different parameters.

|||

According to documentation...

The OLE DB provider for SQL Server does not support named variables. Use the question mark (?) character to specify a variable. Parameters passed to the OLE DB provider must be passed in the order they occur in the WHERE clause. For example, PM.Name LIKE ('%' + ? + '%').

http://msdn2.microsoft.com/en-us/library/aa337223.aspx

Other providers may support.

However, you should be able to use query expression & a Reporting Services parameter.

eg. ="Select value from table where value = " + Parameters!MyParam.Value

cheers,

Andrew

|||

Hi,

Did you get the solution to this error ?

I'm getting the same error when I try to pass a multi-list of values from SRS2005 to a storeprocedure.

Please let me know if your report in the dataset has a query or SP.

Thanks

Pepe

sql

Rebuilding the master Database

I have a copy of SQL Server Express on a clients computer.

When i try & restart the services it fails with the following error:-

Error: 9003, Severity: 20, State1.

It looks like the master database has become corrupt & needs rebuilding.

I have found a utility rebuildm.exe that repairs the master db but unfortunately it is not supported in sql 2005.

Does anyone have any other suggestions on how to repair the master db.

Thanks.

i think this will help u

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx

Madhu

|||

Rebuildm.exe is used in sql 2000 .....i think you can rebuild as below,

copy the sql server express exe file to your local hard disk and then in cmd go to relevant path where the setup file resides and run the below code in command prompt.........

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

This works with sql 2005 and i think it will work with sql express also.........pls correct me if am wrong

Thanxx

Deepak

|||

Thanks for that.

Silly question but will the instance name be master & will the SAPWD be sa also do you think i need to use < > between instancename & sa

Does this look good to you guys.

setup.exe /qn INSTANCENAME=<master> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<sa>

|||

Go to the appropriate path where your sql server setup.exe exist in the command prompt........I assume its in C:\test folder .......then command will be like this,

C:\Test> start /wait \setup.exe /qn INSTANCENAME="SQLEXPRESS" REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="XXXXX"

SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance.

http://technet.microsoft.com/en-us/library/ms143744.aspx

I am not sure if this is correct just try|||

Thanks guys.

Got it to work.

Respect.

Rebuilding the master Database

I have a copy of SQL Server Express on a clients computer.

When i try & restart the services it fails with the following error:-

Error: 9003, Severity: 20, State1.

It looks like the master database has become corrupt & needs rebuilding.

I have found a utility rebuildm.exe that repairs the master db but unfortunately it is not supported in sql 2005.

Does anyone have any other suggestions on how to repair the master db.

Thanks.

i think this will help u

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx

Madhu

|||

Rebuildm.exe is used in sql 2000 .....i think you can rebuild as below,

copy the sql server express exe file to your local hard disk and then in cmd go to relevant path where the setup file resides and run the below code in command prompt.........

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

This works with sql 2005 and i think it will work with sql express also.........pls correct me if am wrong

Thanxx

Deepak

|||

Thanks for that.

Silly question but will the instance name be master & will the SAPWD be sa also do you think i need to use < > between instancename & sa

Does this look good to you guys.

setup.exe /qn INSTANCENAME=<master> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<sa>

|||

Go to the appropriate path where your sql server setup.exe exist in the command prompt........I assume its in C:\test folder .......then command will be like this,

C:\Test> start /wait \setup.exe /qn INSTANCENAME="SQLEXPRESS" REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="XXXXX"

SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance.

http://technet.microsoft.com/en-us/library/ms143744.aspx

I am not sure if this is correct just try|||

Thanks guys.

Got it to work.

Respect.

Rebuilding SQL2000 analysis services after server crash and attaching the Cubes

Hi,

The SQL2000 database server got crashed and has to be rebuilt from the scratch. The OS and SQL2000 Database and Analysis Services go reinstalled and luckily the data files residing on the SAN is intact and we were able to reattach the SQL databases.

The question is how can I reattach the OLAP databases and cubes. Apparently we currently do not have backups of OLAP databases but the OLAP data directory on SAN is available and is intact.

So Is it possible to reattach the OLAP database and cubes just like the way we attach the SQL databases.

Please let me know how we can fix the issue at the moment since this is a production issue.

Thanks

Vish

In Analysis Services 2000 all the informations about cubes and dimension structures are stored in the metadata repository db.

The metadata repository db, by default, is an Access db (msmdrep.mdb) that you can migrate to a SQL Server db using Analysis Manager (right click on the server and choose migrate repository).

So if you now have "that" metadata repository (the one before the crash) you can use it and AS can recognise the structure in your OLAP data directory but if you don't ... I don't know a solution to your problem.

Do you really don't have any backup of your production OLAP db?

Francesco

rebuild sql services; making an instance the default

When installing Dotnet, wound up with TWO Named SQL Server instances for use
by the sample apps. When trying to uninstall the extraneous one, I screwed
up and selected the one I wanted to keep. Canceled the uninstall. Server is
still there. Can start up manually and connect to it. However, the
service(s) got whacked before I canceled out.
Two questions.
1) Can the services be rebuilt by hand?
2) If I can get the single (named) instance working, can I turn it into the
default instance? My sole purpose was to be able to test the DotNet sample
apps, all of which are hardwired to connect to local. It's becoming quite a
nuisance to fix them all.
Any suggestions would be greatly appreciated. TIADo you have the database files still there? I.e., the mdf, ldf and possibly
ndf. If so, just use sp_attach_db to attach the database files to get each
database into your desired instance. You can not rename an instance, so you
need to install a named instance.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ron Foster" <rlfoster1@.cox.net> wrote in message
news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> When installing Dotnet, wound up with TWO Named SQL Server instances for
use
> by the sample apps. When trying to uninstall the extraneous one, I screwed
> up and selected the one I wanted to keep. Canceled the uninstall. Server
is
> still there. Can start up manually and connect to it. However, the
> service(s) got whacked before I canceled out.
>
> Two questions.
> 1) Can the services be rebuilt by hand?
> 2) If I can get the single (named) instance working, can I turn it into
the
> default instance? My sole purpose was to be able to test the DotNet sample
> apps, all of which are hardwired to connect to local. It's becoming quite
a
> nuisance to fix them all.
>
> Any suggestions would be greatly appreciated. TIA
>|||Thanks for the response.
Yes, I still have the entire named instance available, and can connect to
it.
What I lost was the services to start/stop/pause it. Currently am having to
start it manually in a cmd box.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OVXpctbvDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Do you have the database files still there? I.e., the mdf, ldf and
possibly
> ndf. If so, just use sp_attach_db to attach the database files to get each
> database into your desired instance. You can not rename an instance, so
you
> need to install a named instance.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Ron Foster" <rlfoster1@.cox.net> wrote in message
> news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> > When installing Dotnet, wound up with TWO Named SQL Server instances for
> use
> > by the sample apps. When trying to uninstall the extraneous one, I
screwed
> > up and selected the one I wanted to keep. Canceled the uninstall. Server
> is
> > still there. Can start up manually and connect to it. However, the
> > service(s) got whacked before I canceled out.
> >
> >
> >
> > Two questions.
> >
> > 1) Can the services be rebuilt by hand?
> >
> > 2) If I can get the single (named) instance working, can I turn it into
> the
> > default instance? My sole purpose was to be able to test the DotNet
sample
> > apps, all of which are hardwired to connect to local. It's becoming
quite
> a
> > nuisance to fix them all.
> >
> >
> > Any suggestions would be greatly appreciated. TIA
> >
> >
>sql

Realtime/streaming data

Is there a way to update data on a reporting services report without having
the user click the refresh button? I am wanting to show realtime stock
quotes in a reporting services report and update stock quotes as they come in
without having to call the refrsh method in the report viewer or having the
user have to click the refrsh button. I am using the report viewer component
in a C# winforms app.
Thanks in advance!!!Use the timer object in the C# winform and refresh the control. You could
have it refresh every minute or 30 sec - but anything more 'real time' than
that - Reporting Services is probably not a real good solution.
"David" <David@.discussions.microsoft.com> wrote in message
news:A05DA637-32B3-48CE-8972-14135DE7888B@.microsoft.com...
> Is there a way to update data on a reporting services report without
> having
> the user click the refresh button? I am wanting to show realtime stock
> quotes in a reporting services report and update stock quotes as they come
> in
> without having to call the refrsh method in the report viewer or having
> the
> user have to click the refrsh button. I am using the report viewer
> component
> in a C# winforms app.
> Thanks in advance!!!|||If you're using RS 2005 you can set the "Autorefresh" for the report
property to the desired refresh interval. It worked in VS preview and
in the the web browser. So I wouild think if you are using the report
viewer control the autorefresh would work there to.
On Sat, 13 May 2006 15:50:01 -0700, David
<David@.discussions.microsoft.com> wrote:
>Is there a way to update data on a reporting services report without having
>the user click the refresh button? I am wanting to show realtime stock
>quotes in a reporting services report and update stock quotes as they come in
>without having to call the refrsh method in the report viewer or having the
>user have to click the refrsh button. I am using the report viewer component
>in a C# winforms app.
>Thanks in advance!!!|||Thanks for trying guys. As I said in my initial email I want to update
values on the report without the report refreshing as a refresh is annoying
to the user and takes you back to the beginning of a report given you are in
backend pages of the report...
"Mark" wrote:
> If you're using RS 2005 you can set the "Autorefresh" for the report
> property to the desired refresh interval. It worked in VS preview and
> in the the web browser. So I wouild think if you are using the report
> viewer control the autorefresh would work there to.
> On Sat, 13 May 2006 15:50:01 -0700, David
> <David@.discussions.microsoft.com> wrote:
> >Is there a way to update data on a reporting services report without having
> >the user click the refresh button? I am wanting to show realtime stock
> >quotes in a reporting services report and update stock quotes as they come in
> >without having to call the refrsh method in the report viewer or having the
> >user have to click the refrsh button. I am using the report viewer component
> >in a C# winforms app.
> >Thanks in advance!!!
>