Microsoft Reporting Technologies

It seems there are several current reporting mechanisms related to .net and Visual Studio. There is Crystal Reports, an integrated reporting system in Visual Studio and a somewhat related reporting system in SQL Server. The last two seem to use similar .xml bases but it's unclear how or if they are related. This does not include (or maybe is does) the Sharepoint reporting system.

I have eliminated the Crystal Report for various reasons after trying it for awhile. Therefore is there some good introductions and/or comparisons between the Visual Studio reporting system and the SQL Server or BI reporting systems since they both seem to use .rdlc and .rdl type definitions. How or are they related?

Try this link where you can find the answers for your questions

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

sql

MgmtStudio: Use current connection/window when opening file

Is there a setting that I am missing, or is it just not possible to do.

When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.

Is there a way that I can set it to NOT do this, and use the existing Window/Connection.

As we have to SQL Logins and thus need to type our passwords each time a new connection is made...

Also, is CTRL-N not in use anymore to open a new connection/window ?

This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

MgmtStudio: Use current connection/window when opening file

Is there a setting that I am missing, or is it just not possible to do.

When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.

Is there a way that I can set it to NOT do this, and use the existing Window/Connection.

As we have to SQL Logins and thus need to type our passwords each time a new connection is made...

Also, is CTRL-N not in use anymore to open a new connection/window ?

This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

Messge to specified Client

I know that SQL has many ways to send message to Current Connection, but I wonder is there any way to Send Message to an Other, specified Connection.

Let suppose ther is an application that makes an inserts in a table (for example cash transfers) and I need a tool to pring all new row via other application that should receive a message that a new row is added (fired by trigger, for example) but problem is that entry and printing applications arenn't same applications and they have separate connections to the SQLI'm not certain that this is what you are looking for, but you might be able to use xp_cmdshell to NET SEND a message to the users machine name. That raises some security issues since to invoke xp_cmdshell you need sysadmin role (or you need to config the sql agent proxy account, which in itself can be problematic).

Aren't there some other options? Perhaps having the process that invokes the print job write a record to a table (with the necessary user info) and then reading that info from the process that actually prints the job?

Dunno, I think we'd need to see a bit more info about what you are trying to do to help you...

Regards,

hmscott|||xp_cmdshell is the way that I've thought about, but problem is that by design the printing app should be runing on client's computer and don't shared via network, also I don't want to run exe app each time a row is added, it may slow down the server. better way is to have a bit field in the supposed table , that is reset by dedault and design printing app to check unset rows by timer , print them and set to 1.
But this isn't the best way out too for me, If i could make SQL to send messages to other connection, I wouldn't have needed to check flag fileds to print them time by time.|||Sorry; outside of xp_cmdshell, I'm not certain of other alternatives. I'm not sure I see what's wrong with setting a flag in the table to be checked by the printing process; it should not be a huge performance hit and if properly indexed and used with an SP, it should execute pretty cleanly.

Regards,

hmscott|||seems flagging is the only way (maybe not bad) for me
thanks anyway.