Creating a Query for Notification

SQL Server Notification Services

Index ‹ SQL Server

- Previous
  - 1
    - Error in the transport layer Hello, When i try to connect with excel with tcp/ip to an other computer where there is a cube, i've got this message: 'a n error was encountered in the transport layer Errors in the OLE DB provider An error occured while loading the connection dialog box component for prompting' I'm in mixed mode for the authentication and my user and password are in the olap administrator of the cube i want to browse. I've got Windows XP sp2, SQL server 2005 Sp2 with SSAS developer edition, OWC 11.0 is installed and the OLE DB provider Analysis Service 9.0 Adriano. Tag: Creating a Query for Notification
  - 2
    - How to create charts and graphs on reports? Hi to all, I am newbie to Reporting Services technology I am trying to develop some reports in Reporting Services using Visual Studio Management Express. Is there a way to create some charts and graphs inside a report Have I to use Report Builder Thanks a lot Bye Tag: Creating a Query for Notification
  - 3
    - Performance problem: 2000 vs. 2005 Hi All-- I am having a similar issue and coincidentally in the same situation....Any resolution advice is greatly appreciated. Tag: Creating a Query for Notification
  - 4
    - Grouping question I know I'm overlooking something obvious, but I can't seem to find direct help on this in BOL. This should be simple so please forgive my ignorance for not being able to figure this out on my own. Ok, I have a table that is updated with multiple rows tied to a userid. I want to select out distinct user ids and the max timestamp on any row containing that userid. I cannot seem to get that result set and it's driving me nuts. e.g. source table: Userid LastModified --------------------------------- user1 1/1/07 user2 1/1/07 user1 1/2/07 user2 1/3/07 Here's the result set I want to select out that for some reason is eluding me: Userid LastModified ------------------------------- user1 1/2/07 user2 1/3/07 Id be grateful if anyone can lend a hand, thanks. Tag: Creating a Query for Notification
  - 5
    - error:8646,severity:21,state:1 Hi to all. Anyone could help me on this problem,ive found this when a check the error log due to error on my merge replication. The complete error description was: The index entry for row Id was not found in index 5,of table 362536425,in database 'DB' Error:8646,Severity:21,State:1 By the way i'm using SQL 7 Thank you in advance. Pheter R. Flores Tag: Creating a Query for Notification
  - 6
    - SQL Server 2005/ ADO.NET 2.0 Begin Transaction Issue I have an application that was originally built in VS 2003 and was successfully running against SQL Server 2000 and SQL Server 2005 (June CTP). Recently, we migrated to VS 2005 Beta 2 and are running on SQL Server 2005 (June CTP) exclusively. Since the migration, we have some situations where we receive the following exception when attempting to begin a SQLTransaction: Exception Type: System.Data.SqlClient.SqlException Number: 3988 Message: New transaction is not allowed because there are other threads running in the session Stack Trace: StackTrace Information ********************************************* at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginTransaction() I haven't been able to find any information about this error and I was wondering if anyone had ideas about the cause of the exception and why it is an issue with VS 2005 Beta 2 but not in VS 2003. Regards, Robert Kihm Tag: Creating a Query for Notification
  - 7
    - Windows XP embedded support Hi, documentation states, that Windows XP Embedded (XPe) is not supported by any SQL Server 2005 Edition (as I intend to use the Epress Edition on that platform, I post to this forum). So, why is that Is it just not tested or are there technical reasons for it What are these reasons What works and what doesn't on XPe May XPe be supported in any later version thanks, Matthias Tag: Creating a Query for Notification
  - 8
    - 2005 Reporting Services Configuration Issues Hi All - I am trying to configure reporting services on virtual machine but unable to succeed. I never touched this topic before SQL Server 2005. The left hand side options in Reporting Services Configuration Manager such as Server Status, Virtual Directories, Web Identity works fine but it fails in Database Setup section Here are the details: AppServer: SQL Server 2005 Reporting Services & Client components build# 2153 (with SP1 & SP1 hotfix) going to apply SP2 and Add-on component after the configuration DBServer: SQL Server 2005 Database Services & Client components build# 2153 (with SP1 & SP1 hotfix) OS: Windows 2003 Server with SP1 IIS version on AppServer: 6 I have SQL 2005 Reporting services and 2005 Database Engine on 2 different machines. Here is the error message I am receiving when I try to apply the script in "Database Setup" section of Reporting Services Configuration Manager It did not log any errors in SQL Server however it shows a warning message in Event Log Event Log message - " The RSReportServer.config file has been modified. " Configuration Manager error message - It shows me "Create a Grants Rights Script" task failed " System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementScope.InitializeGuts(Object o) at System.Management.ManagementScope.Initialize() at System.Management.ManagementObjectSearcher.Initialize() at System.Management.ManagementObjectSearcher.Get() at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String machine) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String dbServer) at ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String connectionString, String server, String database, ConfigurationCredentialsType credsType, String account, String password, Boolean upgrade, String dbVersion)" I have captured the screenshot, let me know if I can send this. One of my friends suggested the following and I have tried the first option but could not work - Option I) Our account that is used for database connection should have 1) public and RSExecRole roles for the ReportServerDatabase. 2) RSExecRole roles for the master, msdb , and ReportServerTempDB databases. Else - Option II) we can run the Reporting Service Windows Service under the local System Account and then the credentials type for the database set up would be Service credentials. This way we would have more permission. Did anyone face this problem how should I resolve this Anyone have steps to follow as I feel of missing something in the configuration steps Any information/ suggestions/ pointer on this are higly appreciated. Thanks in advance !! -Satya Tag: Creating a Query for Notification
  - 9
    - Package wont run in a scheduled job I always use ProtectionLevel=DontSaveSensitive. Without exception. This actually forces you to use configurations - and that is no bad thing in my opinion. -Jamie Tag: Creating a Query for Notification
  - 10
    - To find ratio between two columns Hi, Try Writing two different select statements to get assets and liabilities separately for each year. Then combine both of them using UNIONALL and then add it up for a year. So, the query would look like SELECT Year, SUM(Assets), SUM(Liabilities), CASE WHEN SUM(Liabilities) = 0 THEN 0 ELSE SUM(Assets)/SUM(Liabilities) END AS RATIO FROM ( SELECT DATEPART(yy, [The ProSure Group, Inc_$G_L Entry].[Posting Date]) AS Year, SUM([The ProSure Group, Inc_$G_L Entry].Amount) AS 'Assets', 0 AS 'Liabilities' FROM [The ProSure Group, Inc_$G_L Entry]inner join [The ProSure Group, Inc_$G_L Account] on [The ProSure Group, Inc_$G_L Entry].[G_L Account No_]=[The ProSure Group, Inc_$G_L Account].[No_] WHERE [The ProSure Group, Inc_$G_L Entry].[G_L Account No_] BETWEEN 10100 AND 10299 GROUP BY DATEPART(yy, [The ProSure Group, Inc_$G_L Entry].[Posting Date]) UNIONALL SELECT DATEPART(yy, [The ProSure Group, Inc_$G_L Entry].[Posting Date]) AS Year, SUM([The ProSure Group, Inc_$G_L Entry].Amount) AS 'Liabilities', 0 AS 'Assets' FROM [The ProSure Group, Inc_$G_L Entry]inner join [The ProSure Group, Inc_$G_L Account] on [The ProSure Group, Inc_$G_L Entry].[G_L Account No_]=[The ProSure Group, Inc_$G_L Account].[No_] WHERE [The ProSure Group, Inc_$G_L Entry].[G_L Account No_] BETWEEN 20000 AND 20499 GROUP BY DATEPART(yy, [The ProSure Group, Inc_$G_L Entry].[Posting Date]) ) GROUP BY Year Thanks, Akalya. Tag: Creating a Query for Notification
  - 11
    - SP1 Installation note I was having a problem installing SP1, it would barely get started before it would fail. I found it had to do with having many of my databases on an external USB drive. I detached all of those databases, rebooted the machine and then attempted to re-install the Service Pack. This time everything worked fine. Just passing it along in case someone else ran into this. Tag: Creating a Query for Notification
  - 12
    - SSIS Package permissions?? I honestly do not know if this is the correct way to do this in this context. Can you please check to verify if it is working for the file-creating packages Tag: Creating a Query for Notification
  - 13
    - How do I restore sql server database primary data back .mdf Hello guys My server crashed but luckily I was not able to get back my files with help of recovery software. Now, all I have from the database are just sql server database primary data .mdf and sql server databaseTransaction Log Files .ldf . I need to restore these data back to sql server. Please could someone tell me how to restore these two file types back to my sql sever 2007 database Thanks netboy Tag: Creating a Query for Notification
  - 14
    - Table-value Function or View what is more efficient between a table-value function or a View Tag: Creating a Query for Notification
  - 15
    - how can we do Row based table tracking Well, i guess there must be a common column if you're joining them, no Or are you just doing CROSS joins In my example you are essentially creating a row number by means of the IDENTITY property of a column. This can then be used to select a specific row. As has been mentioned in a couple of posts, the concept of getting a particular row is only valid if you have the data in the resultset ORDERED in a specific way. Otherwise, its like having a bowl of oranges and saying get me the 3rd orange please. 3rd based on what Size Juiciness Place in the bowl No, you'd need to say, get me the 3rd orange based upon size. If you need to "loop through" a result set and do an operation on each row eg update a column in that row, you may be better off using a cursor, but in this instance, do you really need to select a specific row Maybe i'm missing something here, anyone Tag: Creating a Query for Notification
  - 16
    - SQL Reporting Services Justify text in a textbox I need to justify the text of my textboxes (justify both left and right). SRS only has an option for left, center, and right. Does anyone have a custom control that can do this or some tips, tricks, or ideas on how I can make the text justified Align the text in justified format. Tag: Creating a Query for Notification
- Next
  - 1
    - looping to drop temp tables Thanks to everyone who replied and provided code snippets. It is very helpful to see those. It is also reassuring to know there is more than one possible solution. Tag: Creating a Query for Notification
  - 2
    - Column count max for Merge replication still 246? Is the maximum number columns per table still 246 for a Merge replication in SQL Server 2005 Tag: Creating a Query for Notification
  - 3
    - rsExecutionNotFound ! I have been frequetly visiting your blogs with a solution for rsExecutionNotFound. I used johngaallard's script to extend the accesstimeout(to 6000 ) eventhough that was not the base of the problem. My Reports run in less than 15 sec (max). I have enabled caching for about 12 hours ( there are nightly updates) using [Cache a temporary copy of the report. Expire copy of report after a number of minutes option]) The reports are rendered using a ReportViewerControl in an ASP.Net2.0 web application.(The report is rendered as PDF and then shown in another IFrame using Adobe plugin).The ASP application session timeout is 100mts. The problem i am facing is that after sometime, the rsExecutionNotfound starts occuring for some report with a specific set of parameters. No amount of rerunning the report will stop. The same report with different parameters renders fine. The only way to stop this is to set the cache option 'Do not cache temporary copies of this report'. If i set ''Do not cache temporary copies of this report'' there are no errors. I am doing caching mainly to bring down report rendering from 15 sec to 2-3 secs. I am using PDF format . I am now thinking of working around by trying to catch the Exception that occurs and trying to re-render the report. If this is the only way, how can i do it. I had fought fiercely to use SSRS and now I am in a fix Any help is appreciated. Thanks, Saj Tag: Creating a Query for Notification
  - 4
    - Programmatically create a Report History Snapshot Hi, To programmatically invoke a subscription we can use - exec ReportServer..AddEvent 'TimedSubscription', '575F96C6-A1BD-49FD-9C2F-934FC9658780' How can we programmatically cause a Manual Report History Snapshot to be created. I know it can be done using the Webservice. How would we do it using the ReportServer stored procedures. Which SP/SP's can we call. With what parameters. TIA, Sam. Tag: Creating a Query for Notification
  - 5
    - User of the Authorized Windows Group Failed to Login I am sorry to hear that, but unfortunately I have not been able to reproduce your scenario on my test environment. My only other suspect at this point would be if the system is using an outdated token. This typically happens on test environments when modifying a Windows user group membership or privileges without refreshing the process (i.e. command shell, or SQL client application). Can you please try the following: can you please close the Windows session for the client account, and re-authenticate to Windows This should provide a fresh token. Hope this helps, and please let us know if you have any additional information that may help us reproduce this failure on our test environment. Thanks a lot, -Raul Garcia SDE/T SQL Server Engine Tag: Creating a Query for Notification
  - 6
    - SQL 2000 Database upgrade to 2005 Dear All.. I have a few databases running a sql2000 and the time as come to move them onto sql2005. Which would be the best route to take. If I can think back to older version it was just a simply job of doing a backup in it's current version then restore in the new version and upgrade was taken while restoring.. I could be wrong but any help !! Thanks Martin. Tag: Creating a Query for Notification
  - 7
    - Proactive caching notification error I have defined a partition to use proactive caching with a polling query notification. The polling query simply returns the maximum value of a timestamp column from the measure group transaction table. The query parses and runs from the create polling query dialogue box. Have set this to run every 30 seconds. When this is deployed runs the trace on Analysis Services returns this error : OLE DB error: OLE DB or ODBC error: Invalid object name 'fcsUltForecasts'.; 42S02. http://support.microsoft.com/kb/225256 this article suggests can be caused by non dbo owned tables. However this table is owned by dbo (and is the table used when the parition is processed normally) Tag: Creating a Query for Notification
  - 8
    - Connecting to SQL Express after Unattended Install Good afternoon, I have written a .NET app that kicks off an unattended install of SQL Server Express Advanced. After the install, the same app tries to connect to SQL Express adn run a script that creates a database plus a few other things. However, the problem I am having is that my app cannot connect. I get the error: "An error has occurrred while establishing a connection to the server. This failure may be casued by the fact that under the default settings SQL Server does not allow remote connections." However, the unattended install goes great. No problems there. I know this because I can Open SSMS, run queries, created DB's, etc. I also know that it is not the remote connections issue because the unattended install is set to allow remote connections (both names pipes and TCP/IP). So, why can't i connect I don't need to reboot after the install do I Please tell me i don't...and please tell me it is something simple I am overlooking. Thanks... Tag: Creating a Query for Notification
  - 9
    - Accessing sub totals in a matrix Hi, How can I access the subtotal cells/values from each of the columns in Matrix and use them for calculations on other places in the report Thanks. Tag: Creating a Query for Notification
  - 10
    - SQL Server Installed, now what? After the long winded process of installing SQL Server 2005 - Developer Edition... I am currently in the process of starting to use the program... Been looking all over the Internet (Google Video/YouTube) for the setting up my database, checking connections etc... Can someone go through the process... of setting up all the checks and using SQL,,,, I want to start creating simple select queries for Northwind... Thanks in advance Tag: Creating a Query for Notification
  - 11
    - installtion program dies when installing Native Client thanks a lot of all ur helps Tag: Creating a Query for Notification
  - 12
    - BCP on client machine Hi, What is the best practice to use BCP.exe to load text file from client machine to the SQLSERVER database installed in another server machine , without installing SQLSERVER client tools on the client machine . Any suggestions is appreciated. Thanks in advance. -Anand Tag: Creating a Query for Notification
  - 13
    - foodmart database? Where can i find the foodmart sample database for SQL Analysis Services 2005. thanks in advance. Tag: Creating a Query for Notification
  - 14
    - SQL Server 2005 JDBC Driver v1.1 and SSL Hi folks, I'm trying to figure out if the SQL Server 2005 JDBC driver supports SSL at all. I've downloaded the driver documentation, looked at more web pages than I care to count, and even went as far as to take a stab at guessing at different driver property names in the hopes I might discover some undocumented feature. Each time I try, I come up dry. The following exception shows up in my JBoss log: 2007-01-03 12:13:36,812 WARN [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to get a new connection: null org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: The SQL Server login requires an SSL connection.) I know I have things working properly on the SQL Server side, as both osql and Query Analyzer work fine, and packet sniffing yields no plain text information. I've also tried swapping in the open source JTDS driver, and once again, sniffing shows that the data between the two machines in encrypted. Does anyone know if I'm just missing something completely obvious, or can someone state with absolute certainty that the driver does not support SSL Any ideas on how to find out if there are plans to support this feature and what the timeline might be Thanks in advance. Trev. Tag: Creating a Query for Notification
  - 15
    - Loading excel file(.xls) into sqlserver (ASP.net web application)(ASP.net framework 1.0) i found the following codes, hardcoding the datasource file for the excel file seems to worked... but i couldn't select and upload random files...(random means through the file selection screen...) 'Import by using OPENDATASOURCE. strSQL = "SELECT * INTO XLImport6 FROM " & _ "OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', " & _ "'Data Source=C:\test\xltest.xls;" & _ "Extended Properties=Excel 8.0')...[Customers$]" Debug.Print strSQL cn.Execute strSQL, lngRecsAff, adExecuteNoRecords Debug.Print "Records affected: " & lngRecsAff Tag: Creating a Query for Notification
  - 16
    - compact sqlce database Thank you. I will give it a try. Tag: Creating a Query for Notification

bfarr23

We want to be able to cache the data for our propertydetails web page (a real estate web site)

Right now the stored procedure for that page is not a good candidate for query notification.

Is it possible to have a trigger on a Property table and when the lastupdated field is changed then go and update the web cache data for that propertydetails page

(i believe that this is Broker Services).

Top

Re: Creating a Query for Notification

Joe Webb

You'll probably receive more responses from another newsgroup or forum. This one is dedicated to SQL Server Notification Services - not the same technology as Query Notifications.

Cheers!

Joe

Top