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!

Register Log in
  • Congratulations Rhinorhino 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. RichardParry

    F5 Big IP - Layer 2 Switch?

    Any ideas on this one? :)
  2. RichardParry

    F5 Big IP - Layer 2 Switch?

    Hi All, I've been given the opportunity to acquire an F5 Big IP 8900 Series LTM for a great price. I understand this is running the v11.x LTM. This particular model is very high-end, has dual PSU's, dual mirrored HDD' for the OS, 16x Gigabit copper ports, 8x Gigabit SFP ports and 2x 10GbE SFP+...
  3. RichardParry

    Replacement for failing Cisco UC520

    Thanks for the reply! I haven't touched the config or anything hardware wise for some time, so it's really quite odd. Indeed I did think about another UC520, but they're getting a little old now. I actually bought this one a good 4 years ago, and it went end of life from Cisco in January this...
  4. RichardParry

    Replacement for failing Cisco UC520

    Hi All! I was wondering if you could help please. We have a Cisco UC520 in our office which I purchased about 4 years ago and fully configured to our requirements. It is the 48U-4BRI-K9 version, so has the 4x built in ISDN BRI ports. It's been working perfectly for years, supporting our small...
  5. RichardParry

    How to connect to BL20p G2 Blades?

    Hi All, I have recently purchased a second hand BL20p Blade Enclosure, with 8 BL20p G2 servers, all previously configured and working on a network. All powers up OK, no errors etc and I have connected the enclosure off one of the Switch Modules to our network, and going by the flashing lights...
  6. RichardParry

    2003 STD Anti-Virus

    Hi All, What Anti-Virus software would you recommend for installing on Windows 2003 Server Standard? We usually use AVG File Server edition, however we're having problems with compatibility of this software with some other software running, plus some filesystem issues. If you could give you...
  7. RichardParry

    Multiple Servers - Replicating Web Content

    Hi, We are looking to deploy a large web application developed in ASP.NET. It has been developed to run over more than one IIS web server, using a clustered SQL Server for the Session State management, an data store etc. My main problem is that while I have got this to run over as many servers...
  8. RichardParry

    PIX 525e Failover to PIX515e?

    Hi, Quick question, we're using a PIX 525e with the Quad Port F/E card installed at present but are looking at getting a second unit for redundancy. Would it be possible to connect a PIX 515e with the same memory, ports (with the quad port card) and IOS revision as a failover unit (with the...
  9. RichardParry

    SQL 2005 Multiple Instances

    Hi Charlie, I am afraid that still doesn't help. I am having a good fiddle at the moment. It has something to do with dynamic ports I am sure. I will keep fiddling and let you know how I get on. Should be noted if I install a default instance of SQL 2005 it works perfectly, but I need multiple...
  10. RichardParry

    SQL 2005 Multiple Instances

    Hi Charlie, Just gave that a try and still no joy, should have also noted that I can't connect to the instances with SQL Management Studio/Enterprise Manager or MS Access, unless I specify the port number. Same for ODBC connections, they won't work until I specify the port number. Unfortunately...
  11. RichardParry

    SQL 2005 Multiple Instances

    Hi Charlie, We use one of two connection strings in ASP functions, either using the MSDASQL provider or the MSDataShape provider (for SHAPE SQL queries). An example of a common SQL connection string is; data provider=MSDASQL;Driver={SQL Server}; Server=SERVERNAME;Database=DBNAME;User...
  12. RichardParry

    SQL 2005 Multiple Instances

    Hi Charlie, Thank you for the reply. That's not what I want to do though, I dont want to specify the port number in the connection string, as this will cause problems (won't go into that right now!) What I have done is setup each instance on it's own IP address, but specified the same port...
  13. RichardParry

    SQL 2005 Multiple Instances

    Hi All, In short, I am having a whole load of problems running SQL 2005 with multiple named instances. Is it possible, to have the following configuration with SQL 2005? 1) Named Instance "A", with unique IP address, listening on port 1433 2) Named Instance "B", with unique IP address...
  14. RichardParry

    Restricting SA Account to IP Address List

    Is it possible, within SQL 2005 to restrict access to the SA user to one or more IP addresses? I have looked around at security hardening guides and will be following many of the suggestions, but none of them include info on if it is possible to restrict by IP. Thanx! Richard
  15. RichardParry

    Restricting SA Account to IP Address List

    Ahah, thank you!
  16. RichardParry

    Restricting SA Account to IP Address List

    I think this is the best forum for this question - Is it possible to restrict the SA login on a 2005 SQL box to a specific IP address or list of IP address's? I can't find any specs on this, but would be surprised if this feature isn't included. Thanx!!
  17. RichardParry

    Declaring Variables in View?

    Just tried that in a new SP and does the same, returns the following "The stored procedure executed successfully but did not return records
  18. RichardParry

    Declaring Variables in View?

    Update, to confirm my first variable decleration is as follows; DECLARE @membertitlelength int SET @membertitlelength = (SELECT MAX(LEN(TITLE)) AS TitleMaxLength FROM dbo.S_CLIENT HAVING (MAX(LEN(TITLE)) >= 1)) I have noted that, within the SP, if I remove the (SELECT...) and replace with...
  19. RichardParry

    Declaring Variables in View?

    Hi All, Quick thank you for the excellent support I have been receiving on here the last few days. I have another question though, I have developed a pretty monsterous T-SQL query in View mode, however I need to declare some variables based on SELECT (integers, so I can use their values in a...
  20. RichardParry

    Output Field Length

    Hi All, I think this should be my last query in relation to a recent export I am trying to do from a DB in T-SQL. What I need to do is within my SELECT output is specify the character length of some columns. For example, although the data in the column may only be 4 characters I need to output...

Part and Inventory Search

Back
Top