Answer Questions

• PDACSKIVE HELP!!! Trying to schedule SSIS package

  Hello everybody, I try to schedule a SSIS package. When I run manualy, it works without error but when I schedule it, the step fail with error: "Executed as user:... The package execution failed. The step failed." This package contain just a SQL Task that execute a truncate table (it's for the test...) I try all solution I found in this forum and others but all not works. Have you an idea Thanks a lot Arnaud ...Show All

• jfkrueger119584 How to Delete Files on Maintenance Plan

  Hello, I am creating a Maintenance Plan in SQL Server 2005. The 'Back Up Database Task' has the choice 'Create a sub-directory for each database' as SQL Server 2000 does. But when I add a 'Maintenance Cleanup Task' I do not see a choice to delete files on subdirectories. Looks like it only deletes the files from the directory I specify. So, looks like SQL Server 2005 is removing some functionality already available in SQL Server 2000. ...Show All

• Poor .NET 2.0 app dev manager running DBCC Shrinkfile code, from where?

  SQL2000 Server, SP4, a database with a 17Gb log file. It has been backed up so all transactions should be validated, now the real file size needs to be shrunk because I need the diskspace plus I want to speed up the backup process. http://support.microsoft.com/kb/272318/ Tells me what to do but not where to do it. So I need to run this code : DBCC SHRINKFILE(pubs_log, 2) but from what console do I run it ...Show All

• dude68 Can't Attach Database using SQL Server Management Studio Express

  I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening. If I copy a database to Documents and Settings\All Users\... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and Settings\Default User\... Bu ...Show All

• etherealG Making our SQL Server 2000 application ready for SQL Server 2005

  We have several applications that were developed using SQL Server 2000.  Most of our customers run MSDE, some the full SQL Server 2000.  We are in the process of making sure our applications will work properly in SQL Server 2005 / SQL Express. I have a few questions regarding this issue:- 1. Should I set the compatibility level to 80 for our databases or should I aim to make our applications work the 90 compatibility level    ...Show All

• wgillin sql mobile database connection on a desktop application

  Hello, Was wondering if its possible with VS 2005 to create and populate a SQL Server Ce database on the desktop Reason why I'm asking is it takes a very long time (~40 minutes) to process xml and insert the values into the sdf database on the Pocket PC. I would assume it is much quicker to create the database and insert records on the desktop. Any suggestions would be appreciated. Thanks Hi, SQLMobile is supported only on devi ...Show All

• Alphi Retrieve Data from Web Services Using DTS (SQL Server 2000)

  The project I'm currently working on involves combining data from one SQL Server 2000 databases and XML returned from a web service into a 3rd SQL Server 2000 database. This process must be scheduled to happen once a day. If it weren't for the Web Service, I'd say that this is a no-brainer and I'd use DTS. However, I'm not sure if I can even access a Web Service with DTS. Has anyone done this or have any tips Id try the microsoft.pu ...Show All

• DPS1963 Welcome and Tips for using this Forum

  Welcome to the SQL Express Forum Hello everyone and welcome to the SQL Express forum. One of the primary goals of the SQL Express MSDN Forum is to offer a gathering place for SQL Express users to share experiences, discuss issues related to SQL Express, ask questions and interact with the folks here at Microsoft. Hopefully everyone on the forum will contribute not only questions, but opinions and answers as well. I’m looking forward to&n ...Show All

• Todd Landstad MSFT How to run DTS package/upgrade in SQL 2005.

  Hi All, I am following instrucation in the following doc to migrate dts package. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp In step 2. Right-click the DTS Packages folder in Solution Explorer and select the Migrate DTS 2000 Package option. This starts the Integration Services Migration Wizard . I don't see "DTS Packages" folder what am I doing wrong. Thank you in advance. Satish Patil ...Show All

• Mukhpreet Memory Error: Dimension Processing on Analysis Services 2005

  Dear Anyone, We have a live server with an 8GB of memory. This box is used by SQL Server 2005 and Analysis Services 2005. We recently encountered the error below. We cant place head or tails to whats causing it. Can anyone please enlighten us Memory error: The operation cannot be completed because the memory quota estimate (1999MB) exceeds the available system memory (1996MB). Thanks, Joseph Try to process your dimen ...Show All

• tflanman New To Databasing

  I have just a general question that I was hoping to have answered about the SQL Server Express edition software. I was looking at the data types that you can select from while creating tables and was wondering about other types of data that it can support. I wanted to find out if it supports audio files as one of the data types. I know from MS Access its a OLE object datatype that supports audio files. Is SQL Server Express even capable of handl ...Show All

• Antons1 100 SQL Databases

  Hello, Can someone show me the TSQL I need to write in order to create 100 SQL databases in one go. I want them to be called DB1, DB2, DB3, DB4...etc etc I know how to create one database; --------------------------------------------------- USE MASTER GO CREATE DATABASE DB1 ON PRIMARY ( NAME = DB1_dat, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\DB1.mdf', SIZE=4, MAXSIZE=10, FILEGROWTH=1 ) ------------------------- But I don't ...Show All

• BrEnO_LEWROY How do you support the Oracle CLOB Data Type?

  I am using VS2005 Analysis Services to create a cube from an Oracle data source. My problem is that 3 of the tables use a CLOB field. So my "Data Source View" can only link to 25 of the 28 tables. Is there a workaround so that I can include the 3 CLOB tables ...Show All

• Joseph D.L. can i get the output of 'sp_columns' system SP into a table through T-SQL

  Hi, I want to collect the output of system stored procedure 'sp_columns' into a temporary table. Please suggest how can i achieve this. Ashu Sharma Thanks Frank Create a temp table with columns as described at sp_columns in BOL and then do INSERT INTO your_temp_table EXEC sp_columns -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de ...Show All

• Roy Chastain Customer Count

  Hello, I have a Fact table containing sales information, and is linked to a customer dimension through a CustomerKey and to a product dimension. The Customer Dimension is a slowly changing dimension having CustomerKey as primary key and CustomerPIN as BusinessKey. A customer can have historical records in the Customer Dimension. I want to count the number of clients per product. If I create a measure Customer Count as Distinct Count on the ...Show All