DBA guide

Any good SQLServer DBA guides available online? Preferably
a downloadable pdf. Or online in HTML.

Thank you.Hi

The best resource is Books Online!
http://www.microsoft.com/sql/techin.../2000/books.asp

This threads may help:
http://tinyurl.com/2pn4h
http://tinyurl.com/yuebf

John
"C.O.Jones" <nospam.ple@.se> wrote in message
news:dpLBc.2436$xy4.21713054@.news-text.cableinet.net...
> Any good SQLServer DBA guides available online? Preferably
> a downloadable pdf. Or online in HTML.
> Thank you.

DB2OLEDB for SQL Server 2005 Standard Edition

The Microsoft OLEDB provider for DB2 (DB2OLEDB) is available in the "Feature Pack for SQL Server 2005 – April 2006." The installation routine, however, will only install on the enterprise edition or the developer edition. Is the DB2OLEDB provider not available for SQL Server 2005 standard edition?

I just went through the README.htm that comes with the installation of DB2OLEDB and it explicitly states that:

The Microsoft OLE DB Provider for DB2 is for use exclusively with Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Developer Edition and Microsoft SQL Server 2005 Evaluation Copy.

So I believe the behaviour you are seeing is expected.

Thanks

Waseem Basheer

|||

If you want a Microsoft OLEDB provider for DB2 you have to install client tools from Host Integration Server. You can choose it under custom install.

i

DB2OLEDB for SQL Server 2005 Standard Edition

The Microsoft OLEDB provider for DB2 (DB2OLEDB) is available in the "Feature Pack for SQL Server 2005 – April 2006." The installation routine, however, will only install on the enterprise edition or the developer edition. Is the DB2OLEDB provider not available for SQL Server 2005 standard edition?

I just went through the README.htm that comes with the installation of DB2OLEDB and it explicitly states that:

The Microsoft OLE DB Provider for DB2 is for use exclusively with Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Developer Edition and Microsoft SQL Server 2005 Evaluation Copy.

So I believe the behaviour you are seeing is expected.

Thanks

Waseem Basheer

|||

If you want a Microsoft OLEDB provider for DB2 you have to install client tools from Host Integration Server. You can choose it under custom install.

i

DB space available 0.00Mb

Hi there,

I had originally set a max file size with restricted growth as we didn't think it would reach past it's limit. However, when I checked today it said space available 0.00Mb.

Two questions I have are:

(1) Would running out of space cause any problems to the database
(2) Can I simply just set this to unrestricted or set a higher limit and then the DB will continue to grow again?

Thanks

SUm, yes. And yes if you have space on the disk.|||(1) Would running out of space cause any problems to the database

This will always result in inserts/updates (and usually deletes) failing as there is no space available to push around the data.

Selects will usually continue to function normally.

Regards,

hmscott|||(1) Would running out of space cause any problems to the database

From BOL:

During recovery, it is a rare but possible occurrence for the server to require additional log or data space. If additional space is unavailable and either the log or data files cannot grow, the server:

1.Reports error message 9002 or 1105 in the Microsoft SQL Server error log.
2. Marks the database as suspect.
3.Takes the database offline.|||Have you tried first a :
DBCC UPDATEUSAGE ('mydb')
with mydb you database name ?

This reports and corrects inaccuracies in the sysindexes table, which may result in incorrect space usage reports by the sp_spaceused system stored procedure.

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.
Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>
|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>
sql

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>

DB Schema / Architecture software assessment tools?

Hello all,
I have been asked to research the tools available for reporting database
schema / links within SQL 2000.
I need a tool which will go through objects and also stored procedures /
queries and report all references / links. The idea being to end up with a
complete list of items in a db and what is effected by each.
Has anyone used such a tool or perhaps knows of one they could recommend I
look into?
All help is greatly appreciated, Simon.Not so sure about the dependencies but you might want to check out these:
http://www.imceda.com/Change_Management.htm
www.red-gate.com
http://www.innovartis.co.uk/home.aspx
Andrew J. Kelly SQL MVP
"Simon" <reply@.togroup.com> wrote in message
news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
> Hello all,
> I have been asked to research the tools available for reporting database
> schema / links within SQL 2000.
> I need a tool which will go through objects and also stored procedures /
> queries and report all references / links. The idea being to end up with a
> complete list of items in a db and what is effected by each.
> Has anyone used such a tool or perhaps knows of one they could recommend I
> look into?
> All help is greatly appreciated, Simon.
>
>|||thank you but these tools relate to backups, rolling out from test platform,
database design but not analysis of current schema.
Any other suggestions would be appreciated, thanks again, Simon.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:emueAUqOFHA.3828@.TK2MSFTNGP10.phx.gbl...
> Not so sure about the dependencies but you might want to check out these:
> http://www.imceda.com/Change_Management.htm
> www.red-gate.com
> http://www.innovartis.co.uk/home.aspx
>
> --
> Andrew J. Kelly SQL MVP
>
> "Simon" <reply@.togroup.com> wrote in message
> news:OjmQjCpOFHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Hello all,
>> I have been asked to research the tools available for reporting database
>> schema / links within SQL 2000.
>> I need a tool which will go through objects and also stored procedures /
>> queries and report all references / links. The idea being to end up with
>> a complete list of items in a db and what is effected by each.
>> Has anyone used such a tool or perhaps knows of one they could recommend
>> I look into?
>> All help is greatly appreciated, Simon.
>>
>