Gail - thank you for your help. From what I gather from your other posts, I don't want to implement the /3GB switch as it may starve my kernel...

GilaMonster (5/2/2008)

---

schep021 (4/25/2008)

---

The plan is to set the max server memory to 6.5GB and min server memory to 1GB. I think all we need for switches is /3GB since...

colin Leversuch-Roberts (4/25/2008)

---

here's some info which may be of use http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

x32 and memory. It sort of depends upon what you're actually doing on the server, but -...

SQL Noob (4/25/2008)

---

i had this on 64bit servers in a few cases

solution was to enable lock pages in memory, not sure if you need to enable AWE and the rest...

Thank you for responding Gail. We are running SQL Server 2005 EE on Windows 2003 (32-bit). We have 8GB of memory on the server available. Min and...

Well, that would explain it. I just didn't see that. Thanks! 🙂

I am running it from within Management Studio ... after turning on SQLCMD Mode.

SQLCMD is a command line utility...

I am trying to execute this in SQL Server 2005. I can use the variable in some ways ... but,...

Thanks Mark! 🙂

Jen

Tim,

Thank you for taking the time to respond. We currently don't have any scheduled SSIS jobs. My goal was just not to mess up the Veritas...

Phillip,

Yes, I must not have worded that last entry correctly. We are now able to connect and good to go!

Thanks you for following up.

Thanks,

Jen

Phillip - thank you for your advice. We were able to solve the problem on our end. It did not turn out to be additional firewall issues. ...

1. 1 SID

2. There is one oracle database that is trying to access one sql server database.

3. I think so

4. I think so

5. We do have a firewall -- another...

Phillip,

Thank you for the prompt response. I am trying to get an oracle db to be able to grab information from the sql server db.

We installed the...

Hello. Not sure why -- but, have you tried running the statement in another mode... replace 'DETAILED' with either 'LIMITED' or NULL? Maybe these will give you...