Hi,

I use these headings, they might give you some ideas:

Instance Name

Current Version

Status

Additional ?Components

Databases

Backup Strategy ?(DB, Log, Server)?

Maintenance Plans

Authentication

Notes

I usually note the location of the system and user DBs. I'm...

Hi Adam,

I'm glad you got it working. According to the statement referenced here http://www.oracle.com/technology/tech/windows/index.html, Windows 7 and Server 2008 R2 will be supported in 11.2, due in the first quarter...

Hi Adam,

Was it the full client you installed? If so, the OLE DB driver is in the 'Oracle Windows Interfaces' component, which is not automatically checked for installation IIRC.

It...

Hi,

If by 'dump' you mean an export file (.dmp), then you will need to import it into an Oracle database first. Then you could create a linked server etc. for...

Just out of curiosity, if your SQL Server is in a Domain, could you not do this by creating a login to deny connect permission to Domain Users? That would...

Deleted - didn't realise issue was resolved. :Whistling:

Hi Maxer,

Good luck with the exam. You might want to take a look at http://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2008-Administration.productCd-0470247967.html. (I prefer books that I can later use for reference or examples, rather than 'how...

Hi Hernan,

Are both the 2000 and 2005 SQL Servers using the same collation? I wonder if there is some sort of character string conversion happening. If you try -

select...

Very useful article and discussion - we have removed the built in group from some of our instances, and I did wonder how we would recover from a SNAFU. Thanks.

Nice-looking date dimension table. 🙂

Yes, Jeff is right - it is an outer join with "mtn_wtn_name_ap_dtl_rt". You need something like:

from ens_cust_profile2 c

inner join join delta_product_ext_tbl d

right outer join mtn_wtn_name_ap_dtl_rt e on ...

This syntax...

I agree with RML51 - I would grant 'db_denydatawriter' as well, just to make sure. 😀

I agree that it would be simpler to use the command line. Alter the database...

The default naming for log backup files is:

[dbname]_tlog_[yyyymmddhhmi].TRN

For example:

xyz_tlog_200907070515.TRN

I think that the timestamp part of the filename is usually the time when the backup completed. If you are doing...

See MetaLink support note 466267.1 How to Setup DG4MSQL (Database Gateway for MS SQL Server) on Windows 32bit - it's for 11g. I believe that there is a license charge...