Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jshurst

    Dealing with 750 million records in MYSQL table

    I don't really understand what you are asking here. I'll give my best shot at answering what I think your question is though. I assume you've already created the tables (table_5, table_33, etc). So then you could create a stored procedure (routine) and have some conditional logic to determine...
  2. jshurst

    how to log users into database

    This might help too... http://tek-tips.com/faqs.cfm?fid=5662
  3. jshurst

    how to log users into database

    First, what kind of authentication is your database using? (Windows authentication, sql authentication)? If Windows authentication then you probably won't need to log into the website. ASP.NET can pull your information from the computer you are already logged in on (domain). Then you can...
  4. jshurst

    Inject JS in a page

    Strange question here, but I need to do it, so here it goes... We have a vendor app written in asp.net, hosted on our servers. The code is precompiled (but I can add to the web.config file). I would like to be able to inject javascript into each page while the page is loading. This would...
  5. jshurst

    Preferred method for connecting C# to a database

    Check out the Microsoft Enterprise Library. It has lots of cool stuff in it but, at this point, you'll be interested in the Data Access Application Block. http://msdn.microsoft.com/en-us/library/ff632023.aspx Regards, J
  6. jshurst

    Security settings to allow and deny access without prompting

    Yes, you are correct. However, I believe that a Sales person trying to access the Accounting site will actually get prompted for their creds. Assuming that it is an Intranet site. Also, one thing to note. If you put a "." in an url, then by default IE won't pass Windows Creds to the site...
  7. jshurst

    partitioning

    You should be able to use Disk Management to resize the disk now. Start->Right Click on Computer->Manage->Storage->Disk Management Click on the HD (I assume C:) and shrink it. Then you will have unallocated disk space and you can create a new partition. But to answer your question, yes...
  8. jshurst

    access to website based on IP address or hostname

    This is a very broad question. 1) Is this an Intranet application? 2) Are you using Windows Authentication? 3) Are each of these sites set up in their own root site (or are they in virtual directories)? 4) What language are your websites written in (ASP.NET apps)? Regards, J
  9. jshurst

    Outlook Automation- Need to open an independent Outlook process.

    I can't answer your direct question, but are you using an Exchange environment there? If so you could go directly to the exchange server and not worry about Outlook. This is the easiest way I've found to work with Exchange...
  10. jshurst

    Read from SQL2008 server cluster disk names

    From the looks of this article you shouldn't use that. http://msdn.microsoft.com/en-us/library/ms131540.aspx I just started using the "Microsoft.SqlServer.Management.Smo" namespace which should be able get you what you need...
  11. jshurst

    Network / Server use / Network Design Help.

    Go virtual! The most bang for your buck and license costs are many times lower (for Windows OS's). Plus you can easily back up the entire virtual machine and move it if you need to. You could have redundancy as well, i.e. load balancing for your websites, clustering for your DB, etc... might...
  12. jshurst

    IIS7 and Web Service extensions

    I can't confirm that, but it doesn't suprise me. Not much is enabled on Server 2K8 by default. Also, if you're going to be hosting WCF services you're going to need to do an additional step and register it. Not sure if this will allow you to host .asmx services after you do this or not (WCF...
  13. jshurst

    Help with IIS 7.5 on Windows 7

    I had all kinds of problems with this too. If you haven't already googled this then look up "IIS7.5 hidden apppool identity". I suspect that you'll need to add something like this to your directory security: "IIS APPPOOL\DefaultAppPool" Regards, J
  14. jshurst

    How do I get started with dual boot of linux on vosta?

    Just to mention VMWare Server is also free, as is VMWare vSphere Hypervisor. When is VMWare going to make a bare-metal client hypervisor!? It's rumored in 2011, but we'll see (VMWare CVP). IMO, dual-booting should be a thing of the past, we should be able to multi-boot OS's on the client...
  15. jshurst

    Check if a specific web page is already open

    Not sure if this will work but have you attempted to name your browser window? From my web page I would use the window.open() javascript method. This takes an url and a window name. If you use that same window name to open a new page it should load in the same window. A few years ago I...
  16. jshurst

    Need to combine notes from multiple lines into one view

    Yes, you can do this. You can use the STUFF() method. I'm not sure if it is available in SQL 2000 but I've used it before and it's very handy (although I thought it was pretty complex too - at least for what I was doing). Here is a link to it...
  17. jshurst

    Scripting out Stored Procs

    I would like to be able to script out all stored procs in a given database. Basically I want to do this for backup purposes. I just execute a script and it writes out all my SP's to a file on the server. I don't want to use Mangement Studio I want it automated from a SQL script. And I don't...
  18. jshurst

    INSERT the Results of a Stored Procedure with Multiple SELECTs?

    Can you use .NET for this? If I'm understanding correctly then you have 1 SP that returns 5 result sets and you basically want to split them up. An ADO.NET DataSet will do this automatically for you (it will let you work with each result set). I don't know how to do this in SQL though...
  19. jshurst

    XML or Array Parameter

    I've been searching around for this but haven't found a solution that is satisfactory. I'm coming from a SQL Server background and new to MySQL, but this is a scenario that is quite common for me. I have an application which I need to pass an array to a stored proc in the database. I want to...
  20. jshurst

    Email Options

    You will most likely need to know which email server they use, meaning you will need to know the DNS (or ip address) of the mail host. You might can get around this by specifying local delivery, but I have not done it that way. Are you going to be sending through an Exchange server? If so you...

Part and Inventory Search

Back
Top