Answer Questions

• confusedDeveloper Cannot Load SQLSpars.dll

  Hello, I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one: Setup Failed: Could not load SQLSpars.dll Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displa ...Show All

• Akhilesh083 Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Guys, there are thousands of interfaces registered on a typical Windows box. The error can be caused by missing registration of any of them. We've found that particu ...Show All

• StevenSw Subreport - Is it possible to 're-use' the data set from the parent report?

  I have a stored procedure driven report. This report has a subreport driven by the same procedure. If at all possible, I would like the subreport to 're-use' the data set produced by the calling report. Is this possible Mike Reusing a dataset is only possible within the same report definition. Subreports have their own datasets and cannot reuse other datasets. Since you have a stored procedure, you co ...Show All

• Nicolai G. Andersen Default Schema and Synonyms

  database0.User1 has a default schema of database0.Schema1 and also belongs to database1. I have the following synonyms in database0: Schema1.Customers - points to database1.dbo.customers dbo.Customers - point to database2.dbo.customers User1 has execute rights in database0. I have a stored procedure in database0 that says select * from Customers I thought since User1's default schema was Schema1, it would automatically see ...Show All

• aLoNsO___ Join filter failure

  Hello there, I'm experiencing a really weird problem: I have a SqlCE subscriber connecting via IIS to a SQL Server 2005 database. The database publisher/distributor and the web server are on different machines (IIS being in a DMZ) and I want to avoid the use of Kerberos delegation to share priviledges on the snapshot folder. I configured the web synchronization to accept basic authentication and obviously the subscriber sends @internetlogin and ...Show All

• KennyTheGeek Linked Server to Sybase 11 problem

  Attempting to create a Linked Server to a Sybase 11 db. Did the following - Used DSEDIT to create a data source. Ping(Test) works - Created a System DSN using the Sybase System 11 driver - Created a Linked Server with following options     General Tab       - Provider as - MS OLE DB Provider for ODBC Drivers       - Data source as the DSN name created above       ...Show All

• HYEAM getting results based on results.

  Greetings: I have the following query which will get the column name of the table I am trying to work on .. ·          SELECT   COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS Where    TABLE_NAME = 'MyDataTable' This query will give me the column name of “MyDataTable”. But I need to add some calculated field – i.e get the number of rows which are not null from “myDataTable” for ...Show All

• Scott518 Import Wizard using a PosgreSQL Source

  I am trying to use the Import/Export Wizard to import all the tables and table data from a PostgreSQL database into dynamically created tables in my SQL 2005 database.  I have done this many times in SQL 2000 by selecting the PostgreSQL data source from the drop-down list in the wizard.  However, in SQL 2005 this data source is not available. Yes, I did make sure the driver is installed, and I even created a saved Data Sou ...Show All

• Kirk Rader Error when deploying Report Model

  I installed SQL Server 2005 on my laptop, this also contains my SQL Server 2000, so I couldnt use localhost and I used CreweAlex/SQLSERVER2005 as the hostname. What do I need to fill in the field: TargetServerURL Because when I type http:\\localhost\ReportServer it doesn't work (as mentioned in the tutorial which I am following), also CreweAlex/SQLSERVER2005/ReportServer doesnt work. I tried all kinds of combinations, but nothing wor ...Show All

• SaravanaKumarPaulraj SQL Server 2000 Standard Edition Log Shipping

  In trying to follow the directions to setup log shipping in SQL server 2000 I am having some problems. The option to check "Ship the transaction log to other SQL Server (log shipping)" is not located on the popup screen where I choose the database. It is missing entirely. Am I missing something somewhere and if so can someone point me in the right direction I am using SQL Server 2000 Standard Edition Version 8.00.760(SP3). ...Show All

• T.C. join results from multiple EXEC calls

  I would like to make inner join with results from different exec %procedureName% calls. thanks. insert into #temp exec Proc1 insert into #temp2 exec Proc2 insert into #temp3 exec Proc3 Then join or union the tables (depending on the data) If the reultsets are the same you can insert into 1 table instead of multiple tables Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• teneriffebogan Does the Sql Server 2005 EVAL distribution support run of packages under DtExec?

  I believe I have made a complete install of Sql Server 2005 on my dev. machine, including all client tools, and can run SSIS packages from the dev. environment. However DtExec refuses to run any package and always throws the "insufficient version" error (as does the "RunPackage" component, probably for the same reason). I have repeatedly attempted to find something more to install from the Sql Server 2005 eval rele ...Show All

• GlennC How to pass Multivalued Parameter on URL

  I am looking for the syntax to pass a multivalued parameter on the URL. I have tried a comma seperated list and that did not work. http://servername/ReportServer/Pages/ReportViewer.aspx %2fReportName&p_stat_code=MI&p_opco_code=7421,A335,6003,9323 If p_opco_code is set to single value (i.e. 7421) the report immediately renders. Running the above, the report parameters window is shown with nothing selected for the p_opco_code parame ...Show All

• Seth Veale SQL Connectivity

  I am building a C# Windows app.  I have a form and have also create a db.  I tested the db connectivity in Server Explorer and the test came back successfully.  According to my manual, I just need to drag the db item from the server explorer to my form designer to creation the connection.  When I do this nothing happens... what am I doing wrong If I do the same thing in VS2003 the sqlConnection1 shows up, how do I accompli ...Show All

• Steven Hemingray - MSFT Converting @myString to @myInt

  Here's a fun one.  BOL says that using CONVERT or CAST to change a string into a number won't work. The following "works" and I'm assuming it is because the compiler can verify that the string value is in fact a number, even with the Unicode N: declare @col2      int select   @col2 = convert ( int , N '12345' ) ====================================== Here's what I need to work, or I need a creat ...Show All