Answer Questions

• Matthew_Stevenson tools to generate insert statement from db

  i have some data in the some tables in a db, wondering if MS has any tool which can generate those data in insert query to make data transfering easier. Of course alternatively, i can export those data to excel or access, but insert query will be handy. if MS doesn't have it, anyone can recommend some tools (free preferred) which can do that Do not know of any tools (besides export/import) but one trick would be to perform a SELECT on the source table but format the output to generate INSERT statements. You could then copy and paste the "results" into a new query window and execute it. For example, Assume T1 has the following columns and data: Name Age Born Peter 23 03/1 ...Show All

• Bartosz Cannot Install Toolkit.

  Trying to install SQL Everywhere Beta Toolkit. And am getting following error message: "The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade path." On difference is I'm installing on top of the "recently released" verision of VS2005 SP1, not the beta. But, other than that, all ...Show All

• Ross B. Suppressing links when exporting

  Is there a quick way to suppress links when exporting a report. My links are generally expressions i.e. IIF(x>0,navigate to a url, '') where the new url may or may not be a new report. Thanks Umer There is no way to tweak the Report for different export formats. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• OmegaMan Transaction log filling up in "Simple" recovery model, catch 22

  I need to do the quaterly cleanup of our database involving moving historical data to our history db and delete-ing records in a our operational datastore. I've set the recovery model to "simple" as advertised in numerous fora and KB articles. Still the the transaction log goes through the roof evertime I do a delete * from myTable where datetime < '2006-10-01' Where eventually it fails becouse transaction log is full....(Msg 9002) If I do a BACKUP LOG myDatabase TO myBackup sql claims that I cannot perform a transaction log backup (Msg 4208). So I 'm stuck with a large log file in the "simple" recovery model that can not be shrunk... Thanks Chris I'm trying to cl ...Show All

• Ravi Kiran sqlcmd :r and spaces

  I've been pulling my hair out with this for a bit and thought I'd post a solution. The problem is that if the file name :r reads contains spaces, it almost always gives an error. The solution isn't great and if anyone has something better I'd love to see it: :setvar dir "C:\test dir\" :setvar file "my file.sql" PRINT '$(dir)$(file)' :r $(dir)$(file) GO :setvar file "my file 2.sql" PRINT '$(dir)$(file)' :r $(dir)$(file) GO :setvar file "my file 3.sql" PRINT '$(dir)$(file)' :r $(dir)$(file) GO Hope this helps someone. Thanks Robert, That only works if the filename is a constant. I suppose I could search and replace but then I'd have to hunt through the script to see i ...Show All

• Giovanni A. Costa Rosa ParallelPeriod, Subcubes, and SP2

  We're defining some KPIs that include trend expressions which use the ParallelPeriod function to calculate the change in a KPI value since a past time period. For example, we calculate the change in the KPI value When we use an MDX SELECT with a WHERE clause that specifies a time slice, the expression evaluates correctly. However, when we use CREATE SUBCUBE to do the filter, or use BI Studio (which creates a subcube), the result is incorrect. In particular, the there's an IsEmpty check for the parallel period of the KPI value, so we're not doing bogus math when there's no data for the previous period. With the WHERE clause, that works fine, but with the subcube, the ParallelPeriod always evaluates to empty. As a point of comparison, I t ...Show All

• klio Export to Excel - Expand/Collapse fails when report launched from aspx

  I have a sql reporting services 2003 report - this works perfectly from within sql reporting services.. but the export to excel feature does not work as expected when the report is launched via aspx. The report contains 6 separate datagrids all with 4 levels of drilldown. The expand/collapse feature works fine when the report is viewed via the web. Each with their own dataset. If I export to excel within sql reporting services.. it exports all datasets fully expanded. This is fine and works as I'd expect. However when Iaunch the report from an aspx page, the export to excel only shows the collapsed top level figures for each datagrid. Any ideas why the export shows the fully expanded data from within reporting services, but only the ...Show All

• Henrik Dahl Invalid class string in Enterprise manager

  Hi, Sorry to be cross-posting, but I'm not getting much response to this... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=807314&SiteID=1 ...which I don't even think is in the right forum anyway. can anyone help Basically, I get a error box saying "Invalid class string" in Enterprise Manager whenever I try to run a query. Apologies if this is the DTS-related article that you've already tried, but have you looked at this KB article Even though you're not using DTS, the installer seems to have some problems during the upgrade to 2005. I haven't seen this issue before so I'm interested to see if this solves your problem. http://support.microsoft.com/ kbid=912421 CAUSE ...Show All

• Steve Whitley SQL 2005 database will not attach in XP

  We are testing our product installation and run into the following problem on Windows XP and Server 2003, but not 2000: I am trying to attach a database using a command line program that we made, but get the following error: Could not open new database 'Launcher5'. CREATE DATABASE is aborted. File activation failure. The physical file name "C:\MARC\MARC5\Data\Launcher5_log.LDF" may be incorrect. The log cannot be rebuilt when the primary file is read-only. Check the error log to see if there is more information about the cause. Best guess... file permissions. SQL Express uses Network Service for the service account on Windows XP and 2003 and I'll bet this account doesn't have per ...Show All

• Jonathan Cran Adding multiple fields together

  Okay hopefully this is quick and easy. I have 3 fields (Annual Salary, Medical, Pension) and I now need to working out Cost To Company which is just adding those three together. I tried to do that in a formula but it doesn't return me anything... This is what I had. =(Sum(Fields!AnnualSalary.Value, "CoreEmployeeData")+Sum(Fields!AnnualMedicalAid.Value, "CoreEmployeeData")+Sum(Fields!AnnualPension.Value, "CoreEmployeeData")) So it should add the 3 records While you are here :), Can you tell me how I can put a currency symbol in the front of these numbers and add the thousand comma delimiter Cool! - Its is one of those things, to be honest i dont use the format area at all bu ...Show All

• blender Reporting Services Instance could not be found

  Hi I am receiving an error message when I connect to Reporting Services in SQL Server 2005, the error is: Cannot connect to <SERVER> Reporting Services Instance could not be found (Microsoft.Sqlserver.Management.UI.RSClient) Can anyone help with this please Thanks Hi David, thanks for the solution. In this case I have found a solution by my self. The Problem is, I used a developer version of the SQL server installation. There are no information about a incompatibility with development SQL installations. So I tried to install a standard SQL server edition and now it works. Can you check if RS is configured properly by going to Start-> ...Show All

• johnvms WQL Query to watch for a file

  I need an example of a WQL query to use in the WMI Event Watcher task to watch for the presence of a file. The task has to succeed for either: 1) The file already exists when the task is run 2) The file shows up while the task is running (waiting) Also the query has to reference a UNC path and file name. The file I'm looking for is just a flag file telling me a table is refreshed in our Data Warehouse. I also need pointers on how to set the WMI connection manager. For the server, do I use the \\servername of the fileserver Do I need to include the folder the files are in (eg. \\servername\flags\ ) Thanks! Kory Thanks, but I've found numerous examples of using a mapped drive, and monito ...Show All

• Christopher61 Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• Mahender SQL Server 2005 Service Pack 2 -- Now Available

  SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides. SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx Thanks, Sam Lester (MSFT) How does one move from SQL Server 2005 SP2 CTP ( Community Technology Preview) to SP2 RTM (Released To Market) version that was released this week Do I need to uninstall CTP and then apply RTM version or I can apply RTM over CTP Is the fix list for the R ...Show All

• Biju S Melayil selectively receiving

  I have a scenario whereby I will have 200+ clients putting messages onto a service broker queue. This message will go through a pipes and filters based messaging system, and ultimately the message will pop out the other end. Here's the question: what is a good way of making sure the same client gets the response to the message he received. Is there anyway I can selectively receive messages from a queue, i.e., pass a correlation id in with the message, and then filter messages based on that id. Or if someone knows a better way to do it altogether i'd really appreciate it. Many thanks, Paul Hi Rushi, This is exactly the approach I'm looking for.  But when I  send a message, th ...Show All