I am looking for a way to select some data from a Access database into my
SQL database.
In Enterprise manager, I want to do someting like:
SELECT InvoiceNo, CID

 Our production is running on Sql Server 2000. It works pretty goods
but for the last couple of weeks we are getting the below error! As a
fix we just restart the SQL Server service and it just works fine. It
has been happening quite often these days. The thing that surprises

I have SQL 2000 and SQL 2005 on my development machine. I used to use
Enterprise Manager to work with 2000 databases. Now I have Management Studio
which can connect to 2005 servers as well as to 2000 servers.
If I open any object (table, SP...) in 2000 database via Management ...

I have two active clustered instances and both are running SQL 2005 SP2+CU7.
One of our application has confirmed that it can only work with SP2 (no CUs).
We have decided to reinstall SQL on one instance, but when I attempt to
uninstall this instance via A/R Programs, and after ...

I am on SQL 2005. How can I determine what type of SQL 2005 I have (workgroup
v/s express v/s standard).
I am told that my SQL 2005 is workgroup edition but when I go to the
properties of the SQL instance, it shows up as Microsoft SQL Desktop Engine

Back in February, I had a problem removing a user from a role and
ended up deleting and re-creating the user.
Now, on another server in a different environment, I am having the
same problem.

I have a 2005 db in full recovery mode. The db is 6 gigs in size but the log
file is 23 gigs in size. I believe running a backup on the log file should
truncate the log unless there is an issue like a long running transaction.
BOL recommends to look at the log_reuse_wait value. ...

Had an interesting problem on a SQL 2000, spk 3 machine last night where a
DTS data pump failed with the target database reporting the primary file
group is full.  But when I looked at the server it's not.  
Anyone have thoughts, etc.?

Would I be right in assuming that if we are seeing a number of cachestore
flush due to 'DBCC FREEPROCCACHE' type messages it is because our data cache
is under a lot of pressure and is casting out data?
This is on SQL2005 build 3175 running OLTP apps on W2K3 SP2.

--I'm trying to separate the time after 3:30pm from normal time, and
add the excess time to 'after time'
SELECT convert(varchar(8),service) + ' ' +
convert(varchar(8),code)  as Service_Code, --Tacking on the service

SQL Server 2000 SP4.
We have a client request to print a database diagram into one big file where
the diagram shows relationships, table/column names. The database has about
96 tables. When I print from the diagram, it prints 12 pages. What is the

is there any way to have a view "vwOnTblA" which is accessible from
a "aUser" but which have the underlying table "tblA" which is NOT
accessible from "aUser"?
Platform: SQL Server Express 2005

I need to monitor approx. 10 sql servers (2000 and 2005). I will be getting
a new monitoring server. This server will also be used to create reports (SQL
server reporting services) from databases on various servers.
What disk size, memory etc.  should I be looking at, if I need ...

I have a question about how to escape database names in the BACKUP
command. SQL Server allows for all kinds of weird characters which can
wreak havok with the syntax of SQL commands. For example, if my database
name is "123[test]{this}@! TO DISK = 'C:\test.bak'" the command ...

For SQL Server 2005, let's say a machine dies, but you have backups
for everything (all user and all system DBs).
After getting a new machine and the OS installed and SQL Server
installed and the DBs restored, are there any configuration items