Answer Questions

• Neil Cowburn Server Name?

  I have a dialog box that is requesting the server name when I'm trying to create a new SQL Server 2005 database What is that and how do I find it Thanks. Drae if you installed SQL Server with the default settings, then it should be ".\MSSQLSERVER" the ".\" implies your local machine. Remember to mark the thread as "Solved" or helpful, if the issue is solved. -Jens ...Show All

• Martin Flores Excel connection properities -

  In my package I need to change the filename name for my input Excel based on a the contents of an external file.  I want to read the external file, get the filename/location from this file and then dynamically set this as the property for the Excel Connection.  I saw some posts related to this but did not understand which tasks I need to use and in which order.   thanks I changed the variable to be the Provider inste ...Show All

• Dullax Remove HTML formatting <DIV> tags etc

  Hi good people, I am writing a custom report and my description field (imported from a MySQL table) has HTML formating like below. How can I remove this as it makes the report unreadable Cheers Damien <DIV id=editDiv style="PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 11px; PADDING-BOTTOM: 3px; PADDING-TOP: 3px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif">Just another custom report that ...Show All

• blacitect Profiler and password strings

  Hi, When profiling SQL2000 SP4, it seems that whenever it detects a password string of some sort is being passed, the line doesnt get profiles, it just says 'password' Is there anyway to revert this back to the old pre-SP4 where only SQL logins are not shown and everything else is ...Show All

• Trouby Latest RDL Specification?

  I read in someone's blog somewhere that the RDL Specification was changing for SSRS 2005 ( http://blogs.msdn.com/gsnowman/archive/2005/10/12/480328.aspx ). I went to the MS Reporting Services website and this version of the specification appears to be old ( http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx).  ; Can someone either confirm or deny that the spec located at http://www.microsoft.com/sql/technologies/reporting ...Show All

• RichardGodin CLR Trigger to write file.......

  Hello, theres, I have a request to write to a file whenever new record added to the table. When records insert row by row, it goes well. but when more than 2 session insert at the same time, sometimes it duplicate some record in the file. I try to add synchonize code ( like lock , Monitor) but it doesn't work. any idea Regards, Agi I assume you are using this to generate an Audit log or something ...Show All

• Chev Simultaneous DB access

  I have C# Express and the SQL Express Management Studio CTP installed. So far, I've been forced to disconnect from the server in one app to connect to it in the other. I understand there is something around a 4 connection limit in SQLServer Express, so I don't see the problem. During one of these episodes, SQL Mgmt Studio hung while opening DB properties, then the SQLServer service couldn't be stopped. Now the DB can't be opened even after a re ...Show All

• jamesb Dataflow error in lookup task : "Object was open.".

  I Can't reproduce the error if I run the package stand-alone. I'm using the same lookup call (same table, etc.) in 2 packages that are running in parallel (called by a parent package). [LKP_UnderwriterId [72283]] Error: An OLE DB error has occurred. Error code: 0x80040E05. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E05 Description: "Object was open.". Anyone ...Show All

• Oleg Starodumov system.outofmemoryexception

  Hi, HELP. I kept having system.outofmemoryexception in Reporting services. I went to out Infrastructure group got them to procure more memory and got my windows 2003 server to upgrade from 2gb to 8gb memory. I still get system.outofmemoryexception when I run a report. This report is supposed to extract 200,000 rows. You may ask who is going to read this 200,000 row report. But putting that aside how can I make Reporting services to reco ...Show All

• www.qblchinese.com How to restore, transfer or copy a sql 2005 database to sql 2000 server

  Because I'm stupid I assumed, it would be simple to move a sql server 2005 database to sql server 2000, if I don't use special 2005 features. But restore completely not work. No option in case of restore OK - there are some hints about using export etc. in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=166196&SiteID=1 But it seems to be not so easy. Can someone please explain, how to do this move step by step I need complete ...Show All

• Maxtormax SQL 2005 left join not working via OLEDB

  Hi After chasing around a problem I have closed it down to just the following - I have two simple tables in my database linkme linkme2 both of which have one column called [catalog-no] I have put one record in linkme select * from linkme -- pulls back one record correctly via .asp page and management studio select * from linkme left join linkme2 on linkme.[catalog-no] = linkme2.[catalog-no] -- pulls back one record in management studio and ...Show All

• Dencore Deleting Databases in SMO for C#

  Hey all, I was trying to write a C# function that would delete everything in the old database before doing anything new. The following is the code I tried to use for the deleting part. I tried "Killdatabase" but it doesn't seem to be working. Anyway, is there a way to reference the database in the server and send commands to it The compiler gives me a error message saying that srv.Databases("Name") is wrong because I ...Show All

• Mathai Error in Synchronizing Data

  I tried to subscribe to the database that is published on my laptop running on windows XP professional SP2 and using SQL Server 2005. However, in the second step (synchronizing data) the following error message occured: Synchronizing Data (Error) Messages A request to send data to the computer running IIS has failed. For more information, see HRESULT. HRESULT 0x80072EE2 (28037) The operation could not be completed. Anyone ...Show All

• amonteiro Connecting to SQL Server 2005

  Hi all,   I have Windows XP SP2 and SQL Server 2005 CTP installed on my machine. I am trying to connect to the database in a ASP.net application but no matter how much i try i get the following error message : System.Data.SqlClient.SQLException:SQL Server does not exist or Access denied I have tried to fix the problmm by checking in all the online blogs and trying out whatever is being suggested , still no luck!!! Would appreciate if anybo ...Show All

• Ray Hastings SSRS 2000 with VS 2005? Report Designer

  We have SQL Server 2000, and SQL Reporting Services 2000. In order to design reports I just purchased (and installed) Visual Studio 2005, but can't get the Report Designer to install from the SSRS 2000 cd. It gives me a warning stating I don't have VS 2003 installed. All the marketing blurbs about SSRS 2000 say that you need VS 2003 or later in order to get the report designer. How do I make this work Thanks. ...Show All