jennie44752's Q&A profile

• SQL Server How to format a textbox?

  I'm using RS 2003. Have a textbox with a number in it, but somehow the "Format" filed doesn't work or do anything ! I tried "#,#", (#,#), "#,##0", etc. So, how do I set the format on an individual cell Thanks. YOu hjave to do that without quotes or use a named format like n2. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SQL 2005 Time Sensitive Question

  I have a problem installing sp 1 for sql 2005 express. How can I check if I have sql server or the sql 2005 express edtion and if it is a beta or not. I want ot install the SP1 OF SQL 2005 When I go to the add/remove program section I see sql 2005 edition and not sql 2005 express edition, very confusing because it indicates to look for sql 2005 express edition in the add/remove program and remove it. I don't even know if I have a beta release or ...Show All

• SQL Server SSIS Changing Column Order during Transformation

  First let me say, I really can't believe this chain of events myself--and they are happening to me. I am upgrading several DTS packages to SSIS on what will be my new production server. These packages create tables, export them to a flat file, and ftp them off to other locations. What is happening (on the SSIS side) is that the OLE DB Source is reordering some of the columns on its own (moving them to the end of the table/file. Then when m ...Show All

• SQL Server Triggering SSIS Packages

  I am currently building an ASP.Net web app and implementing SQL Server 2005 for a project. I was relying somewhat on kicking off SSIS packages from the web app, but I am not really sure how to do this. If anyone could help me out, I would really appreciate it. See this link: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=257798&SiteID=1 ...Show All

• Visual C# How to put custom Attribute to auto-generated Partial Types members?

  I came across to an issue, actually it’s in C# language in general (partial typing & auto-generated code), but I'll use DLinq as illustration.   DLinq has tool to autogenerate persistent domain types as Partial Types. These domain types members are marked with DLinq ORM related Attributes. Now, how do I mark those members with my custom Attributes (or other BCL's Attributes) outside the generated Partial Type file ...Show All

• SQL Server SNAPSHOT Replciation - Last distributed transaction LSN ?

  Hi There When i created a snapshot replication publication on one of our servers , i noticed that it now keeps track of the last distributed transaction. I only plan on doing the snapshot every month or so. I am concerned that becasue it keeps track of the last LSN that the transaction log will keep growing, is this accurate Secondly why does snapshot replication keep track of the last distributed transaction, since it does not replicate transa ...Show All

• Visual C# NullReferenceException when running DLLImported function

  I have a vb.net chunk of code that works fine when I call the wrapper function that looks like this: <DllImport(".\analysis.dll", EntryPoint:="levels_analysis", CharSet:=CharSet. Ansi )> _     Private Shared Function levels_analysis( _          <MarshalAs(UnmanagedType.VBByRefStr)> ByRef in_string As String , _         < ...Show All

• SQL Server MSDE 2000 installation fails on Windows Vista 64-bit

  Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308). The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308) Thanks in advance. I don't beli ...Show All

• Visual Studio Express Editions Simple Code Conversion Question?

  Is it possible for someone to convert c++ or c# to vb.net for me http://www.developerfusion.co.uk/utilities/convertvbtocsharp.aspx ...Show All

• SQL Server Express Manager for Sept CTP

  Does anyone know if there will be a version of Sql Express Manager (XM) for the September CTP Regards Graham ...Show All

• .NET Development Delayed send with smtpclient in .net 2.0

  Is there any way to force the smtpclient to send mail immediately with the .send method in system.net.mail 2.0 Right now it takes anywhere from 90 secods to two minutes before the mail is actually sent once the .send method executes. I've tried setting the object to nothing immediately after the .send method call, but no luck. The real issue for me is the send delay is also causing the smtpclient  to hold a lock on attached files that are ...Show All

• Visual Studio Express Editions no visual studio template found

  I just installed the recently released Visual C# 2005 Express. When i tried to create a new project. I got this error message "no visual studio template found". I went to the "event viewer" in "Administrative Tools" to see the log. I found the message : "The Visual Studio template information is out of date. Regenerate the templates by running 'VWDExpress /installvstemplates' or reinstalling Visual Studio.  Note: corrective action requ ...Show All

• Visual Studio 2008 (Pre-release) Generating proxy for multiple Contracts service

  Short question: 1. How to use Svcutil or other utilities to generate proxy for particular contract in multiple contract service Long Question: I have created a application with multiple service contracts (with one endpoint for each contract). Now i like to generate the proxy for these service contracts. In the client, i want to generate proxy for specific contract  as both the contracts wont be used by same client. So how to use Sv ...Show All

• SQL Server VS 2003's Server Explorer is not working

  Hi; My Server Explorer in Visual Studio 2003 professional has stopped. By this I mean that I can't add any new connections and I can't expand my server instance to view table etc.. Is something corrupted with VS or with the MSDE Thanks, Gmann To All; The solution to my problem was to upgrade my operating system Windows XP SP1 to SP2. After that the server explorer started functioning again. An obvious guess ...Show All

• Visual Studio Team System Retrieving codecoverage info programmatically “off-road” code coverage experience.

  hi, i have reffered the url http://blogs.msdn.com/ms_joc/articles/406608.aspx that says how we can retrieve the codecoverage info from an assembly/exe. i am using the code to create the coverage file after retrieving the coverage info. /******************************************************* Collecting code coverage info from assemblies/binaries. ********************************************************/ public void CreateCoverageInfo( ...Show All