Sportsdude's Q&A profile

• SQL Server SQL server: How to see tables

  I have VS and SQL server database engine installed in the my office PC (Both legal copies). I would like to see the tables and like to create the new tables / databases as well for learning. How to do that Please help me.... Hi, here are some web sites for beginer tutorial , also take a look at SQL Server Books Online which will gives you idea about everything you wants to know about SQL Server. http://www.sql- http://www.sql- tutorial .net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp Hemantgiri S. Goswmai ...Show All

• Visual Basic How do I deal with range variables in vb.net 2003

  I used as range in vba but in vb.net this method of variable passing is not available. So I selected as object for ease of use. This isn't working either. I also used collection methods to check each cell in a range of cells that is not working either. I get the first letter of the cell only. Below is a function I have wrote Public Function TestRange( ByVal var As Object ) As String MsgBox( var) End Function Public Function TestRangeArray( ByVal var() As Object ) As String Dim i As Integer For i = 1 To var.GetUpperBound(0) MsgBox(var(i)) Next i End Function excel gives me the #value error The collection metod is For Each ...Show All

• Smart Device Development Accessing A Windows Shared Folder

  This question has previously been posted in the network and communications forum. Using a windows CE device, I am trying to access a regular shared documents folder on another computer. The folder has full permissions for all users. However, the first time that my program (written in VB.NET) tries to access a file in the remote folder (using IO.File) a login screen opens. Nothing has to be entered in the screen and all that is required is to click the Ok button. The problem is that the CE device is physically inaccessible with no user interface so it effectively freezes the machine. “Logging on” to the shared folder only has to be done once ever time the device restarts. Is there any way to automatically logon to the folder ...Show All

• Windows Live Developer Forums LatLong correct until I move the map?

  Hi, I am working with the map control inside a win forms app. I get the LatLong object from e.View which I get in the OnClick event. The event fires twice for some reason. I get the same lat or long each time the event fires provided I havent panned themap. If Ive panned the map, the first time the event fires I get the correct value, the second time I get an incorrect value. It stumps me. Why are events firing twice Why do I only get the correct lat or long (the second time it fires) if I havent panned the map Any help appreciated. Rob Hi I dont know whether i am correct or not. as i am also having similar problems when i am reisizing the map div.   So after resizing th ...Show All

• Visual Studio Installation Problems Visual Studio 2003

  I attempted to update my Visual Studio 2003 through the program with Service Pack 1 yesterday. During the update, it hung, crashed and had to be killed through the Program Not Responding dialog. Of course this corrupted my Visual Studio 2003 installation. I attempted to Install/Repair my installation and that hung about 1/2 way through (writing setup.ini on the second CD). I am now attempting to Uninstall it and it hangs when Generating Setup Script. How do I escape this endless loop! Frustration abounds.... The install always hangs when it is trying to write a setup.ini file to the NetFramwork SDK sub directory. Can anyone help me, please ...Show All

• SharePoint Products and Technologies Customizing alerts format in MOSS 2007

  When I set up alerts, they are sent using a view, I assume. I'd like to change that view so I can control the columns being displayed in the alert. Ideally, I'd be able to modify the format of the alert completely (including the link bar), but I'll settle for at least choosing the columns... Can someone point me in the right direction Thanks! In the object model, each SPList has an AlertTemplate property which you can get/set. The AlertTemplate is CAML which defines what the Alert will look like. You would need to modify the CAML to include extra colums or data you want in the alert. Here's an example I used to change the definition of an alert template on the Shared Documents library. To create my .xml file, I previou ...Show All

• .NET Development Kerberos delegation problem

  I have hunted through a serious number of blogs and web pages, but I just can't get delegation to work with our WCF application. To save some space, here is a link to the source code of a small test app that I am using: http://members.shaw.ca/murraypeterson/rcstest/ You can look through the source code to see the various settings I am using (NetTcpBinding, ClientCredentialType = TcpClientCredentialType.Windows, ProtectionLevel = System.Net.Security.ProtectionLevel.None, AllowedImpersonationLevel = TokenImpersonationLevel.Delegation, etc.). The scenario for testing is simple. Two machines, both members of the same domain (machine1 and machine2). Two users, both members of the domain (user1 and user2). On machine1, run the test ...Show All

• Visual C++ searching for a word in txt and copying a line from it to another txt

  Hello Newbie here, so be gentle please :D I have a txt file which contains this. Mass Flow Rate = 1.06978 Total Press Ratio = 1.05436 Adiabatic Efficiency = 0.729592 Exit Flow Coeff Cr2/U2rms = 0.437959 Ps2/Pa = 0.990665 I want to read the 3rd line only and copy it into another txt file and put it in the middle of it. What is the best way to do that Just point me to the right direction, which function should i use Sorry again... can someone please tell me why it won't let me edit my post !! anyway here's the new code it works but i need to add to that, i want it to only display the line if this string is found "Adiabatic Efficiency = 0.729592" how do i do that #include ...Show All

• SQL Server how to do this in SSIS? soory if i m a noob

  Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed Is there any particular configuration setting in sql that I can use Many thanks for any help provided. ...Show All

• SQL Server Windows Authentication connection problem

  I belive this issue maybe to do with the domain or the network, but since I don't know how to diagnose the problem exactly I've posted here as the starting point. When connecting to Sql Server 2005 using Windows Authentication, the first attempt will fail, but subsiquent attempts suceed. It fails with a message of the connection attempt timeing out. This happens when directly using SMO or using the Management Studio (which I belive also uses SMO but at a more raw internal level). If I use Sql Authentication then I can log on fine. Also when in Management Studio frequently opening a diagram or modifying a table and other general tasks will take an unsually long time. Other things like outlook (working with exchange) are al ...Show All

• Audio and Video Development Multiple Sub Audio Tracks

  How can I change between different sub audio tracks I have 3 sub audio tracks with different audiocommentaries where I want to switch. In the spec I didn't find any possibility to choose the sub audio track where the mixing is done. The only thing I found is Player.audio.sub.setMixing(). But I can't figure out how to tell the player which track it should use. When the player changes tracks, it uses the TrackNavigationList in the playlist. According to 6.2.3.21 in the spec, you can't put subAudio in the TrackNavigationList. And, since there is no API to switch subAudio, I don't think its possible to switch between subAudio tracks. Although 6.2.3.20 certainly seems to imply that you can have up to 8 subA ...Show All

• SharePoint Products and Technologies page setting and schedule

  When I set the page's expiry date will it delete the page from the document library on that specific date No. It just removes it from publication. It is still in the Document Library, just not visible to Readers. Contributors can still see the page (c.f. a page / document which has not been published yet). ...Show All

• .NET Development Webresource.axd not downloading over https in ie

  At least I think that’s the problem…All of a sudden I was getting javascript errors related to functions that should be in the webresource.axd file.   Which, if I’m correct is dynamically generated by the asp.net runtime for each client.     The first error thrown is on page load:    "syntax error at Line 1" However, this error doesn’t open in the debugger.         I know it is something to do with webresource.axd as whenever any validation controls are used (i.e. client side script in webresource.axd is used) I get the following error:       Error: webForm_PostBackOption s' is undefined   &nb ...Show All

• SQL Server SQLAGENT CAN't START

  SQLAGENT CAN't START this log: SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role). Which account is the service running with HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Control deployment of static data

  Hi, Firstly, if this question is answered in the documentation then I apologise. I'm usually the first to slay someone for igoring the principle of RTFM. I have a database schema stored in VSTS4DB and I'm making the assumption that when VSTS4DB attempts to deploy these objects it will do so in the correct order according to FK constraints. (I think that's a fairly safe assumption) Either that or it deploys all tables and THEN all the keys. Anyway, some of my tables have a bunch of static data that needs to be inserted once and once only - when the schema first gets deployed. So here's some questions Is it possible to "attach" an INSERTION script to a schema object. Effectively saying "scriptXYZ.sql is the s ...Show All