Answer Questions

• Long Xue Bad Proc Template

  There is a base-installed template for a stored procedure called "Create Procedure with CURSOR OUT" which has this snippet: EXEC < Schema_Name , sysname , Schema_Name >.< Procedure_Name , sysname , Procedure_Name > < @proc_cursor_name , , @sample_procedure_cursor > = < @variable_cursor_name , , @test_cursor_variable > OUTPUT WHILE ( @@FETCH_STATUS = 0 ) BEGIN FETCH NEXT FROM < @variable_cursor_name , , @test_cursor_variable > PRINT 'put user defined code here' END But even after instantiating it - it doesn't work. The "FETCH_STATUS" must be seeded with a prior "FETCH" before it has any meaning. This leads me to ask: ...Show All

• Lars E.Nes Database Documentation

  Hi guys, my manager asked me that to do documentation; right now we are using MSSQL SERVER 2005 Databases, here you assume I am new to make documents on any database but good idea about databases currently that data warehouse in development environment need to done this documentation before go on test environment . So that way you advise me to prepare a document. Here is my main concerned how to start and what things should we keep in mind while preparing document (what are measurements).if you any prepared documents could help to start or there tool we should use (power point) them. any help appreciated Hello - did you get everything you needed I have some more info on building your own documentor here: http://www ...Show All

• thames Local cubes connection

  Hello, I have created 3 local cubes which resided in the same .cub file. The cubes created from AS 2005 cubes. How can I make ADOMD connection to all 3 cubes at the same time in my client application (C#) The problem is that Initial Catalog (database name) in connection string in case of local cubes is the same as the cube name. Thanks, GB You can only have one connection to the local cube file - therefore the second connection fails. Your options: 1. Split it to the 3 different local cube files 2. Put all the cubes in the same database 3. Close the previous connection before opening a new one 4. Keep one connection, but change the current database when you need to go to another one. I have cteated my local cu ...Show All

• Natan Drozd SQL Server 2005 Cumulative Hot Fix doesn't install on x86

  I'm trying to install the cumulative hot fix (build 2153) on an x86 machine. I'm running the first of the six install EXEs, and I'm not able to select any of the checkboxes on the Feature Selection tab of the wizard. I see three checkboxes. The first is SQL Server Database Services 2005 and beneath it two child nodes: MSSQLSERVER (RTM 1399 ENU) and SQLEXPRESS (RTM 1399 ENU) None of the checkboxes allow me to select them and when I click the Next button on the screen I get the following: "You have not selected any active products or instances. You must select at least one active product or instance to patch in order to proceed." Terry, the cumulative hotfix can only be applied after applying SP1 (build ...Show All

• Niall83 Extracting Contents of Object Variable in script Task

  Hey Guys, Im pretty new to Scripting in SSIS, but i have worked a fair bit out already, although i am stuck with the following problem.. If anyone can help out that would be great!! Ok, i have a package that loops through records in a table, and extracts the detailed lines in a For Each loop. and stores them in a variable called DetailRecordSet with an data type of object. I have a built a script task so that i can send out an email confirmation for each order, and i want to list the details in a HTML Table in the body of the message ( I have read that the standard send mail task wont support this, but found an example of using .NET code to generate the email message which will support it) . What i want to know is how do i refe ...Show All

• dgolds File System Error: The record ID is incorrect

  Hi, We have deployed SQL Server 2005 with Analysis Services and Reporting Services. When running a report, we get the following error: An error has occurred during report processing. Cannot read the next data row for the data set DM_GASTOS. File system error: The record ID is incorrect. Physical file: . Logical file: . The error occurs both with a local user account and domain user account. The user account is member of a role which has Cell Data Security restriction in Analysis Services. When other member run the report, the error goes away. Anybody has seen this before Any solutions Cheers This looks like a data corruption issue. Try fully re-processing your entire database. Edwar ...Show All

• Dhaval Patel Anyone know a self extracting tool for a zip file?

  I have a zip file that requires a password to extract the file inside of it. Is there away to do this automatically Can't find any software that does this. Mike RedCritic wrote: Thanks for the example. So, what would be the syntax for zipping each individual file in a directory Depends on the tool you're using. expression: " e " + @[User::ZipFileName] + " -y" + " -ptestpassword" evaluates to: "C:\Program Files\7-Zip\7z.exe" e "D:\Test\Dropoff\update2.zip" -y -ptestpassword you might want to try getting your command to run from a dos prompt. once you verify it does what you want, create the expression to duplicate ...Show All

• salafa SQLFetch and SQL_NO_DATA

  hi all~ struct user { unsigned int uid; unsigned int auth; }; int funct(int idx) { struct user usr; SQLINTEGER ret[2]; SQLBindCol(hStmt, 1, SQL_C_ULONG, &usr.uid, 0, &ret[0]); SQLBindCol(hStmt, 2, SQL_C_ULONG, &usr.auth, 0, &ret[1]); if(SQLExecDirect(hStmt, (SQLCHAR*)"select uid,auth from my_tbl where idx=12", SQL_NTS) != SQL_SUCCESS) return -1; if(SQLFetch(hStmt) == SQL_NO_DATA) return 0; SQLCloseCursor(hStmt); return 1; } sometimes SQLFetch returns SQL_NO_DATA while the my_tbl has a row whose idx is 12. it causes critical problem in my system. Though table has a row, why does the SQLFetch returns SQL_NO_DATA Agree with Warren - this should work. ...Show All

• John E Katich Flat File Connection manager - how to identify Columns positionally

  Hi All, I need a urgent help regarding this issue : Coulmns are identified only with delimeter like comma, tab, vertical bar etc ..... .Is it any way we can give positions like coulmn 1 3 charecters coulmn 2 5 charecters Thanks in advance Shagun Khare Sounds like you are defining a fixed-width file, not a separated file. Load the file using the delimiter and then once you've got the file working in the data flow, you can use substring to capture the part of the field you are interested in. ...Show All

• M Thomas Can't create table definition with primary key and SMO.

  I'm trying this code, but it doesn't work. Can you help me I show you the error and code...I don't understand what is the adverted "Primary element" in error messaje and I'm really astonished because one time the code works whitout index definition, but any way, it doesn't work now. Thanks, Asereware Context Info: Visual C# Express Edition. SQL Server 2005 Express & SQL Server 2000. The behavior is the same in both. Error message: <ERROR>------------------------------------------- Fuente:Vivenda.Testings Descripcion simple: Error de Crear para Tabla 'dbo.AsereTablaSMO1'. Detalle: Microsoft.SqlServer.Management.Smo.FailedOperationException: Error de Crear para Tabla 'dbo.AsereTablaSMO1'. -- ...Show All

• DiasVFX Problem printing reports

  Hello, When print reports in Reporting Services 2005, the default paper is "A4", but our reports have letter size, or even "A3" or "legal". Could we set a default paper for printing for each report thanks, Pablo Orte In the layout tab of the report designer, right click on an area outside your report and select properties. Then, set the height, width, and margins. I hope this helps. TF The orientation has been changed too, it is in landscape. Don't worry. Try to change the paper size in Report > Report Properties. Then Click on the LayOut tab. There you can just indicate the Page Width ...Show All

• Tigraine SMO Trace and the use of template files (*.tdf)

  Hi Micorsoft, I was just wondering if there are any plans to provide the ability to start a trace without a template file. At the moment I have to dynamically create a template file (which is binary by the way) in order to allow a user to set filter options. It will be nice for SMO to provide a better way to interface to these options. (XML file, SMO Class properties ...) Let me know if there are any plans to do this down the track, as it affects my overall design of my application which is currently based on SMO trace technology. Thanks, Jim K. ...Show All

• jca_john Database not found?

  Hi I am developing a Smart Device App that will talk to a SSCE 2005 DB, but i am having some problems with the DB engine and communicating with it. I have the same problme on the device it's self and on the emulator. If i copy a sdf file that i have crated using SQL Server Mangment studio on to the device the SQLCE App will not talk to it and i get the following error The Database file cannot be found Check the path to the database [,,,File name,,] Native error :25046 I get the same error if i connect it with code. If i create the DB on the Device SQLCE reads it fine but i get the same error message when i try to get the app to connect to it. also if i move a SDF fi ...Show All

• Wendy_B Matrix Size

  Hi, I am trying to create a Matrix that is fixed in size at 8 inches wide. The number of columns in the matrix can vary between 10 and 28. Does anyone know if there is a way a set the width of the matrix I was thinking that it may be possible to do this by using a vb function to set the size of the column width to the number of columns divided by 8. Does anyone know if it is possible to set the width of the column from a function ...Show All

• Kamii47 Problem when deploying Reports

  Hello, I am working on SQL Server 2005 Reporting Services embedded in the Visual Studio 2005. I ve build reports perefctly, but the problem raised when I tried to deploy this report: I am deploying these report with a debug configuration , and I have tried with the 2 TargetServerURL: http://localhost/reportserver$sql2005 http://localhost/reportserver The Error message is the following: TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/reportserver$sql2005 . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the erro ...Show All