Answer Questions

• Xiaobo Gu RS 2000 Sample Printer Delivery Extension

  I followed the steps for the sample printer delivery extension. But when I try to create a data driven subscription for the printers I've specified I get this error message. Printer \\Server1\XXX Printer is not currently installed. How does it know which printers are installed Thanks Richard Yes - everything works except it won't recognize the printer. Yeah. I loved this one ... Here's what I did ... 1. Open the Printer Delivery Extension sample 2. Using VS2005 attach to the ISS worker process - W3wp.exe (when are we going to get naming control over these tasks names - fine when you have just one but a bugger when there are two o ...Show All

• Whoisit Multi Valued Parameter in SQL 2000 Reporting SERVICES

  I need for the user to be able to chose MULTIPLE Values, from within a parameterized field. Is it possible to have multiple selection from 1 parameter in SQL 2000 Reporting services No, this is a SQL2k5 RS feature only. What you could do is, to let the user insert a comma separated list, which will be handled by your SQL code either in "in" Query, or by chopping the values in a called procedure. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- hi jens! i have similar problem. i will let the user insert a comma separated list, but i'm not sure how to handle that in SQL code can you please help! thanks! for example if they entered in city parameter: ...Show All

• Yaniv75 SSL To SQL Server 2000 From VB6 : Error

  Hi All, I am trying to connect to SQL Server 2000 database from my VB6 code. The SQL Server is having the setting ON to force all incoming connections to use SSL. It is using a valid certificate with the same name as FQDN of the server and has been provided by the security department in my organization. I have got my client code on my desktop. I have installed the root CA certificate for the SSL certificate on DB server in my desktop's Trusted Root Certificates. When I try to access the database from my .NET 2.0 code, it works fine. The .NET code gives an error if I remove the CA certificate from my desktop. This behaviour is as expected. I am using Encrypt=True setting in my code here although I dont think it is necessary when se ...Show All

• Jeroen Alblas Hoe to setup integration services on a cluster

  Does anyone know how to install SQL 2005 integration services on a cluster machine I have an a-a cluster machine. Both nodes are using SQL 2005 naming instance. During the SQL installation, I did include integration services option as one of my setup items. The setup process was running fine but I can’t connect to integration services via MS SQL Server management studio. I see below errors: “Invalid server name "TESTServer\B123". SSIS service does not support multi-instance, use just server name instead of "server name\instance". Looks like I must use default instance for 2005 integration services. I re-ran the setup program and added a default instance on the same cluster node. (On that node ...Show All

• Sweeps78 more tables do search,please help me,sql server stored procedure problem

  i have more tables exmaple: table1(id,title,content,date) table2(did,type,title,text1,text2,requestdate) table3(subid,value1,value2,value3,value4) .......................15 tables left,some exmaple now i want use stored procedure do search for asp.net asp.net send search keyword to sql server,sql server get keywords execute search and return results to web application(asp.net) i don't konw how what write t-sql,please friends help me. because table colums is different,so need write t-sql put the temp DATA TO Temp DataTable,last return Temp DataTable to asp.net,asp.net execute split pager display data,eventable colums is different,so on asp.net links is different,need t-sql programming,hope friends can help me comp ...Show All

• SunilN how we get the text() value

  how we get the text() value. your always give half answer, ---------------------------------------------------------------------------------------------------- Youe Solution declare @query varchar(8000) select @query = 'select month ' + ( SELECT distinct ',SUM(CASE WHEN Status = ''' + status + ''' THEN Count END) AS [' + status + ']' AS [text()] FROM sometable s FOR XML PATH('') ) + ' from SomeTable group by month' select @query exec (@query) It looks like you are just doing a FOR XML query, so you dont need to use the XQuery text() operator. You should be able to use SQL's CAST/CONVERT operators: http://msdn2.microsoft.com/en-us/library/ms187928.aspx ...Show All

• Prabagarane Memory usage of SQL Server 2005 Mobile Edition

  Hi forum readers, we are working on a release 2.0 mobile solution right now. In our version 1.0 we did not have to worry about memory issues as our application was the only application running on our target devices (e.g. T-Mobile MDA Compact II Pocket PCs, WM2005). Now we need to share the available memory with others. As our application relies on its SQL Server 2005 Mobile Edition database we are wondering about memory usage of that server. We know that a Pocket PC divides its memory into Storage and Program. If our application uses a 5 MB database and 1.5 MB for DLLs and it's exe-file. These files reside in the storage space when not loaded. When the application starts up it is loaded in the program memory. What happens to the 5 MB datab ...Show All

• manasia Style Sheets / Templates

  I need to create a series of reports that have the same page setup. However, if I need to update the setup, then I do not want to have to change every report. Is it possible to use an .xsl with Reporting Services for SQL Server 2000 I've tried with no success but am wondering if anyone else has been able to do this Thanks, cj No this is not possible. Create a report template which is used for new reports. If anything changes in the layout you will have to change that for every report again, or run a script on the reporting server to pull out the definition and upload the report again. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• TurboTom Feeding an "IN" Clause

  I know I can supply an explicit set to an IN clause, or I can feed it with a select statement. What other ways in TSQL 2005 can I feed it One thing I'd like to do is feed an IN clause by calling a stored procedure. I'm new to TSQL, so I don't know if I can do that. I'd also like to know if there is a way to pass a variadic list of values as a parameter to a stored procedure, so that they can be used in an "IN" clause found in that stored procedure. I think the way to do that last item is by having a recordset parameter. Is that correct Any other way to do it My apologies for making a mistake. The method I presented in my previous post should work, but the implementation is a little off. The corrected code should be... ...Show All

• Hassano21436 Save query results for Word Mail merge

  Real beginner question, I have an ASP.net web app for a little ordering system. I want to be able to easily save the results of a SQL query someplace so that I can use Word to do a mail merge to produce Avery Address labels. Seems to me this should be very simple and yet I'm lost between the worlds of VB.net 2005, ASP.net 2.0, SQL2005, VBA, Office2003. If anyone knows off the top of their head I'd really appreciate it, its really easy using Access however I already have the dBase created in SQL and really don't want ot have to back-pedal.... Thanks, Rick Thanks I figured that out and so I guess I can merely drop a query into a temporary table on the dbase and then use the mail merge wizard...... Of course I was re ...Show All

• Sammy32 To get all available subscriptions for a given NS Application

  Hi, Is there a way that I can get the list of subscriptions available on a given NS application. Also can we get the list of applications available in a given NS instance. Thanks, Shamir Is this for SQLNS 2005 or v2.0 for SQL Server 2000 Are you wanting to get the list in a Subscription Management application (ie c# application) or using T-SQL Here's a link to a blog post I did a couple of months ago about enumerating through a list of applications for an instance. http://sqlns.blogspot.com/2006/07/enumerating-ssns-instances-and.html HTH... Joe ...Show All

• Sportsdude Audit All SQL Queries against all or specific databases

  Hello, I have a problem. I suspect a certain user in my company is using the SA account to log into Databases and run queries(query analyzer) to gather information this user is not suppose to view. The problem I have is this is an IT person so they know the SA password. How can I log specific or all queries run against all databases/tables/fields to find out exactly what this person is doing/seeing Or if there is an alternative to find out this information Please advise Hi, well that depends...on your way for data retrieval. If your only way for data retrieval are stored procedures, you could easily plugin another logging procedure in that code. If they can work with Select statement you wi ...Show All

• jan3784 Dynamic Connection String

  I've seen some threads here about Dynamic Data Sources. I am using the ReportViewer Control for WebForms. I simply want to say the following: reportviewer fv = new Microsoft.Reporting.WebForms.ReportViewer(); rv.ServerReport.SetConnectionString(......); I want to avoid using parameters to do this if I can. I've read that stored procedures don't work when you use parameters. Is this possible Thanks It sounds like you are using the ReportViewer control in LocalMode . In that case, your application has to directly provide the data as a dataset to the ReportViewer control. There is no connection string, because the ReportViewer control will never execute any queries in LocalMode. More i ...Show All

• NetPochi managing XML with a GUI

  Perhaps I'm missing something, but I'm going through a cert book for the MCTS 70-431 exam and doing the XML examples. All the examples are in T-SQL -- when I go to find the XML Schemas I've registered I can't seem to find a way to do this in SSMS ... is there a way to graphically manage XML Schema documents in SS05 I have not done much th the xsl side of things but you can view the registerd collections under the programabilty tab and types for each database. ...Show All

• Akshay Bhargava AdventureWorks Database - cannot access Database Diagrams

  Hi, When I try to access the database diagrams in AdventureWorks, I get the following message: TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. ------------------------------ BUTTONS: OK ------------------------------ Why is this All advice / help apprecuated. Thanks hi, after "upgrading" a database from MSDE or instal ...Show All