Answer Questions

• dmatthew HOw to export txt file with column name??

  i want to know the bcp command to export dat to txt file include column names. I can do export data wiht the table content that do not include column names, it means that i can not ue this text file to do SELECT statement with condition.Pleas for any help.Thanks Io: I don't think this is directly an option of BCP and I do not immediately see it in books online or with BCP / ; can someone please check me on this ...Show All

• Josh Robertson Transfering data from Access Databse to Sqlserver

  I need to connect an already exeisting Access database to the Sql Database or you can say I need to import data in to sql I havent used access much if any body can help me with that, that will be really great That depends if the data is only imported once or on a regular basis. So you either use the import wizard Create a linked server Use the Opendatasource method (in TSQL) Create a Integration Services package. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Seraphino Unable to install SQl Server 2005 SP2 - Unexpected error

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• PublicError data reader source in data flow problem

  hi all, i have a package in ssis that needs to deliver data from outside servers with odbc connection. i have desined the package with dataflow object that includes inside a datareader source. the data reader source connect via ado.net odbc connection to the ouside servers and makes a query like: select * from x where y= and then i pass the data to my sql server. my question is like the following: how do i config the datasource reader or the dataflow so it will recognize an input value to my above query i.e for example: select * from x where y=5 (5 is a global variable that i have inside the package). i did not see anywhere where can i do it. please help, tomer Like I said, the Datareader ...Show All

• Arbu Recursive query?

  I have a set of data and I need to actually add a column to the result set based on information contained within the query. For example, SalesmanID  SalesBudget   SalesRegion      Product      Amount 1                      1000                 USA                   Soap          100.50 1         &nbs ...Show All

• Binu Jeesman sql 2000 to sql 2005 upgrade

  I have a sql 2000/2005 side-by-side install on a single server. I right-click a sql 2000 database, select All Tasks, and the Copy Database to upgrade a sql 2000 database. In the "Copy Database Wizard" I see the message: "To use the detach and attach method SQL Server Agent must run under an Integration Servicers Proxy account that can access the file system of both the source and destination servers." 1. What does that mean 2. I decided to click "Finish" in the wizard, and the database copy seemed to work fine. Whaterver 1) means does, by default, the SQL Server Agent already run under this "Integration Services Proxy" account. (Rememberr the upgrade process did work). TIA, ...Show All

• Alan Zhou Hyperlink to Rewritten URL PDF

  Is there anyway SQL server can have an expression that can make URL rewrite I know that URL REWRITE have to be done in an internal server. However, is it done in a server that has the report in it or the PDFs which I am trying to hyperlink to. Thanks ...Show All

• Scott Lock Merge Replication on Windows XP

  Hi Is it possible to create Merge Replication between two server running on Windows XP(SP2). Why i ask this, as i am trying to do so, but got the error "The process could not connect to Distributor", As i already change the login for these two services for "local system" to with Administrative permisstions, but noting seem good for me.. getting the same error.)  when i googling around this, what i find, i need the Domain Account to login to as the services (SQL SERVER & SQL AGENT) one. is it so i need the domain controler for the this How can i create a domain account, without PDC (primary domain controller). or so help me out, is there any boby who setup the same if so help me.... or ..... any o ...Show All

• José Antonio Farias - MVP Adding the date to a subscription report name

  Does anyone have information on how I can add a file date to my named report when a subscription writes that file to a network folder I am exporting as .pdf files. For example, today I have filename abc.pdf but I'd like it to be abc03312006.pdf. Likewise, tomorrow's file would be abc04012006.pdf. Any help is greatly appreciated. Can you please give more details on it Where to go and how to do this Thanks, -Rohit You have to go for reporting services programming and create a subscription programatically and pass the date as a value to subscription's description parameter like this. service.CreateSubscription(reportpath, extSettings, description, eventTy ...Show All

• Chimme KB918222 Windows 2003x64 R2 fails

  When I try to apply this post SP1 patch to SQL Server 2005 x 64 on a Windows 2003x64 R2 system it fails everytime. The following is the HOTFIX log: 07/12/2006 15:02:06.781 ================================================================================ 07/12/2006 15:02:06.781 Hotfix package launched 07/12/2006 15:02:08.046 Product discovery successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 SP Level check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product language check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product version check successfully completed during the install process for MSSQLSERVER 07/12/2 ...Show All

• Manivannan.D.Sekaran Optins of trailing Database change in sql server

  Hi All, I am in need of some option using which i can trail the changes made to my database. Specially i want to track all the DDL and DMl changes. I know about the external tools provided by lumigent and some other companies to do this but i was just wondering if we have some option within sql server. I don't need extensive report as provided by lumigent. Just getting somethin on DDL and DML will help.  Even help on some work arounds to do same will be appreciated. TIA Prashant   Thanks for all your valuable suggestions. One thing i like most about this gropus is you get instant feedbacks. It is really appreciated A DDL trigger is defined on a database level, I guess you ...Show All

• KidVB how to setup local SQL Server 2005 DB

  I installed 2005 Developer edition on a local workstation in our lab. I can connect to a network SQL Server with it just fine. But I do not have a local instance of SQL Server on this workstation. How do I create a local instance of SQL Server (box is WinXPPro-SP3) After accepting the defaults for this installation, I noticed that there were no "local" instances of SQL server available, whereby I could go out and create my own test databases locally or copy a few tables from a production server over to my local box for testing. I'm looking through the books online and do not see (maybe I missed it) the steps to creating a local instance for setting up a workstaiton as a 'test' environment. Assistance is appreciated. R ...Show All

• The Loiner ADOMD and XML/A

  Hi, I got the following from a Microsoft Technet Chat - "The advantage of XML/A over ADOMD is the thin client. ADOMD requires PTS and ADOMD installed on all client machines while XML/A would only require an XML parser." Now say, I develop an asp.net application which would use adomd.net to get cube data, and will also run mdx queries. I host the asp.net page on my server, and allow it to be accessed by remote users. My server itself contains all the necessary cubes, and other components like adomd.net, etc. My question is, if you want to run the asp.net page hosted on my server, (via HTTP), will it be necessary for you to install the adomd.net components on your local (remote) machine also (Actually I dont ...Show All

• Igor V. Lemsky derived column: expression question

  The following simple expression is not working for in a derived column transform. I have tried several things back and forth with lots of frustration. DAY((DT_DATE)mydate) In fact any of the date/time functions are not working for me and I keep getting the following error [Derived Column [380]] Error: The "component "Derived Column" (380)" failed because error code 0xC0049067 occurred, and the error row disposition on "output column "Derived Column 1" (824)" specifies failure on error. An error occurred on the specified object of the specified component. mydate happens to be imported as string[DT_STR] column from a flat file source. Thank you in advance. Make su ...Show All

• Tamila MDX: Percentage-to-totals with subcubes (AW code sample)

  I need to create a calculation that gives me the percentage of a members value relative to the total. My problem is that I cannot make it work when my query is using a subcube in the from clause. The calculated member is simply not able to look outside the defined subcube. In other words - the following query works as expected: WITH MEMBER [Measures].[Test] AS [Measures].[Internet Sales Amount]/( ROOT ([Product]),[Measures].[Internet Sales Amount]), NON_EMPTY_BEHAVIOR = [Measures].[Internet Sales Amount], FORMAT_STRING = "#.##" SELECT {[Measures].[Internet Sales Amount], [Measures].[Test]} ON 0, NON EMPTY [Product].[Subcategory]. MEMBERS ON 1 FROM [Adventure Works] WHERE [Prod ...Show All