Answer Questions

• cjr Computed column formulae...2000 vs 2005

  My head hurts! I have a wicked database upgrade mechanism that works broadly like this: Master database schema is scanned into an object model then saved to an XML file. Sometime later...XML file is loaded back into object model and target database schema is scanned into another instance of this object model CompareSchemas routine takes both object models as input, compares them, and outputs a collection of Actions needed to bring the target in line with the master i.e. it works out all the DDL statements necessary to synchronize the database structure. My problem is that I need to have this working seamlessly between 2000 and 2005 - our master development is still in SQL Server 2000 and will be until all our customers ha ...Show All

• Olle SW Cannot fetch the rowset from OLE DB provider SQLNCLI

  Whats the solution for this err "Cannot fetch the rowset from OLE DB provider SQLNCLI" ...Show All

• Dordorgum Running Sql Server Developer Edition with VS 2005 and ASP.NET

  I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work. It says SQl Server express must be installed. I would like to use the full developer edition to link to my projects. Can someone help Thanks, Mike G So does that mean the App_Data folder is only used with SQL Server Express and not to be used with SQL Server 2005 John In your connection string in web.config in your ASP.Net projects, are you pointing to SQLExpress, or have you configured it to connect to your Dev Edition SQL Server More details on your configuration and error message would help. I am having the sa ...Show All

• Abhishek_SE 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly.

  Hi all, I have a small dll that use the SQL Server 2005 SMO library. SQL Server 2005 has SP 1 installed. When I tried to register the assembly with the followin command, I get the error shown. If I remove all references to SMO, the assembly registered fine. I really need help on this. Thanks in advance. CREATE ASSEMBLY ACDataBridge FROM ' H:\User\Development\Projects\Applications\ACDataBridge\bin\Debug\Projects.Applications.ACDataBridge.dll' WITH PERMISSION_SET = UNSAFE Msg 6544, Level 16, State 1, Line 1 CREATE ASSEMBLY for assembly 'Projects.Applications.ACDataBridge' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly. Unverifiable PE Header/native stub. ...Show All

• webrod how to prevent ordering of records....

  hello, i use VC# and sql server 2005. i create a table using the following command : create table history(name varchar(20) primary key); I insert records in a particular order.After all the records are inserted and when I try to retrieve the records, all of them are sorted in a ascending order.Is there any way to prevent them from being sorted. pls reply asap..... - Sweety What order do you want them to be in If you want a certain order, add another column to your table (say an integer column) and assign it values corresponding to the sequence of your insert operations. Suppose id is the name of this new columns. That way you can later get back the data in the order you want by doing ...Show All

• Vipul123 Nesting stored procedure, how to ?

  Hello, I'm trying to use nested stored procedure but can't get it to work. I've created a stored procedure named 'sousmenu1_parents' which does a simple select, no parameter. here's what I'm trying to achieve now : CREATE PROCEDURE SelectAllDroitSpe -- Add the parameters for the stored procedure here @UserId int AS EXEC sousmenu1_parents ; BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT sousmenu1_parents . menu_id1 AS sousmenu1_id FROM authorisations_speciales LEFT JOIN sousmenu1_parents ON authorisations_speciales . page_id = sousmenu1_parent ...Show All

• shakalama Installing AdventureWorks DB in SQL Server 2005

  Banthor wrote: Adventure Works did not come with my installation DVD. Is it available online Google to the rescue download sample databases here http://www.microsoft.com/downloads/details.aspx familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en Walk-through http://msdn2.microsoft.com/en-US/library/ms310325(VS.80).aspx http://builder.com.com/5100-6388_14-6026962.html Where do you have problems In installing the SQL Server service or the database With the successfull installation of the installer package of the Adventureworks database you will only get the file written to the specified folder. YOu will need to attach them / or execute the db creation script on your own. HTH, Jens K. S ...Show All

• R Raghu Events keep bubbling up, even with Propagate=False

  I've been pulling my hair out for the last couple of weeks trying to make my SSIS package more robust. I'm running SQL 05 SP1 on Windows XP SP2. Right now when there's a failure, the error propagates all the way up and my package stops running. Clearly not very robust. I have a heartbeat portion that makes a connection to the database every couple of minutes. Sometimes it loses the connection in the middle of the night, probably due to some maintenance going on. I have created an event handler to log the error, sleep a couple of minutes and set Propagate=False. This works great. When the connection is down, the error is logged, once the connection comes back, the package just keeps going. I also have an FTP component that receives a file a ...Show All

• Kerrie dynamic sql

  I have the following query: DECLARE @ColumnName varchar ( 50 ) DECLARE @FilterValue varchar ( 255 ) DECLARE @ExactMatch bit SET @ColumnName = 'Title' SET @FilterValue = 'Hello' SET @ExactMatch = 1 IF ( @ExactMatch = 1 ) BEGIN SELECT Title FROM CorporateForms WHERE CASE @ColumnName WHEN N 'Title' THEN Title WHEN N 'CorporateFormTypeID' THEN CorporateFormTypeID END = @FilterValue ORDER BY Title END ELSE BEGIN SELECT Title FROM CorporateForms WHERE CASE @ColumnName WHEN N 'Title' THEN Title WHEN N 'CorporateFormTypeID' THEN CorporateFormTypeID END LIKE '%' + @FilterValue + '%' ORDER BY Title END In the database table, co ...Show All

• bob yoplait SSRS 2005 Exporting a report to .xls containing a subreport

  Does SSRS 2005 have the issue fixed as to when the user exports a report to .xls format and the report contains a subreport In SSRS 2000, if there was a subreport in the main report, and the user exported the report to .xls, then it would just display an error message. Thanks! A list won't work inside of a table. I need to use the subreport as a field in a table. (as in displaying a one to many relationship) Using a list for all the fields won't work as the "can grow" property for larger fields distorts any type of "grid" I try to create using the line control. (to simulate the "table" look and feel) And then there is the pain of creating the column headers to appe ...Show All

• Dave Matsumoto An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue

  Hi Guys, Can anyone help me with this error An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source ...Show All

• tattoo Encourage use of UDFs instead of Procedures when possible?

  Over the past few months one of the issues that repeats in this forum has to do with the use of stored procedure output as input to other procedures. One method of dealing with this is to convert the stored procedure to a function if possible and use the function for the process. I was wandering if it would be a good idea to change my database standards to reflect a preference to use functions over stored procedures -- especially in a read-only context. I realize that in some cases this might cause performance problems, but I sill want to recruit opinions on this issue. Anybody UDFs come in 3 flavors - scalar UDFs, inline table-valued functions and non-inline table-valued functions. The performance ...Show All

• udaykiran potti noob question of how to combine two tables from two different servers.

  I got two tables from 2 different server A and B. I do a OLEDB source [server A] with "select ID, currencyNo, exchangerate from table A" I do another OLEDB [ server B] source with "select currencyNo, currencyName from table B" i want to combine these two OLEDB sources with a resultset "select ID, currencyNo, currencyName, exchangerate from table A , B where A.currencyNo = B.CurrencyNo" how do i do this in SSIS sorry if i m a noob. I dun want to use linked servers. can someone help Running that kind of query is not something that SSIS is going to do magically for you. You have to ask your DBA to set link servers (assuming they are SQL Server). ...Show All

• Nyasha SQL 2005 Express and Visual Studio 2003 - Connecting

  I have Visual Studio 2003 and had used it successfully with MSDE. I recently upgraded to SQL 2005 Express and cannot seem to connect to the SQL server. it appears in the list of servers on localhost, but when I try to create a new database it tells me that it "cannot create databases on this server." It will not even open up any existing databases. I have .NET 2.0 installed. I uninstalled SQL and reinstalled it, but nothing seems to help. I feel I must be missing something, but do not know what. I no longer have the MSDE installation files, so I hope I can get Studio to talk to SQL Express. Any help is appreciated. I have a Visual Studio .Net 2003 on my machine and I installed SQL ...Show All

• tribal IE 7 B3 Not Compatible With RS2005

  Lon posted a message on the RS UseNet newsgroup about IE 7 B3 being unresponsive and using 100% of the cpu when trying to view RS reports. I tried it on a test system, and indeed the problem showed up for me as well. Both the IE 7 B3 32 bit and 64 bit version where stuck in a loop when attempting to view RS 2005 reports. I tried both parameter and non-parameterized reports with the same results. The only way to stop it is via Task Manager. A warning to all, do not install IE 7 B3 if you want to run RS reports. Hey MS, you may want to pass this on to IE 7 development team. This isn't good when MS products aren't compatible with each other. I experienced the same problem, the screen starts flickering and IE won’t come back. I ...Show All