How do I change the time and frequency of the collection tool? The wizard
supposedly created a task to run once a week. I can't change the options
using the tool. Is there somewhere else I am supposed to look? Thank you.

Anybody have any ideas why the Query Analzyer process starts
but the UI never appears??
This is on Windows XP Prof and SQL Srvr 2000.
Thx,

Hello and thank you in advance for your assistance.
I am trying to rid myself of the necessity of running a local server (2000).
I am currently relying on Enterprise manager in SQL 2000 to administer
databases that are hosted by my ISP.

Hi all i have problem with SQLH2. SQLH2 installed on Windows XP Pro SP2
Russian.
Version SQLH2 is H2 Collector   ver. V2 2.0.024.0 9/30/04 17:58
this is log

Can someone point me to a location where I can download a white paper on the
differences of Reporting Services 2000 and Reporting Services 2005?
Thanks.

i'm writing an application (using Delphi 7) in which i must use a DTS to
export data from a MSSQLServer database to a Paradox one. I made it up on a
machine where i can have it working properly, but when i try to use the same
application on another computer i get an "invalid ...

Is there anything that would cause a "not in" clause to not work in SQL2000?
DETAIL:  I have 2 simple tables called "People" and "PeopleImport".  Each of
these tables has a "flxID" field of type varchar(10).  There is a record in
the "PeopleImport" table with a "flxID" value of ...

We are currently running our SQL backups to our local disk drive. Now we'd
like to change the path from local to a shared folder on another server on
another domain.
Is that possible?

Is there a way for a user to view all tables and/or table schema using
Query Analyzer, or other tool, like the SHOW and DESCRIBE statements in
MySQL?

Has anyone got experience connecting to a MS SQL Server 7.0 over the
Internet from a Linux Web Server using PHP4.3.x ?
This for a Real Estate MLS IDX feed.
I have heard I can use ADODB and another said FreeTDS (Tabular

Is there a graphical SQL query builder anywhere in SQL Management Studio
for SQL 2005? I can't find one, nor can I find any reference to one in
the help.
Am I being thick (the most likely option) or is it missing? If it is

I used the Database Maintenance Plan Wizard to create backup plans for the
master, msdb, and model databases. The model database backs up just fine, but
I get the following error for the master and msdb:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan

We use bcp a lot in production and redistributable software.
We'd like to get bcp to terminate early if it runs for over a certain amount
of time due to locking/deadlock/...
Thus, I'm trying something like  and it's not working - ideas?

New to MS and MS SQL... What does register a server do in the
Enterprise Manager?