Answer Questions

• Daniel S Random Errors

  Can anyone tell my why I'm getting these first few errors   IT seems to be preventing my SQl Agent from successfully firing off my SSIS package:   01/04/2006 09:53:48,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect 01/04/2006 09:53:48,,Warning,[260] Unable to start mail session (reason: No mail profile defined) 01/04/2006 09:53:48,,Information,[129] SQLSERVERAGENT starting unde ...Show All

• nick di pietrantonio Memory Configuration

  How do I configure DTS 2005 to not consume all the memory on my machine when processing large tables I have 1 table that is particularly large and it causes DTS to run out of memory when it tries to extend its internal buffer during a sort merge. Thanks! I am running the June CTP. Studio 2005 Beta2.050215-4400 .NET Framework 2.0.50215 Integration Services (Version 9.00.1116.00) ...Show All

• RyanB88 XML not loading into SQL Server, because identity not incrementing

  I am having an issue loading data into a SQL table from an XML file. I have a Customer Table and a Phone Table related by a customer ID key. The primary key of the phone table is an autogenerated numeric field.  The identity of this field is set to yes, and the seed and increment are set to 1.  The foreign key relation is the customer ID. I am using the following script to read the XML file and pass the data to the database ...Show All

• fparc regarding sqlserver2005 clientserver installation

  How to install sqlserver2005 As Andreas Johansson mentioned, it is easy to install SQL Server 2005. Please also take care of the following issues. More information can be obtained from Books On Line(BOL). 1. The minimum hardware and software requirements. For example, SQL Server 2005 Enterprise edition can be installed on Server Operating Systems such as W2K Advanced Server SP4 and W2K3 EE SP1. 2. On your media, go to the server di ...Show All

• DNA20 Sql Server 2005 -- Select permission denied

  We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively simple to solve, yet I have been banging my head against the wall for a couple of days.  After changing the c ...Show All

• Muhammad Asif Junaid Running SQL Server on a Desktop Machine

  Hi, The company I work at was going to install SQL Server 2005 on a server running Windows Server 2000. However this server is no longer available, and due to cost restraints we are unable to purchase another server. I still wish to get SQL Server 2005 running, and have a spare desktop computer avaible. This computer is a P4 3.2GHz with 1GB of RAM and 40GB hard disk. I was thinking of adding RAM and a larger hard disk, and installing W ...Show All

• Dalton D. Franklin Mirroring, Snapshot Replication, load balancing and other BIG questions

  You will all have to excuse my ignorance. I'm a developer who also doubles up as a development DBA. I am however not particularly knowedgeable about all the really important DBA stuff. We've built a small BI solution using SQL Server 2000. Our problem is that our server is getting on in years (5) and doesn't really have enough disk space or grunt. We havce a number of summary cubes that we've optimised quite successfully but our billing line ...Show All

• zhongzhong Running Sum on DataReport

    Hye Guys,        I am a beginer programmer.. I have started 2 build a simple database application. I am now in the stage of showing the data in reports 2 print. I am suggested to use datareport available in VB. I also did my some of the report in it. It worked fine. But now I am stucked in one step..of displaying the calculateable field in the detail section.. Eg. in database: Item   & ...Show All

• Mike Kidd closing pipelinebuffer

  Is there a way to signal to the PipelineBuffer during ProcessInput that no more rows are necessary Say I have a component's output connected to a custom destination component... in the destination component's properties, I can set the number of rows I want to consume.  (The first 50 rows for example.)  If I do it this way, the source component continues delivering rows - I can set my destination to ignore all rows after 50, but would ...Show All

• Dustin Smithers Reporting Services 2005

  Can I install and run Reporting Services 2005 on a SQL 2000 server currenly running RS 2000 Not sure I understand   Can I move my existing reports to RS 2005 Sorry, your original message wasn't clear enough, so I thought you wanted to run SSRS 2000 and 2005 at the same time on the same machine. Evidently, you just want to upgrade. Yes, 2000 reports can be published to 2005. They will be automatically updated so they work in 2 ...Show All

• drc234 obtain the name and path of a report

  how to save the name and the path of a report on my database when the user click save report I need something that doesn't depend on a stored procedure or manual procedure. I need to execute something when the user saves the report; something that returns the path for this report. I need to generate in my website all paths for reports recently saved. thanks again and I’ll be waiting for your answer ...Show All

• Roman T connecting using "datasource=localhost"

  hi all, i'm running VS2003.NET with SQL2000 on XP. when i try to use "datasource=localhost" in my connection string- i get "SQL server does not exist or access denide". (local) works and "=myServer" (server name) works. my hosts file is as it should be. i'm trying to connect to the server on my machine. i use to have no problem with it in the past. i think it all went to **** when i changed my machine's nam ...Show All

• Dobriendob Deploying Jet OleDb Provider

  If I'm posting to the wrong forum, please correct me. I'd like to use an Access database for an application I'm developing for retail sale, and I need to do these things: Determine during setup if the target machine has the Jet OleDb Provider installed. If so, determine whether the version is adequate. If necessary, install the correct provider. I don't seem to be able to find any documentation or downloads covering this scenar ...Show All

• Lucky_Luck vs 2005 august ctp with sql express

  Hello, the dvd of august ctp comes with sql express but it just doesnt want to install. Are there  any known issues about it I tried to install sql express june ctp and it says that I have  previous components from vs 2005 or sql, I ran the build cleanup configuration wizard from june ctp sql 2005 and it removed 2 components, after it I tried to run sql express june ctp again and it has the same errors. What do you recommend me When ...Show All

• Amit Banerjee - MSFT Failed to generate a user instance of SQL Server

  Hi, I have visual basic team 2005 beta that come with sql server express, and i am trying to connect to a database on my local computer. And i get this message "Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed". If u ever heard of the Northwind database it is the one i am trying to use I don't know much about how to configure server, but i ...Show All