Answer Questions

• Stigmata Show multiple order records in single row

  I have two tables CompanyTab and OrderTab .CompanyTab table contain one record for each client while OrderTab table contain multiple orders for clients. I have data in both table like CompanyTable ID Name 1 name1 2 name2 OrderTable OrderId CompanyTabID 1 1 2 1 3 1 4 1 In my query I want to show all orders in single row. ID Name Orders 1 name1 1,2,3,4 2 name2 null Is anybody can help on it. Thanks Arvind There is n ...Show All

• DORANGE Created table in SQL SERVER EXPRESS but don't see it

  I installed SQL SERVER 2005 Developer Edition over SQL SERVER EXPRESS in order to get the Management Studio. I created a new Database called TRADING. I then started a NEW QUERY and created a table and inserted 2 rows. I then selected from the table and got 0 rows . I then went to Trading database on the left side and clicked tables and did not see the table I created. What am I doing wrong. SHould I remove SQL SERVER EXPRESS and then install SQL ...Show All

• Kevin Mulvihill Volatile parent key

  I get this message every time i start Server Management Studio Express CTP, i have lates download ie 11/11/2005 V2. Can not create a stable subkey under volatile parent key. I click continue and Server Management Studio Express CTP seem to start OK. Can you help with this. I don't know much about how the registry editor works. Can you be a little more detailed Here's what I tried: Open registry editor by ...Show All

• K.Paing DATABACK UP

  How can i backup the full database to another diffrent server how to Passing the NEW destination of the Data and Logfiles Sure, there can be a problem if you restore the database at another server because the original pathnames are stored in the backup media as well. So by default the restore want s alsways to take place in those directory, which normally don’t exists. Perhap ...Show All

• Takalth Flat File Source Queston

  I want to read the following file using the Flat File Source flow: 10000 Router 20000 Hub 10000 Switch 30000 Server 40000 Harddisk Spaces are used between the numbers (e.g. 10000) and the following text (e.g. Router). Each line is temrinated by a {CR}{LF} pair. I would normally think of this as a "fixed width" file. But in the Flat File connection manager, if I use format "Fixed width", the preview shows a ...Show All

• troy anderson UDF or trigonometric functions in an expression for a Derived Column?

  Hi all! I am importing data from a CSV to a DB with a SSIS package. Among some things things it already does, it has to decide if the relation between one row and the following is acceptable. If it is not, the 2nd row is discarded, the next one is taken and the relation value is calculated again to decide whether to keep this one or not, and so on. To calculate this value, I need to apply a formula that includes sin(), cos() and acos() funct ...Show All

• Prakash Channagiri - MSFT SQL SERVER database DIAGRAMS problem...

  Hi all,  i m trying to create database diagram but as soon as i click on DATABASE diagrams it gives me the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database ...Show All

• simple Compatibility Level SQL Server 2000 (80)

  Hallo Everyone, I have an SQL database that I need to detach from an SQL2005 server and reattach to an SQL 2000 database. I tried to set the Compatibility level from SQL Server 2005 (90) to SQL Server 2000 (80). This did not work Any ideas Nigel... How are you trying to do this   Try setting the compat level to 80 when attached to SQL Server 2005, and then attach to SQL Server 2000. Peter ...Show All

• zaib_47 Query Designer in SQL 2005 Mgmt Studio a let-down?

  Greetings, all. Thanks for all of the great postings in this community. However, one question I have doesn't seem to have been addressed. In SQL 2000 Enterprise Manager, a user could right-click on a table, and choose Open Table>>Query. This option brings the user directly to a query designer very similar to the query designer available in SQL 2005 Management Studio. However, I have been frustrated by the following: - The Open Table ...Show All

• DimTim Exception.Data[key]=value

  Hi. Is it possible to transmit custom data from SQL 2005 to the client via Exception.Data [key]=value The idea I have a number of SPs that accept userId parameter which must be verified. I have written a simple CLR SP ( check_userid_valid ) which performs the verification of the userId parameter's value. If the parameter's value is considered invalid an exception is thrown. When the exception ( System.Exception ) is instantiated additional ...Show All

• ShadowChaser Bug? Inserting columns into ColumnCollection always appends...

  Hiya, I'm trying to insert a column into an existing table using the overloaded Add methods (once with index, once with previous column's name), but after I call Table.Alter(), the column is simply added at the end of the table. Full code: Server s = new Server("localhost"); Database d = s.Databases["Test"]; Table t = d.Tables["Test"]; t.Columns.Refresh(); t.Columns.Add(new Column(t, & ...Show All

• Axelino Unhelpful error message

  I've just got the following error message from a script component: "The value is too large to fit in the column data area of the buffer". How difficult would it be to get the name of the column in question. Seeing as its metadata of the component surely it can't be that difficult I'm making an assumption here I admit! -Jamie Jamie, Yep, not a very good error. This one sounds like it could be easily improved, but that may be deceiving. W ...Show All

• ranganathanmca Implementing message queue in SQL Server 2000

  I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELE ...Show All

• Hongtao Liao What is the best way to return boolean logic from a UDF?

  CREATE FUNCTION MyBoolean(@p1 varchar ( 255 ),@p2 varchar ( 255 ) ) RETURNS bit AS BEGIN DECLARE @b bit SET @b= 1 -- plus other heavy logic RETURN @b END GO then call this in a CASE or IF-ELSE this: IF MyBoolean('foo','bar')=1 THEN ... Is there a better way to return and use boolean variable like other programming languages(like c# or vb, that have a true boolean data type ...Show All

• abc23 SSIS error listing

  Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere Indeed, it seems SQL Server CTP shipped without error code #defines in header files in SDK directory \Program Files\Microso ...Show All