Recent content by beechill4

thanks, I has the same issue as you: it's not very clear on the MS site.

Hi, that's what i thought but i just called microsoft and they tell me I need 70-431 first and then 70-447 to qualify

Hi, i have the mcdba certification and want to go to mcitp. Can anybody confirm how many exams i need to do? Is it just 70-447? Thanks

Hi, i am trying to write a script that pulls out what sql server jobs are setup on sql server 2005. In sql 2000 i used the following script: PRINT ' BACKUP Plans' PRINT '---------------------------------------------------' SELECT [name], [originating_server]...

Hi, I've an Access database which tables are linked to a SQL Server. I can enter data in SQL Server directly, in most of the tables in Access but nothing through the forms in access. Strange that I can enter data in some of the tables but not in all. Any ideas why it is so? Thanks!

Hi, I'm getting a number of strange errors which we cannot diagnose on a SQL 2005 server. Date 6/20/2008 11:00:31 AM Log SQL Agent (Current - 6/20/2008 11:00:00 AM) Message [298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001] Date...

Hi, I wish to have a timeout period for all my sql server (2005) jobs. I have gone into the properties of SQL Server agent in mgmt studio and set the job system timeout to 600 seconds but some jobs continue to run for over 1 hour. Can someone offer some advice please? Thanks

Hi, is there a way of telling when a database file was changed in size and set to autoextend? tried the error logs and nothing there. Thanks

dave, took a slightly different approach: 1. created a new temp tablespace 2. changed this to be the default temp tablsepace 3. dropped the original tablespace

Hi, metalink has advised to recreate a temp tablespace to get rid of some i/o errors. what are the implications of doing this?

thanks! has anyone any good performance and security related scripts i could run?

on oracle and sql server, would check for the following: 1. security breaches 2. poor performance indicators 3. backup & recovery 4. database storage

`Hi, i'm new to mysql. does any one have a list of dba type checks that they use for mysql? Thanks

yes. it installs management studio, reporting services, analysis services etc.

the server has no other installed sql server options. when i open management studio i can connect to other sql server 2005 instances but not this one. during install, i was not given any options for authentication mode, instance name, system databases etc.