dp2000's Q&A profile

• Visual Studio Team System Installing VSTS for Web Access

  I am about to install Beta 2 in our development lab on a single machine configuration and would like to know what I have to request from our network engineers to get web access working with the system.  Thhis box is currently behind the firewall and cannot be hit from the outside world.  Further there is no VPN available to the lab. Along the same lines, when we go live with the RTM it will be in a 3-tier multi machine mode.  Which server needs to be exposed to the net for web access.  Is it just the foundation server box Thanks Marc Thanks Buck.  That is what I thought but I wanted ...Show All

• Smart Device Development copy files to pda

  How can i copy files to pocket pc using comand line on desktop I saw a tool posted by someone that does this (you can also write on your own using RAPI) http://www.codeproject.com/ce/rcmd.asp   Amit ...Show All

• SQL Server Management Studio and Enterprise Manager on Same Machine?

  Greetings! Do any of you know whether or not it's possible to install Enterprise Manager onto a box with SQL Server 2005 installed I've come across a couple of problems when trying to admin some SQL 2000 servers, so I need EM somewhere. Also, it's incompatable with SQL Server 7.0, of course, and I've got two of them to admin as well. Thanks! Yes, it's OK, I've done it. But it's not recommended for a production machine. Uninstalling either may cause either to not function properly. ...Show All

• SQL Server SQLServer ERRORLOG is growing everyday

  Hi, I just discovered that my production sql server(MSSQl.1\Log\ERRORLOG) is keep growing and i really don't know how to resolve this issue. I hope someone can suggest me or guide me how to resolve this issue. I searched on google but I could not find anything. This is production live sql server and I would like to delete the errorlog and can someone please tell me how.. Look at sp_cycle_errorlog() ...Show All

• SQL Server .NET2 SMO Components

    I am new in VS2005 and I start with sql2005 express. I plan to use SQL express 2005 manager. When I tries to install this program the system asks for MS Framework,net2 SMO Components. Where can I download these components Thank You Best regards Oyvind       See this link which contains a reference to the SMO redist : http://blogs.msdn.com/mwories/articles/smofaq.aspx ...Show All

• SQL Server Export To PDF

  Hi, I have a table and a chart in my report .When i export it to PDF format the title of the report overlaps with the table and the chart spans 2 pages. Is there a remedy for this Hi, You can try to design your report as normal ASP.NET page and then convert that page to PDF using the he HTML to PDF library for .NET from http://www.dotnet-reporting.com or the PDF Reports Generator Library for .NET from http://www.winnovative-software.com is what you need. It's pure .NET library, it doesn't use a printer driver. There is also a free html to pdf converter application built on top of thi ...Show All

• SQL Server public server role

  In exploring permissions that users have, I find that they all have VIEW ANY DATABASE permission which they inherit from the public server role. You can see this by selecting the Permissions page on the Server Properties dialog and highlighting "public". The permission shows as having been granted by sa. This is listed as a server role. However, it does not show in the list of server roles and I can't find any documentation for it (RTM BOL). Interestingly, if I revoke this permission (which is the only permission this role has), the public server role disappears from view. But I can subsequently regrant the permission with Transact ...Show All

• Visual C# SQL Server on C# question

  Hi, I want to be able to run, pause or stop a SQL Service (as in SQL Server Service Manager) from within a C# application. How can I do this The server I'm using is called DEANHPLAPTOP. I'm sure this can be done through the command line somehow in DOS but how can I do it in an application The end result I want is to have it so that the first form in the app (login form) starts the service if it's not already running and then stops it when the application is closed. Just a thought... Thanks for your help. ...Show All

• Windows Forms adding TabPage Added and Removed handles

  Hi! Does someone know, whether it is possible to handle when TabPage is being deleted or added. As I've understood, it's not possible to use ControlAdded and ControlRemoved removed, because they are used fot ControlCollection. Is it a way to solve my problem Any suggestions are welcomed. ...Show All

• SQL Server Reporting Services to MS Word Questions

  Hello I am using SQL RS to export a report to HTML with Office Web Components and then by clicking File->Edit with Microsoft Word, I get the report into Word format. The report displays fine in the HTML with Office Web Components format, however the content gets condensed to about 3 inches in width and the page margins are off when I get this report into Word. Is there a way to fix this formatting issues in Word Also if anyone has a better idea of how to get data from SQL RS to MS Word, please feel free to comment. Thanks in advance for the help! We have developed and just rele ...Show All

• Visual Basic Pulling User name and info From Active Directory using LDAP in VB.net 2005

  Hello, I am sorry I do not have functional code to post but I hope you can understand my request enought to give me a hand. NEEDS: 1> take a request... ie. First name, Last name, or login ID and Search AD Path can be hard coded so entire forest is not searched. 2> List all entries found 3>once the correct user is selected I need to pull First, last, middle name and , Email , Phone number , @ and GUID for that user. Thank you very very much in advance. Marcelo Here is some code to enumerate an Active Directory entry and all of its available properties/values. Adjust the ...Show All

• Visual Basic Create application to used by multi users at same time

  Hi I have Access database with vb2005 I would like to build my application to use with many users at same time with One shared database !!! q1) how can I set the database to be shared for all applications q2) what about the updating problems (One record updating by two users at same time) q3) must I use disconnect technology or connect technology connection for this issue thanks Hi, very broad questions but we all need help I suppose... 1) create the DB on a server 2) you could be clever in your coding... alternatively switch to SQL Server instead, you can add a timestamp field to cater for this problem. a ...Show All

• .NET Development What is 'server' in SmtpClient constructor?

  Hi guys! I do know what it is MEANT to be. But here are a couple of querstions, which I can't figure out. I am Testing the new .Net 2.0 SMTP classes. In particular sending mail using SmtpClient class you need to specify the e-mail server in the argument of the constructor. (By the way, you need to have outgoing mail scanning by antivirus software off for any of this to work). What bugs me is that: 1. I can specify "localhost', or my mail server (same as the one secified in my Outlook account) - in either case mail makes it out.So what is the meaning of specifying the server when instantiating SmtpClient class 2. How do I spe ...Show All

• Windows Forms Newbie Question

  I come from a java background. I am currently developing a mailer program. What I want to happen is when the application starts the GUI must FIRST display and then the mails must be sent and the GUI gets updated as this takes place. The app is sending the mails but before the gui gets displayed. I think the problem is as follows. In my main method is the following code        myMailer.Mail();                              Application.Run(myMailer);    If I put the Mail myMailer.Mail();  ...Show All

• Visual C# Accessing an Array using Propery

  Hi, I am using properties for Setting and Getting data values, such as, public string ModuleExists{ get{ return moduleExists; } set{ moduleExists = value; } }//end public string ModuleExists How would one use the above concept if the moduleExists is an array of values Thanks Jeff public string[] ModuleExists { get { return moduleExists; } set { moduleExists = value; } // remember this lets them set a whole new array. If this is not desired then remove it } ModuleExists[5] = "some new value"; Your question wasn't very clear so I just posted some pote ...Show All