Answer Questions

• MoFoQ Task Expression Evalutation Time

  I have designed a package whose first step initializes several variables .  Other steps in the package have expressions based on those variables. Example Expression for MyTask:    PropertyName = "Disable"    Expression = "@DoMyTask" Given this example MyTask will be enabled/disabled solely based on the value of @DoMyTask at the time the package execution begins.  Changing the value of @DoMyT ...Show All

• chribonn Can't Deploy AdventureWorks Database

  Hi All, I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio. For some reason, I encountered the following error (after deployment during processing): Error 1 OLE DB ...Show All

• JimMcGill 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

• Sr Rob How to intentionally cause a package to fail using a SQL Task

  I'd like to use a SQL Task to execute a stored proc, which checks for a value, and if I don't like the result, raise an error. If the stored proc fails I'd like the package to fail as well. When I run the stored proc outside of the package, it fails as it should. However, when I run it in the package, the package does not fail. It moves on to the next task and completes normally. Any ideas on what I may be doing wrong Thank you, Perry ...Show All

• killerless CPU limitations of SQL express

  I had a question about the CPU limitations of SQL express. It says limited to 1 CPU but what if I have multiple instaces since the application is a new service and runs in it 'sown memory space how is it limited to 1 CPU does the service use multiple processors and the queris are binded to one Thanks Hi, SQL Server will ignorte the other CPUs. if you have another edition on the server it could keep tra ...Show All

• OOC# disk outage and the database

  I was at the SQL Server launch in Detroit and they talked about if a disk outage occurs with SS05, then the database doesn't go down, just access to that data. So, it was conveyed that in SS00 the entire database is lost. For SS05 however, whenever someone talks about this feature, it was always with table partitioning. Is this just conicidence, or something that table partitioning helps with and you need it If I didn't use table partitioning, ...Show All

• Saurabh Dhall how can i use the " use " statement with database-name contains spaces in sql2000

  example : i cann't write : use [my db] what can i do with this problem That works for me: use [master] CREATE DATABASE [Some DB] USE [Some DB] SELECT DB_NAME () ---------- Some DB ( 1 row ( s ) affected ) USE MASTER DROP DATABASE [Some DB] What error are you getting back Regardless of the possibiliy to put a space in the name, this is NOT recommended. It might work in t ...Show All

• cybercrypt13 Copy database Wizard error: "Class not registered"

  Hello, I use Management Studio (SQL 2005) on my desktop wich contain also Enterprise Manager (SQL 2000). The SQL Server 2005 is on a server in our network. When I try to use the function "copy database wizard" to transfer a database SQL 2000 to SQL 2005, the wizard stop with this error: "Class not registered Program Location:    at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents eve ...Show All

• vidashgan Stored Procedure Problem - Couldn't find forum specifically for SP's

  Help me please. I have created a stored procedure and I'm not sure where I am missing the syntax problem. I am fairly new to SQL and have tried to research this problem and cannot find anything helpful. Basically I have to pick the results from the same tables but have a trigger of "hotel" and "not hotel" basically. I have to have one record return that pulls from two records in the same table. I think I have a major probl ...Show All

• gdf SQL Server datetime question

  I have a table in the database. One of the column is of datetime type. What is the best way to insert and retrieve value from that column. Here is the scenario 1) I want to insert value '02/03/2006' into the column. How does the sql server know that the month is 02 and not 03. Will it look into the system settings. If so then can I sepcify custom format to distinguish between month,day and year. 2) I want to retrieve value from the date ...Show All

• Imesh instawdb.sql runtime errors

  I just downloaded adventureWorks database related files and ran script in instawdb.sql. It seems the database and tables have been created but some errors have taken place as well. I am working with Sept 2005 CTP SQL Server. *** Creating Data Types -- FINE *** Creating Pre-Table Database Functions -- FINE *** Creating Database Schemas -- FINE *** Create AdditionalContactInfo schema -- FINE ........ *** Creating Tables -- FINE *** Loading Dat ...Show All

• Ant999 Server Mgnt Sudio and Query Filenames

  I was never able to discover a way to have the default file name be the name of a procedure or function (with a .SQL extension) when I opened them under QA. I was hoping it would be easier under SMS. Is there some way to have the tabname/filename default to the stored procedure or function name when you open one to modify Thanks ...Show All

• MisterChief Tell to split on change of ID

  how can I tell the conditional component to split the records based on change of hdr_HeaderID http://www.webfound.net/split_on_headerid.jpg let me know if you need more info...   here's what I'm trying to do...this is the best way I can think to do all this via your articles I read...I'm still new to all this remember so this may not be correct but here's what I'm working on as the solution at the moment but failing miserab ...Show All

• ajp Processing jam-up

  We have a number of jobs that process cubes when table loads complete. The last step in each of these jobs is to reprocess a "verification cube", which contains as linked measures the record counts from ALL other cubes. (We have a report which compares this against a direct SQL record count from the tables). Anyway, we appear to have jammed up our Analysis Server (and had to restart) because one completing job issued a reprocess com ...Show All

• ucnnohm2 cant see Report manager page

  Hi Friends we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !! all they can see is "sql server reporting services" text nothing else. no reports and no models ertc., i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create ...Show All