Search results for query: *

Any ideas on this one? :)

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+...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

Ahah, thank you!

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!!

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

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...

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...

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...