Answer Questions

• gtataje SSEM - How do you connect to an MDF file?

  I have SQL Server Express 2005 (April CTP) along with SQL Server 2005 Express Manager (SSEM).  I am trying to create an ASP.NET web site using VS 2005 and in the process I want to create and use a smallish SSE database using an MDF file.  I thought I could connect to the MDF with SSEM to populate the DB with some data but I can't figure out how to connect.  Does SSEM support this   Is there a better way to do this - perhaps f ...Show All

• CesarTabares Back Button : Going back to parent report from the child report in Report Manager screen

  Hi,  In my report manager screen, i want to place the back button option by which user can navigate to the parent report For example, I am viewing the orders screen(parent report), in that screen i am clicking the orderid column, it navigates to another report(child report), from which i want to go back to parent report.. I am not using the reportviewer control... i am using only the report manager.... is it possible how do we achieve ...Show All

• Medes syscolumns has wrong length for view columns after table is modified

  Our product uses a data dictionary, which allows users to change the length of fields in the database, as well as using a "verify" function to find discrepancies between the database and the data dictionary.  The verify code uses SQL Server system tables, such as syscolumns, to determine field types and lengths. Recently we discovered that, with SQL Server(version 8.00.2039, SP 4, is what we have), modifying the length of a column in a tab ...Show All

• Goodway Linking to a DB2 database from SQL Server 2000

  I am using SQL Server 2000 (client-side tools including Enterprise Manager) and need to link to tables in a DB2 database so that I can run queries that will import data into my SQL database. My understanding so far is that I need the DB2 ODBC driver (which I have installed) and the DB2 OLE DB Provider. I downloaded the DB2 Application Development Client from IBM, which is supposed to include this provider, but I still don't see it in SQL nor can ...Show All

• Ben0s embbed AS cube browser

    Hi,   How could I embbed AS cube browser to my application thanks a lot,   I have been looking for the same, but so far I have only seen reference to using OWC (Office Web Components) to embed an Excel doc that references the cube. The add-in is available here: http://www.microsoft.com/downloads/details.aspx familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en ...Show All

• Pepo? SQLBulkCopy with Error file

  SQL Server 2005 allows for error files, and output files to be generated as the bcp does it's upload. Is there a similar function using the SQLBulkCopy in c# for example: this is the command line that I am trying to replicate in c# bcp Settlement.dbo.STG_SITE_CATALOG in C:\TEMP\output.txt -f c:\TEMP\layout.txt -m100 -SENMXTFS01\FORESTDEV01 -UFOREST_APP -PF0RE5T! -eC:\TEMP\error.txt ...Show All

• martinbl JOB With SSIS Step Fails If Package Contains A Script Task

  I have a Job Step defined to execute a SSIS Package.  This SSIS package contains a Script Task.  The Job fails with the message "Package execution failed.  The step failed."  I am logging events in the package and when the packages gets  to the Script Task the log reports "The script files failed to load".  If I disable the Script Task from the package it executes fine.  Curiously, the package runs ...Show All

• EricSmith SQL Native Client Issue

  I downloaded and installed Visual Basic 2005 Express Edition, followed by Sql Server 2005 Express Edition. When I ran the command SQLCMD -S SERVER/SQLEXPRESS I got the following error: **** HResult 0x35, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [53]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this fa ...Show All

• JHPE How to get the SessionID from the html viewer?

  Is there anyway I can get the SessionID of a report viewed in the html viewer It seems that the html viewer hides the rs:SessionID from the url I need the session ID to pass to a webservice to save the report as MHTML exactly in the state it has in the reportviewer. Unfortunately I can not take advantage of the export function in the toolbar because, the report has to be saved in a specific place, given a specific filename etc. /Henri ...Show All

• SJ100 sp_change_users_login

  Is there a function like sp_change_users_login that will work with Windows NT Accounts No, there is no such function, because there is little need for it. If you recreate the Windows logins, they will automatically be mapped correctly to the corresponding database users. For recreating the Windows logins, you could look into sp_help_revlogin ( http://support.microsoft.com/kb/246133/ , http://blogs.msdn.com/lcr ...Show All

• JungleFreak Shared Datasource

  Hey ladies and gentlemen,    I am trying to create a shared data source and am getting the following error -     An error has occurred during report processing. (rsProcessingAborted)     Cannot create a connection to data source 'Best_Data_Corp'.    (rsErrorOpeningConnection)   Login failed for user 'XvTVTVTVXOP. Background information: - I have a sql se ...Show All

• DM49220 Carriage Returns and Line Breaks

  I have an address field that is coming back as a single field with carriage returns and line breaks and I would like to have it properly wrap in a single box, but the wrapping is all off. How can I get this to properly break Thanks Make sure you have text box property "cangrow" to true. Nope. That is not the issue. It is cangrow = true. What I want is to take a field that comes out as: Jo ...Show All

• rr_dot_net Newbie BIDS questions

  I've been learning SSIS and the BIDS for a few weeks now and there are 2 things that really annoy me. I'm hoping that there is a setting or option or something that I'm missing. 1. I place objects on the Control Flow surface, get everything arranged the way I want it, constraint lines all nice and tidy and then save it. When I open it things aren't the way they were when I closed it. Any way to make them stay the same 2. If I select multip ...Show All

• AggieNut Replication Error

  I found a problem in replication which we have 3 tables, namely tab A, tab B and tab C replication will apply on tab A and tab B and there is a trigger on tab A and tab B, whenever insert/update on tab A it fires trigger to update tab b whenever insert/update on tab B it fires trigger to update tab C And I found the replication error from tab A on updating tab C. If I manually insert the row, it works fine..... Any advise Thanks ...Show All

• Sushil Sharma Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All