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

    Connecting overseas (remote) SQL Server

    It's working now. It had to do with the order rules were processed on our firewall. Go figure.
  2. mhavens

    Connecting overseas (remote) SQL Server

    Yeah, I've tried both by IP and by named client connection
  3. mhavens

    Connecting overseas (remote) SQL Server

    I can't seem to define a SQL Server in Enterprise Manager that will connect to our overseas SQL server. Both are SQL 2000 SP3, and I've created the client alias, using the TCP/IP protocol, and telling it what port to use. We believe we'ver opened up the firewall for this IP/port combination on...
  4. mhavens

    Rounding float values - help!

    SELECT ROUND(163.69999999999999,2), ROUND(CAST(163.69999999999999 AS float),2) 163.70000000000000 163.69999999999999 Why doesn't the second value round? What about float types keeps this from rouding up?
  5. mhavens

    ISS training recommendations

    Hello - My company is going to be asking me to assume some IIS responsibilities, along with some small amounts of Cold Fusion. I'm the SQL DBA here, and need to know what resources are particlarly helpful in getting up to speed. Books are ok, so if you have some recommendations on some, that...
  6. mhavens

    Arcserve SQL Agent & SQL security

    We were trying to disable the sysadmin flag for the SQL Builtin\Administrators group on our SQL Server. I created the network account in SQL with sysadmin rights that Arcserve should connect with. Arcserve wouldn't connect to the database using the client agent or through the network tree unless...

Part and Inventory Search

Back
Top