Dear all, I am creating a ASP.Net application to simulate SQL Server 2005 Notification Services. Query Notification will be automatically created when using SqlDependency. But,When I execute the application I get the following message in the profiler trace. -------------------- subscription fired0<qn:QueryNotification xmlns:qn="http://schemas.microsoft.com/SQL/Notifications/QueryNotification" id="0" type="subscribe" source="statement" info="invalid" database_id="0" sid="0x339E5CD52F1FEB419D35D66253BDD553">qn:Message00000000-0000-0000-0000-000000000000</qn:Message></qn:QueryNotification>75BC3CE3-9DFD-DD11-8F07-00145EBC7544 -------------------- In the above trace, type="subscribe" source="statement" info="invalid" is the error. Please help me how to rectify this. I hope that the subscription is not registering. Thanks in advance. Senthil

Sneha, Pls give a brief about how did you do it? Senthil

Karthik, Detaching means, removing database files from the server and files will remain in the same place without connecting to server. Check sp_detach_db sp_attach_db sp_attach_single_file_db Senthil

Dear Uma, Please give me the table structure with the available indexes. Senthil

Detach the Database files (.mdf and .ldf). Move the files physically. Attach the files to the database. If previous log is required attach both .mdf and .ldf or else only .mdf can be attached.

Please give more details about the relationship between those 3 tables.

Hi all, I have designed an .rdl report in my server(SSRS). I have a client program which will render this report and export. How do I pass connection parameters to the report dynamically? I tried using report parameters. I can pass only server name and database name. I want to pass User id and password too. Please help Thanks in advance Senthil

Hi, Thanks for reply. In detail, I have designed a .rdl report using SQL Report Services 2005 in a server. I have vb.net program in my client machine to access that report. After rendering that report in client, I recieve data in byte() format. I further use file stream to write that as a PDF. Now, I want to print that to a particular printer. Here is the code. =========Code Starts Dim results As Byte() results = objReportingService.Render(m_sReportPath, sOutputFormat, HistoryId, DeviceInfo, LoadParams(), RSCredentials, ShowHideToggle, Encoding, MimeType, RSParamsUsed, RSWarnings, StreamIds) Dim fs As System.IO.FileStream fs = System.IO.File.OpenWrite(m_sFilePath) fs.Write(results, 0, results.Length) fs.Close() =========Code Ends Now the question again. I want to print that PDF file OR Is there any chance to print directly from byte array without converting into PDF? I hope its clear. Thanks Senthil

Hi all, I have a data byte array which further I will convert it as PDF and print it. Can anyone help me in this regards. Is there any chance to print directly from byte array without converting into PDF. Thanks in advance Senthil

Hi all, I am developing a windows application in VB.Net. I am using datagrid with direct editing option. In datagrid, when editing any particular cell, the arrow pointing towards to the edited row in the left side changes to edit mode , i.e., it displays like a pen. At this time when I change, edited record is not updated. What event fires when editing a datagrid cell? Thanks in advance, Senthil

Hi all, Please tell that whether Request.Form can be used for a div tag in the code behind of an aspx page. Thanks Senthil

I am using such type of query in a stored procedure. My stored procedure is compiled each time when it is executed. I am in a position to remove those dynamic queries to get my stored procedure execute faster. I hope u understood. If not I can explain some more. Senthil

Hi, I don't understand ur question. Give some examples. If I am right , try this When column is given NULL Select isnull(,0) from When column is given NOT NULL Select case when "" then "0" else end from

Senthil

Hi, Thanks for your reply. I will give an example Declare @i int Set @i=1 while @i<=7 Begin Update set + @i = value End In the above example, column name will be dynamic , i.e., column1, column2. So, I want to use dynamic query for updation. As dynamic query will hit my performance,I need to avoid dynamic query. Is there any possible way for this? There is a datatype called table . Similar to that, whether there is any datatype called column? Senthil

Hi all, Is there a datatype "column" in SQL SERver 2000? If not can we generate user-defined datatype as "column"? How to convert a variable to datatype column ? Please reply asap.. Senthil

I am using Session in a web page before page load. i.e., I have a global variable which instantiates a class where current.session is used. My current.session is nothing when I create the object for the class. But after the Page loads, session shows all values. Please help.. Senthil

Hi all, I have 1000 employees to load in a webcontrol treeview and display in a web application.Loading takes just 2 seconds , but displaying time takes another 5 secs. How to reduce this timing? Please help Senthil

i want to take print out of my report in client machine where the printer is connected. but now the printing happens in server side. please help asap