Search results for query: *

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

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

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

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

Hi, i cannot see my sql server 2000 error logs via enterprise manager. the files exist on the server. is there a way of getting around this? thanks in advance

Hi, when i log onto my database using oem web console, i get the following message: java.lang.Exception: UnknownHostException sending request also, the hostname displayed, is the wrong one. how can i correct this? thanks

Hi, I have a test database which has the same tables as my production database. Some data in the test tables is the same as the data in the production database, but both test and production have data which the other does nt have. What is the best way to copy the production data into test but...

Hi, i will be setting up linked servers from sql server 2000 and 2005 to an oracle instance. 2000 is on one server and 2005 on the other. do i need to install the oracle client on both the sql servers?

Hi, what are the performance implications with setting up databases auditing on a 10g database? Thanks

Hi, i am moving all databases from one server to another. I have just installed sql server 2000 on the new server and copied across backups of all databases (user and system) to this new server. i want to restore the master database first (i take it this is best practice?). therefore, i am...

Hi, I'm not sue if this post is appropriate, but I am looking for mysql training (specifically high availability) Does anyone know a company (other than mysql themselves) who offer mysql high availability training? UK/Europe based preferably Thanks

Hi, I have a 9.2.0.7 enterprise edition database. Is it possible for me to clone it onto another server running 9.2.0.7 standard edition? Thanks!

Hi is there a way to implement case sensitive passwords for an Oracle user? i will be authenticating using database usernames not OS authentication Thanks