Answer Questions

• Rinter21 how can i use The "Use Database" statement >>>

  the question is how to use use database statement if the name of the database contain spaces please help me Thanks why all this my friend !! don't exaggerate i'm tried to write the following statement before : Insert Into [My DB].MyTable(No) values 6 and the compiler refuse the statement .. so i send for help Frank Kalis wrote: CREATE DATABASE [I SHALL NOT USE BLANKS IN ANY OBJECT ...Show All

• DanL43 raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt Have you investigated why it is not working If the file name is invalid, is the variable getting set correctly Some ideas- Set a breakpoint on the PreExecute event of the Data Flow and when broken drag the Raw ...Show All

• CAM SQL Server CE and Memory Issue

  Hello, Have a query that consistently gives back the following message. Not enough storage is available to complete this operation The query I'm using is a little more complex than what I'm usually using. It uses Case, has extra characters in the formatting like (i.e. '-------'), connects 2 databases. Free memory can be as much as 3 MB  on the Pocket PC before sending the query and I can still receive the above message. Was wondering if t ...Show All

• Don Stewart Script Task Not Updating Package Variable

  I am trying to update a package variable. The package consists only of a script task and a package user variable. I have included the variable, myVar (scope: package; type: string), in the ReadWriteVariables property of the script task. The only code I have used, in Public Sub Main, is: Dts.Variables( "myVar" ).Value = "2" The package runs successfully but the variable does not change. I thought that maybe the underlying value reall ...Show All

• jmlsteele Using Unicode in SQL Server

  Hi I'm have big problems trying to save Unicode information into my MS SQL Server 2000 Desktop Engine. Alright, so the problem I'm having now is I'm working with MS SQL 7.0 and PHP5. I've trying to get information to save into MS SQL, however it is storing it all weird. When I save the information and try to view it in Enterprise Manager it shows it has random characters but for some weird reason I can output that information on the page ...Show All

• R1ZWAN getting calendar control in sql reporting 2000

  hi all i am working on sql reporting 2000. i have a parameter with datatype datetime. is there any way by which i can get calendar control for this parameter when it is displayed on report plz help me.I can't proceed further without this. Sorry, builtin support for the calendar control for DateTime parameters is only available for RS 2005. For RS 2000, you could build your own application for the p ...Show All

• RPaton Help with Error

  I've installed SQLExpress on two machines.  Both with no problems, except on one machine I noticed the following error w/in Events -Applications: FCB: : Removealternatestreams: Operating system error 6 (The handle is invalid) occurred while creating or opening file 'C;\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mater.mdf" This message is for: Master, Model, Temp, etc..... Basically, it's telling me that they aren't start ...Show All

• Jay T Sequel 2005 installation Perflib problem

  Hey everyone, I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL ...Show All

• Javen How to run SSIS package

  How can I: 1) Create a Job in 2005 to run my SSIS project   Specifically syntax and where I would place the all in the job's properties 2) Can I run an SSIS package from the command prompt   what would be the syntax this is a dumb question but how do I run those paths to get to your URLs above You should read BOL as it has extensive information on these topics. 1) ms-help://MS.SQLCC.v9/MS.SQLS ...Show All

• Gianluigi.Zanettini Creating DB from scripts

  I'm using an integration project to recreate a db as needed from all the scripts i've previously generated.  I'm encountering an error when the tables get built in the wrong order because of foreign key constraints. Does anyone know of a way to programmatically execute the scripts of sql tables that don't violate the constraints; so after, I can execute the other table create scripts   Any help or guidance in any way wou ...Show All

• Debutant0 FlatFile Parsing Problem - Urgently Need Assistance!

  We have a BIG problem that has been occurring for quite sometime. We have a RAGGED-RIGHT FFS (FlatFileSource) component which receives a FF and then transforms to XML. We define 10 FIELDS with the last field as {CRLF} per ragged right style. Simple right The source file is sent to us from multiple separate groups, some of which don’t use the last two fields and have early line termination, so they basically are not there. The problem is that wh ...Show All

• bigwes99 Cross Row Referential Integrity

  In SS05 XML typed columns, is it possible to have cross row constraints and referential integrity Say I have a column with two schemas: Author and Book. Each has an ID. Each row in the table has only one author or book. Can I enforce that all Author ID are unique across all rows and that there is an author for every book Is it possible now If yes, how If no, is there a plan to add this feature in the future Is there any work around now ...Show All

• Girish HK operationg system requirement

  I am in the process of learning SQL from scratch and figure it would be helpful if I can run a local server and experiment with it as I move along some book reading. I have a few questions regarding the operating system requirement for running a localhost server and hope some of you can answer to my novice questions. Can I setup a server under Windows XP when I looked thru the documentation it indicated only windows 2000 and other Microsoft serv ...Show All

• Shughes Problems Using Temporary Tables

  I am declaring a temp table in control flow via Execute SQL task. I then want to use that table as a source in a data task, keep it alive going back to control flow and use it as a destination in another data task following. I am having trouble just getting the first data flow to access that temp table. In my Execute SQL task, I'm creating a simple temp table. After executing that task, I can head to the data task and change my OLE DB Source to ...Show All

• Tpzguy Recovery Model of Subscription Database

  Hi: I am having lot of log problems with Subscription databases. Currently all my subscription databases are on Full recovery mode. I am thinking to change them to simple because I don't I will be doing point in time recovery of them. Do the subcription databases have to be on Full mode Can I change them to simple to keep my log small and then I do not have to backups of my logs also Please let me know. Thanks M ...Show All