Search results for query: *

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.

Hi, when i run the 2005 install I am not getting an option to specify the instance name or the sa password. I'm installing standard edition by running the splash. file Any ideas? I would have thought there was a page that should have displayed with these options as has been the case on other...

Hi, I have a sql 2000 server with 190 databases. Most are approx 70 mb in size and all need to be backed up. The backup takes about 2 hours every night. Is there any obvious way of speeding that up? Thanks

Hi, I am working on a site with 20 sql server 2000 servers and 3 sql server 2005 servers. the customer uses lotus notes. is it possible to set up sql mail, alerting etc using lotus notes? Thanks in advance

paul, yes the first one is under errorlogfile. am searching now for the second

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent =C:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters (does not exist) the startup parameter points to the correct location. i have set the audit...