Answer Questions

• Mark McCasland Help me!emergency!

  dear: can anyone tell how to connect to Microsoft Mobile Server 2005 using System.Data.SqlceConnection or using System.oledbConnection connect to Microsoft Access DataBase in Pocket Pc or windows CE program dose there any minimum requirements i need to install would you like to list a list for me thanks alot. If you are using Visual Studio 2005 that has Smart Device programming support, you are ready to develop again ...Show All

• igorbaIT Images not being displayed.

  1. I am using the webservice to render the images from a report, and they dont render. I paste this URL to the browser http://agamenon:90/ReportServer %2fGescomRpts%2fRPT_MediosDesarrollo&rs%3aFormat=HTML4.0&rs:ImageID=6c809239-753f-4988-abcf-231416dff0d6 and I get this No se encuentra la secuencia. No se encuentra el identificador de secuencia proporcionado a una operacion en la base de datos del servidor de informes. (r ...Show All

• sassenach Passing data between multiple Data Flows

  OK, it's the first of the month...that must mean it's time for another dumb question! I'm trying to "componentize" an SSIS package with multiple Data Flows, and I can't figure out how to get the output of the results from one Data Flow into another. So, for example, at the end of one Data Flow, I have a Recordset destination, and I'm storing that into a variable.  But I can't figure out how to access the contents of that variable in th ...Show All

• Sanjoy Debnath DTS in SQL 2005

  Hello, This is kind of a stupid problem. I just installed SQL 2005 Standard and I am trying to use DTS to transform a Access DB to SQL. I am having a tough time finding where that feature is. Is it by default insatlled or is it an add-on Thanks! Thanks for the reply. I am in the process of using the "Upsizing" wizard to convert to the SQL. It is exactly what I was looking for. -Mac ...Show All

• chris.kuang SCD component in SQL2005

  Hello, I have problems specifying my historical attribute in the SCD component. Regardless of wich option I choose on the Historical attribute options I cannot choose a field in the table, it is simply empty, nor can I write in the information... I am using the 1st release version so I suspect that this function should be fully functioning. What am I doing wrong and how should I go about this Hanna,  The scenario  ...Show All

• J Tatta Help,Does embedded code supports DCOM?

  Reportings services does support embedded VB Code and custom assembly;Can I use a custom assembly or embeded code to call into a DCOM or retrieve data from any DCOM ...Show All

• Blanca Flores Creating relationships between 2 databases

  Is it possible to create relationships and enforce constrains thereof between two fields with the same data type from 2 different databases ( i.e. 2 different .mdf files ) altogether, attached to an instance of SQL Server 2005 Express This would help overcome the limitation of the 4GB database size it imposes, by splitting the info required into different databases, rather than just different tables. All the relationships could be then created ...Show All

• whizkid Need better workaround for hidden prompt without read-only behavior

  I have many reports that have a parameter in them which I want to default to NULL and not show (plus other parameters I do want to show). If I leave the prompt field empty, I get the read-only error. The workaround has been to have the prompt field contain a single space, which works well as far as producing the behavior I want. However, every time you open the report in the designer, it automatically removes the space. ...Show All

• Avi harush SSIS and Parent-Child relationship tables

  Supose I have two records in a parent-child relationsuip (actually I have many more such records). Does SSIS offer any support\task for inserting one record into the parent table, the other into the child table, and updating the foreign key of the child to point to the parent TIA, Barkingdog P.S. I have to do just this as part of the datawarehouse test I'm running. Seems like a common task but I don't recall anything in SSIS addressing ...Show All

• Hannotje How to turn off Auto Recovery in SQL Server Management Studio 2005?

  Auto Recovery kicks in about every 5 minutes in SQL Server Management Studio 2005. Over a slow network connection, SSMS stops responding until the Auto Recovery completes. Auto Recovery can be turned off in Visual Studio 2005 but I have been unable to find how to turn it off in SSMS. Go to server->Properties dialog and go to connections tab and you can change the recovery interval here. Gops Dwarak ...Show All

• Esrar Chowdhury Database Mirroring with multiple websites

  Hi, it's real strange that there are currently no questions in the whole of the SQL Server section. That has to change! Anyway, here's a scenario.  There's a website we are developing, which we expect to have a high load.  the site is being developed with ASP.NET 2 & SQL Server 2005 and will probably be complete some time early next year.  However, we've already started thinking about deployment issues as these will greatly af ...Show All

• Kiwi86 Parse error

  Can anyone tel lme why this does not parse in 2000 but works fine in 2005 ALTER TABLE Segments ADD CONSTRAINT PK_Segments PRIMARY KEY CLUSTERED ( SegmentsUniqueID ) WITH ( STATISTICS_NORECOMPUTE = OFF , IGNORE_DUP_KEY = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] thanks The WITH options cannot be set like this in SQL Ser ...Show All

• Michael J. Liu transfering multiple objects to another schema

  I want to delete a user on local but in order to do that I apparently need to delete the schema. The schema has many objects in it. Can I and what is the syntax to move multiple objects from let's say XXX to dbo so I can delete the schema XXX Thanks! Did this solve your problem Mayomano Regards, Mike Wachal SQL Express team ---- Mark the best posts as Answers! Hey Mayomano, Check out ...Show All

• Prabs Using Message Queues in stored procedures

  Ok, I'm stumped.  I have a database which has a table that stores documents.  Each document has a primary key.  For years, I've been notifying an external program that a new document has arrived in the db by firing a trigger on the table.  Trigger calls xp_cmdshell, which calls an external program which enqueues a message on a message queue. This code, which has been running fine in SQL 2000 for ~5 years, completely crashes ...Show All

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