Answer Questions

• kiwilamb Can't connect with Visual Web Developer Express

  When attempting to use VWD Express' built-in web server I recieve the following error in browser window: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I've done the following: ...Show All

• alext_2002 Change data source dynamically in report server.

  Hi, I need to change the data source for report server objects (rdl files) dynamically. In other words, I am having databases with identical structures but different data for different clients. Then I need to use same set of reports for different customers. They will access reports through web and they should provide user id/pwd and database name in web login interface, and then it should direct to the the particular database and should be ab ...Show All

• Helloooo connecting to sqlexpress from classic asp

  hi, i'm using classic asp to try and connect to a sqlexpress database on a development server. i get the following error: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /dbtest.asp, line 8 I'm using the following script which runs fine against a regular SQL server (version 8) on the network. <%@LANGUAGE="JAVASCRIPT"%> <% var strCon ...Show All

• Jason McCullough MSFT OpenRowset Table Provider.

  In some definitions of sys.view and sys.functions I found very interesting construction OpenRowset(TABLE <some table name>, .., ..). When I try use with construction in my T-SQL, I get syntax errors. But I can't found any information about with statement in BOL and Internet. Is it some undocumented or internal feature Or I can use it. > Why do you want those directly in your code At t ...Show All

• Syed Atheeque Pasha is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), ...Show All

• tamberg scripting views with dependencies

  I have some views based on other views. If I generate a single script file creating all views, the order in which they are generated in the output file does not account for these dependencies. For example, if view C selects from views A and B, then views A and B must be created before view C can be created. However in the generated script, view C may occur before A and B, which of course means view C will not be created because the views on w ...Show All

• MinakiSerinde How to avoid reload of parameter area in drillthrough report

  I have produced a number of financial reports in SQL 2000 Reporting Services that all has drillthrough links to the same child report. The parametes of the parent reports are passed on to the child report. The child report has more parameters than there is passed from each of the parent reports. All  parameters in the child report has default value settings. It works OK when clicking on the drillthrough link. If&nbs ...Show All

• caseynshan Shredding recordset object var in ForEach loop (problem)

  I have a package that starts by loading a recordset into an object variable. The recordset is then enumerated with a ForEach loop. The loop sets some string variables. Within the loop container I have a Script task that uses a MsgBox to show the results for testing purposes. The package uses checkpoint restart (if that matters ). The first time I run the package the 1st record is displayed in the MsgBox, then the 2nd, but then the loop is st ...Show All

• ChuckD1969 Processing a cube on SQL server 2005 from a dts package on SQL server 2000

  We just started migrating some cubes to the 2005 platform. Still there are some DTS packages running on the 2000 platform that needs some recoding to fit the 2005 enviroment. Therefore we have some solutions where we have DTS packages running on SQL Server 2000 and their "related" cubes running on the 2005 platform. My question is therefore: Is there an easy way to initiate a processing of a cube on the  2005 platform from a Sql server 2 ...Show All

• Chris Cosgriff Deployment 'utility' script using sqlcmd

  Hi all, I'm looking at creating a sample utility script that will invoking scripts to deploy some SQL code. For example, a utlity script that will run a SQL script, and on successful completion, execute the next script. Having not used SQLCMD at all before, and being very new to SQL2005 (< 1 month) please guide me if there is a better way of invoking this... For example, a way of avoiding the xp_cmdshell invocation! The fol ...Show All

• RogerQuickly Allow Blank Values for Strings

  I have a data set in Reporting Services Report (2003) if (@prmAudit = 0 or @prmCellType = 0) BEGIN select top 5000 * from NECCCUSTAUDIT.dbo.vw_cust_audit_billing_problem b where datediff(d,@prmStartDate,b.fld_date_time) >=0 and datediff(d,@prmEndDate,b.fld_date_time) <=0 and b.fld_problem_type like @prmType + '%' END if (@prmAudit = 1 or @prmType = 0) BEGIN select top 5000 * from NECCCUSTAUDIT.dbo.vw_cust_audit_cel ...Show All

• Mattsa diploying reports on browser with custom assembly

  Hi friends, We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc. So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Refe ...Show All

• LJWilliams SQL 2005 Management Studio Timeout expired

  I get the message - "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" - when working with large tables in Management Studio. I have tried changeing the following: 1) Selected Tools -> Options 2) Expanded the "Query Execution" node 3) Clicked on "SQL Server" 4) Set value for "Execution time-out" to 0 and various numbers up ...Show All

• BillyRoberts Registry to store configuration values ?

  I try to store a SSIS-configuration value in the registry. But it's failed. I get a warning, that the registry-key is not found. What is the syntax I have searched in BO,MSDN and  Google/Internet ==> nothing. There is no example.     Bingo! I have tried everything, but not the value key.... To store the configuration in the registry has an advantage compared wit ...Show All

• Dave Biggins Syntax Error:Insert command

  The following command gives syntax error because I have an embedded comma character in the str_group value. How can I bypass this error and insert the record with the embedded comma INSERT INTO dbo.tbl_ec_master_photographs                       (str_facility, str_group) VALUES     ('EC2', 'FLOW'LINE', ) This is t ...Show All