Answer Questions

• Deadman Walking How to excute package in sequence

  How to excute package in sequence . i have an requirement like this the package should execute in a sequence 1.PKG1 2.PKG2 3.PKG3 and in some case PKG1,.PKG2,.PKG3 shoule run parallel. Thanks & Regards Jegan.T Jegant wrote: How to excute package in sequence . i have an requirement like this the package should execute in a sequence 1.PKG1 2.PKG2 3.PKG3 ...Show All

• Chuck Reynolds Basing Report on a Procedure with Cursor

  I need some advice on how to design a report using cursors. Is it possible to base a report on a cursor I would think that I would have to put the cursor into a stored procedure and call that procedure. But if I do use the cursor in the procedure, will the looped variables automatically populate the report or will I need to insert them into a table that populates the report Thanks, cj If the data ...Show All

• Anthony Hull Query behaviour

  Hi there, I wonder if one of you worthy folks can help me out with some strange behaviour exhibited by a piece of SQL. Its my first post here , so please be gentle. Here is my simple example :- <my test table> create table test (ind int, message varchar(255)) insert into test (ind, message) values (1,'date=01/06/2006') insert into test (ind, message) values (1,'date=20/12/2005') insert into test (ind, message) values (2,'test') The fir ...Show All

• colin please Can SQL Server 2005 Express coexist with SQL Server 2005 developer edition?

  Can SQL Server 2005 Express coexist with SQL Server 2005 developer edition on the same PC Check the file template.ini (at the same location as setup.exe) for all parameters and sample command lines to setup SQL Server 2005. By default, SQL Server 2005 Express is installed as a named instance with instance name "SQLExpress". So if SQL Server 2005 Express is not i ...Show All

• manhatma unreceivable messages

  Hey guys I have another weird looking problem I have a queue with a certain number of messages waiting in it to be processed. When I try and receive a message from this queue, I get back an empty row; no message. However, when I try and select from this queue, I see all the messages in there. Even sp_spaceused reports that there are rows in this queue. The status of each unreceivable message is 2. What would be the reason why I c ...Show All

• Will139 Install or uninstall .NET Framework 2.0

  I want to instal Sql Server express, problem is On this link http://msdn.microsoft.com/vstudio/express/sql/download/ , they say you must uninstall any previous versions of  ...  and the .NET Framework 2.0. Yet here on step two in the instruction section in this link  http://www.microsoft.com/downloa ...Show All

• StLuisRey Could not complete cursor operation because the table schema changed

  Microsoft SQL Server  2000 - 8.00.2039 Got this error: Could not complete cursor operation because the table schema changed after the cursor was declared. SQLCode: 16943 SQLState: HY000 Is this a known issue   I suspect the application logic may cause this error. Please advise. Thanks a lot!   Could you also update me if you get an answer on this. I am also facing similar issue. My system is throwing th ...Show All

• curtmack SSMS/"Report" button... is it possible perhaps to customize those reports or add new?

  Hmm, In SSMS on the Summary tab there is a nice little button called Report.. where a number of reports available for admin. Good addition. Nice. Here is the question to all... can one customize these reports or maybe even add some additional a.k.a custom-build reports to this "menu" button Maybe this question should be addressed to VS team. Anyway... anybody hacked the SSMS to find out what level of customization can it ha ...Show All

• arganx In SSRS'05 report, how to repair a corrupted SSAS cube dataset

  After building an SSRS 2005 matrix report on an SSAS 2005 cube, I added a new calc'd measure to the underlying SSAS cube with the intent to add this field as a detail in this same report. After adding it in the cube itself, I returning to the report's data tab, found the new field and dragged it to the main (BLANK) screen (the "Drag levels or mesaures here to add to the query" screen) to add it to the query. In the layout tab, I then a ...Show All

• mball Maximum Capacity supported by SQL Server 2000 Enterprise under Windows Server 2003 Enterprise

  Hello Does anyone know what is the maximum capacity supported by SQL Server 2000 Enterprise Edition running under Windows Server 2003 Enterprise Edition in terms of number of CPU and amount of RAM. For CPU : Windows Server 2003 EE supported up to 8 CPU so I assume SQL 2000 Enterprise can also support up to 8 CPU For memory: Windows Server 2003 EE (32 bits) can support up to 32 GB of RAM so I am wondering whether SQL 2000 EE can also su ...Show All

• RobinsonT Error evaluating expression

  Greetings my SQL friends. Why do I get an error message saying that the following expression won't evaluate "Select * from Price_grp where price_grp_id >= " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] + " and " + (dt_str, 10, 1252) @[User::MIN_PRICE_GRP_ID] + " > 0" Thanks for your help in advance. Do you still have a note of the error message you had when it would not evaluate Donal ...Show All

• AhmadOOka SQL 2005 woes

  I installed VS 2005 & SQL Server 2005. When I use SQL Server Management Sudio,  I can create a new database in SQL Server 2005, but when I try to create a new table in that database, I get the following error: "Class does not support aggregation. Microsoft.Sqlserver.Sqltools.VsIntegration" any help would be appreciated. Thanks TITLE: Microsoft SQL Server Management Studio ------------------------------ ...Show All

• C# nb Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Guys, there are thousands of interfaces registered on a typical Windows box. The error can be caused by missing registration of any of them. We've found that particu ...Show All

• bobm SQL Express Start

  I downloaded SQL Express, but find nothing but SQL Server 2005 in my All Programs menu, which only gives me configure options. None of the configure options has an interface where I can create a sample table or work with tables. Please tell me what I am missing and if there is any doc that steps you thru starting to learn and use SQL Express. Thanks for any help on this from a real beginner. SQL 2005 ...Show All

• Milan Dimitrijevic How do load all raw data in one directory into the database

  Hi, Is there anyway to load all the raw data in one directory into the database l've several files with same format but different filename in one folder which l do not know their filename before hand. Is SSIS For Each Loop can help me to accomplish the file loading If so, where can l find the example Thanks you. Regards, Yong Boon, Lim Yes, For Each loop is the one to use. Looping over files with the Fore ...Show All