hey,

Here is a good reference guide outlining what you need to consider.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

Thanks,

Phillip Cox

MCITP-DBAdmin

hey,

Great result!

This is a server level option, thus you cannot set at db level.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi Sam,

Ok, you may want to consider pre-allocating your anticipated space in advance to prevent auto-growth, as the growth requirement for...

Jennifer Schepers (3/10/2008)

---

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

Hi Sam,

What growth size have you configured your files to grow by? How many disk support your files?

Thanks,

Phillip Cox

MCITP - DBAdmin

Nita Reddy (3/10/2008)

---

I am getting so many threads in sleeping mode and Awaiting Command and its been there since Feb 28.

Why this is not getting close automatically or who do...

Hi,

Assuming you want to list all tables in current database? If so, here's one solution:

SELECT * from sys.tables

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi Jennifer,

Sorry, but are you trying to connect to SQL Server 2005 from your Oracle Transparent Gateway tool? If so, you will need to speak with SQL Server on...

Hi keith,

Have you checked remote server for possible cause of timeout? I would review remote server to understand what happens around this time, as it seems consistent.

Thanks,

Phillip Cox

MCITP -...

Hi,

Agree, gather any and all documentation from the departing DBA. Ideally, the existing DBA should take time-out to walk-through the current infrastructure and allow you to ask any and...

Hey,

sp_who or sp_who2

Cheers,

Phillip Cox

MCITP - DBAdmin

Vish,

Just out of curiosity, what are you trying to achieve in terms of security?

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

BOL is a very good reference point, so please use it!

Most importantly, make sure you understand NOT remember the content and test everything you learn, as real world type questions...

Hi,

This sounds like an issue with the Connection Manager resolution at runtime, maybe due to memory pressure or a timeout issue with OLEDB provider, as the connections are not created...

Hi,

Ok, this setup is not a good setup, as you should have a minimum shared storage and seperate disk resources for data, logs and quroum.

Why are you using...