NONO_COOL's Q&A profile

• SQL Server Remotely Register SQL Server 2005 Express in Enterprise Manager

  I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>. Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager ...Show All

• SQL Server Returning resulsets between procedures !!

  Hello, I need to do the following, But I receive an error: CREATE PROCEDURE dbo.EJEMPLO_A AS BEGIN SELECT TOP 10 NAME, ID FROM SYSCOLUMNS END -- and Later use the one above... like this... CREATE PROCEDURE dbo.EJEMPLO_B AS BEGIN DECLARE @temp_lista TABLE (NOMBRE VARCHAR(500), IDENT NUMERIC(5)) INSERT INTO @temp_lista execute dbo.EJEMPLO_JULIAN END Pd. I just have to capture the dbo.EJEMPLO_A resulset... and I can't modify It Hi Dave, thank you so much for your answer... The problem here Is that I can't modify the dbo.EJEMPLO_A procedure, I just can change the second one... ...Show All

• SQL Server Issue with Ascii 7 files

  Hi All, I need to generate Ascii 7 bit flat file, based on data in db, using integration services, FTP task. Currently i am generating file with ansi-latin and then using the script task converting it to the ascii 7. File looks to be generated properly. But when the target system reads this, they complain that the file has junk charecters some thing like this. when i open it after generating the file it looks fine to me in DOS also. I dont know what is the target system and what OS is used by them. what cud be the issue for these junk charecters and is it possible that a Ascii 7 file generated by windows doesnt work in other OS If the method i am doing to generate the ascii 7 is not currect then what is the best method for this A A ...Show All

• Visual C# Anyway to know if the program is running under VS IDE ?

  I would like to do conditional compilation based on whether the program is running under IDE, is this possible Thanks. Hi, I understand from ure question that u want to setup a conditional complitaion only if ure runnding under Visual studio. U can do this by adding a conditional compilation only in the debug mode by editing project properties in Visual studion. Visual Studio enables multiple configurations (Debug/Release and u can add other configurations) and each one has it's own properties. So when compiling in release mode the parameters you set for the Debug mode are not used. HTH. ...Show All

• Visual C# How to strip some parts out of a string

  Hi I have an array of data (dimension = 19) I knew that the last bytes contains float number (in this example it is 139.25) After using Encoding.ASCII.GetString(data) i get a string contains special characters with 139.25 how can i strip these special characters and get only 139.25 =========================================== Please see this picture for more details http://www.swa7.com/upload/uploading/ArrayOfData.jpg =========================================== Is there another way to get the float number only out of the array data While I think that the format of the binary data would be useful in developing a more elegant solution here is the short term solution: You can u ...Show All

• .NET Development the age old problem of "the root element is missing"

  I've done a lot of searching for how to fix this error, and I can't find what's different between everything else and my code. Basically what I'm doing is connecting to a bizTalk .asp service, and its being sent fine, and is recieved fine. It uses streams to get back and forth, and if I were to write it out to a string, it works fine. If I pass the same stream into the constructor of another class that parses the stream to xml, it gives the error. Heres the code: Encoding encoding = new UTF8Encoding (); byte [] data = encoding.GetBytes(request); // Prepare web request... HttpWebRequest myRequest = ( HttpWebRequest ) WebRequest .Create( this .path); // connect to mustang WebResponse response; // POSTed response myRequest.Me ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. device resets and resizing a game window

  I've tried following the tutorials on the help section, but I'm stumped. When I resize the window, the window seems to lose focus and disapear under everything else. It will only show when all other windows are minimised. I thought this might be something to do with the device reset function, so I tried to reset the graphics device parameters for the backbuffer etc here... It still does the same thing when there's no sprites in the window. When there are sprites in the window, the program crashes out on the device reset method. below is my code for resizing the window which is registered to the windows.clientsizechanged event void WindowSizeChanged(object sender, EventArgs e) { // Make changes to handle the new window size. ...Show All

• Visual Studio Tools for Office how to change the string colour

  how i able to change the string colour in c# suppose i have String str="ram sudheer"; so for this string  there no option to change the colour. so that i should not use of any controls like textboxes,etc.. so can u please tell me.. hi Troy, i just want to apply colour to the task in the outlook-2003. so how can i apply colour to the task programmatically.. can you provide me the solution please.. ...Show All

• Visual Basic Coding Listbox Puzzle

  I want to display a list of employees (by employee number) that have performance results >90 in certain jobs. some employees may appear more than once on the list. I need a good solution that will indicate who is the top performer - who appears most. I'm thinking about using a list box and add emp# to the list - how do I figure out which emp # appears most on the list I didn't want to use a database.... any ideas, codes on using a listbox There are over 30,000 emp #. Job transactions may be in the millions. Thanks. well you could but maybe inefficient. from what I understand, you want people returned who have a criteria of a perf result of > valueX. This is achieved using th ...Show All

• SQL Server Install problem

  I am having a problem installing SQL express. I have 2.0 framework installed as well as the other express software. I also have Visual Studio 2003 installed. Do I need to uninstall other version of Visual Studio Do I need to uninstall other versions of SQL. I get an error but it does not tell me what the problem is. Thank you Dee this is from the core file Microsoft SQL Server 2005 Setup beginning at Wed Aug 16 18:14:14 2006 Process ID : 4668 c:\8c27e35b5d509dc8609c33e266\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/7/16 18:14:13 Complete: LoadResourcesAction at: 2006/7/16 18:14:13, returned true Running: ParseBootstrapOptionsAction at: 2006/7/16 18:14:14 Loade ...Show All

• SQL Server SQL create user script problems

  Firstly I know nothing about SQL server,I downloaded SQL express to evaluate an EAM software for work because the access version of the program was buggy. The software came with 4 scripts to set up the database,the schema script ran fine but when I run the create user script I get a bunch of errors and have no clue how to proceed. Here is the script followed by the error messages: --MSSQL -- Create Login Use master Go if not exists ( select * from master .. syslogins where name = N 'PMAINT70' ) BEGIN declare @logindb nvarchar ( 132 ), @loginlang nvarchar ( 132 ) select @logindb = N 'PMAINT70' , @loginlang = N 'us_english' if @logindb is null or not exists ( sele ...Show All

• SQL Server subscriptions are failing

  My data driven subscriptions are beginning to fail on a regular basis. I am using RS2000. Three types of errors are occurring - 1.) the Excel attachment is not sent or 2.) I get an invalid email error even though the email is correct or 3.) "The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database." In all cases these subscriptions have been running successfully for months previously. When the failure involves a missing attachment or invalid email address, the problem goes away when I create a new subscription using the same subscription table information. In the case of the missing user name and passwor ...Show All

• Visual Studio 2008 (Pre-release) Encryption and Signature in message mode.

  Hi How do I set Encryption and Signature when using message mode I saw in the trace viewer that the default behavior for any binding was not to encrypt anything - Is that correct Can I encrypt / Sign only part on the message manu manukahn:> We are speaking about WCF Not WSE3.0 !!! Yes, I know and I am speaking of WCF as well. I am just saying that we used to be able to Encrypt and Sign MessageParts in WSE2.0, not anymore, not even in WCF ... And I am speaking of WCF out-of-the-box. That said, I believe you may be able to do so if you implement it yourself via the various ways you can grok into the message. ...Show All

• SQL Server Drillthrough returning sets of duplicate rows

  Drillthrough appears to be showing multiple rows for each single record that should be displayed. For example, in my fact table, there is a single record for each trip. The following MDX query returns a single cell with a trip count of three. SELECT NON EMPTY { [CP Date].[Date by Month].[Year].&[2002] } ON COLUMNS , NON EMPTY { [Commodity].[Commodity by Type and Group].[Commodity Type].&[Other] } ON ROWS FROM [Barge Trip] WHERE ( [Measures].[Trip Count] ) 2002 Other 3 If I drill through on that cell, exactly three records should be returned. However, in actuality, 12 rows are returned - three sets each having four identical rows. To drill through, I am simply adding the D ...Show All

• SQL Server Get Year

  Posted - 01/08/2007 : 12:19:15 I would create a function as it it easier to handle, joinable and more reusable: ALTER FUNCTION dbo . NextYears ( @StartingYear SMALLINT , @AmountOfYears SMALLINT ) RETURNS @NextYears TABLE ( TheYear SMALLINT ) AS BEGIN WHILE @AmountOfYears >= 0 BEGIN INSERT INTO @NextYears SELECT @StartingYear + @AmountOfYears SET @AmountOfYears = @AmountOfYears - 1 END RETURN END HTh, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All