khaleel's Q&A profile

• SQL Server Trigger and send to the fax printer

  Can SQL Server let me create a triger and send the data to the fax printer n send it to that particular person Hi, you have to be aware that sending printer jobs through a trigger can cause performance issues. Triggers behave asynchronously which means that they will block during their execution. You should better write the job data to a table and poll this table on a regular basis or use Service broker for communicating with some other message service. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Code Coverage : Color is not seen

  Hi, When I run a unit test and checking code coverage details, I ccould see details like what percent of code is covered and not covered. But I couldnt see the colors (red, green,etc) in the program.Whenever I click on the'Show Code Coverage Coloring' tab on the 'Code Coverage Results' Window, an error message is shown: "value doesnt fall within the expected range'" Can anybody help in this. Thanks in advance akjal Hi David , Many many thanks man. It worked. Now I can see the colors.What could be the problem with it before Could u please let me know Actually I had seen colors some times before it.. Its version is like this.8.0.50727.42(RTM) lot of th ...Show All

• Microsoft ISV Community Center Forums Internet Explorer 7 jpeg and gif blurry after tools/internet options/advance/reset

  I was working on another problem and reset my advanced options. After all my jpeg and gifs now are fuzzy when displaying in only internet explorer 7.0.5730.11 all other programs display normal. I've been seeing some of the same issues with specific laptop configurations using only IE7. Also the zoom level has no affect worse or better for the problem. ...Show All

• Windows Forms C# Form takes long time to close (Refresh!)

  Hi All, I have Windows application with one form, which calls Dll (windows control lib) to get user name and password and do the authentication. After successful authentication, the control comes to main form, from there which does few database queries to load the grid control. The problem is here, after successful login authentication, the login form does not getting closed while loading the grid control from the main form. The login control exists till we the grid control loads the data. Is there anyway I can avoid this. (I don't want to do this with threading or backgroundworker, because of grid scrollbar problem) Thanks for any suggestion/thoughts. Move your database querying and grid loading code f ...Show All

• SQL Server Printing Reporting Services Reports from a Access Report(VBA)

  Hello Everyone, I have a fun question here... We have a vendor which calls access reports only. I have moved 90% of our reports to reporting services and would like to move the rest. The users are complaining about having to go to 2 different places to do their work. (IE: The App and then the report server) I would like to able to fake out their system and have dumby reports call and print reporting services reports. Is there a way in VBA to call and print reports silently Thank You , Leo Place hyperlink control to call your report server report and write VBA code on click event of the control to dynamically create string for http address of the report server report and append nessesar ...Show All

• Visual Basic keeping current Date

  I am writing to a file, and on the file name I would like to have the date that it was created like fileName3/3/2005 how would i go about doing that when i do Private const File_Name = "C:\FileCreated" Dim runningDate As Date = Date.Now Using writer As Streamwriter = File.CreateText(File_Name + runningDate) writer.WriteLine("_______Hello___________") writer.Close() End Using i get a invalid path name exception.....any help on how to fix this Sub Main() Dim runningDate As Date = Date .Now Dim currentDate As String = runningDate.ToString() currentDate = currentDate.Replace( "/" , "" ) currentDate = currentDate.Replace( ":" , &quo ...Show All

• SQL Server Best practice for writing own system procedures

  Hello, I'm searching for a best practice or other documentation for writing my own 'system procedure'. I want to write procs which I can call in the context of every database without using a database name analogous to sp_who for example. I read about the 'Resource Database'. All system procedures are stored in that readonly database and appear logically in the sys schema of every database. But I couldn't find documentation about writing my own 'system procedure'. I discover so far that procs with prefix sp_ stored in the master database do what I want. But is that the only way or is there a better way to do it In other threads I read that it is recommended not to use sp_ as prefix for procedures Wolfgang N ...Show All

• Visual Studio VSS Branching

  Hi All, Can anyone let me know how to write a custom task for VSS Brancing Will the existing VSS tasks at http://www.gotdotnet.com/codegallery/codegallery.aspx id=b4d6499f-0020-4771-a305-c156498db75e do what you want I didn't see something specifically there for branching, but maybe the label stuff will do what you want If not, writing a custom task is pretty easy from the MSBuild side of things. The hardest part will be figuring out how to talk to VSS to do the branch. For info on writing custom tasks see this blog entry: http://blogs.msdn.com/msbuild/archive/2006/01/21/515834.aspx . Neil ...Show All

• Visual Studio How To Change Developer Preference Once It Is Set

  This may sound like a very dumb question, but when you first open Visual Studio 05 after installing it you are asked to set what kind of developer preference you want. When I did this I accidentally selected Visual Basic developer and I'm missing half of the tools I normally use, as well as the ability to switch between debug and release versions. I know there has to be a place I can go to reset it but I have look over every option and for the life of me can't find where it's hidden at. Any help on this would be greatly appreciated. Thanks, Jeremie Grund Close all of your instances of Visual Studio and restart a single instance from the command line with the /resetuserdata flag and if you install ...Show All

• .NET Development Where to place the connection string

  Hi, I'm creating a Windows app and was wondering where to put the connection string for all five of my methods In my web apps I've always put the connection string in the web.config file but am not sure where to put it on a Windows app, and also how to reference it from its location. Can anyone please help Many thanks, Jimmy, For this you'll have to add a reference to System.Configuration. U can do this by right clicking the your project, and select add reference. Now in the using section, add - using System.Configuration; Now in the code or in th method, just write ConfigurationManager, u will get this in the intellisense. There is separate connectionString property thats there when u hit a ...Show All

• Visual C++ Pointers... when to use them?

  In general, when do you use pointers It is my first time working on a more-complexed-than-hello-world application and I get many errors regarding "stack around variable x is corrupted" if I did not use pointers. eg: SomeDllClass sdcObj; sdcObj.doFunc(); ... // End of Function This gives me the stack corruption error. SomeDllClass* sdcObj = new SomeDllClass(); sdcObj->doFunc(); ... // End of Function This is OK. Also, I learned in my C++ Appreciation Class that pointers declared in a class should be deleted in the destructor. When I did that however, I was given a "Memory Access Violation" error (I initialized the pointer in a function other than the constructor). Is it advisable to use pointers for every variable I ...Show All

• SQL Server Paging issue on conditionally set second table visibility

  Hi. I am having a problem with a 2005 report that has two tables and is designed thru visual studio. The second table is set to page break before printing and also to repeater headers on new pages. It works fine just like that. However, if I place a condition on the visibilty of the table based on an input report parameter it does not page break before rendering the table. In fact it does not page break at all leaving me with an extremely long last page. The visiblity parameter does properly toggle. This is all occurring when rendering the report to the screen using the windows reportviewer. When I export to PDF it looks fine. Any help would be great. Yeah, I would consider really hard changing that ...Show All

• Windows Forms System::Windows::Forms::Control::Invoke();

  I have a BackgroundWorker that listens for incoming connection requests via a Tcp Socket. When the client socket connects I need to update one of my controls. I need to do this inside the thread, which in return means I need to invoke the control I need to update. The problem is no matter what I do I can't get my delegate/functions to work. Here is what I have: ...Show All

• Smart Device Development display .rtf file

  I am implementing a user agreement form inside my app. How can I display the user agreement file (.rtf) into a textbox for example Hi I want to open/diaplay a text file on the screen of Windows mobile emulator on a button click event. Can anyone help me with this Thanks in advance. -Gaurav ...Show All

• Visual C++ XP Manifest Problem

  I have a problem using an XP Manifest file for Common Controls. If I create a template Win32 project, which creates a simple window with an About Dialog, build it, then run it, it works as you would expect. However once I add the manifest in the Linker -> Manifest part of project options, when I click Help -> About, nothing happens.  I've debugged the code and DialogBox is returning -1, but GetLastError is returning 0.  This happens when I try to run any program I've compiled with a manifest that uses DialogBox or MessageBox. They fail but GetLastError returns 0.  What's going on The Linker -> Manifest File -> Addition Manifest Dependencies entry is as follows: "type='Win32' name='Microsoft.Windows.Common- ...Show All