Does any one know any good file defragmenation software for sql server 2000
database files? The server needs to be online always and should not affect
database activities? Is it a norm to do file defragmenation for sql 2000
database that have 100 GB of data?

Id like a nice front end that I can drop to get the server I want or even
combine multiple perfmon sessions for servers in one look and feel.
I also want to look at event logs, current OS /SQL info.. Current
applications running....etc..

I have already posted this question in a different forum it was recommended
that I post it here instead.
I am having a problem setting up sql agent mail. I am running in with a
groupwise mail system but I have it running POP3 so I should be able to use

any good Hot Backup tools recommend ?
thx!

  I am having a problem on how to merge 3 columns into one column. I have a
columns named [LastName], [FirstName] and [MiddleName], I want those columns
to be as one and name it as [Name]. How will I do that? I already tried the
trick like what I did in Access but it does'nt ...

This may have been mentioned before but why isn't there a "Close" button on
the Find dialog in the Query editor?  Yes you can close it via the tiny X in
the corner but it should have a close or done button as well.

In query analyzer, when I have a cursor that runs through some code
enclosed in the begin and end statements. But, if the cursor dataset is
larger then 20 records, on the 20th record, it will give me this error.
The first 19 records will process fine.

Can a sysadmin be denied of a select statement? Id you ad
a user to the system administrator then deny them rights
to a column can they still use a select statement?

Does anyone know where I can find excercise examples on  
parameters
Thank you

Can I programatically (from f.e. c# program) catch incoming queries to
an SQL server?
I want to watch and analyse them, if such queries are
create/alter/drop I want to log this information in a database to view

I'd like to analyse my db. Does anybody how to get an overview about the
table sizes?
TIA
Pete

I am very familiar with insert statements, but how does a
value get passed for a user name and password from either
a web or windows application i.e
A simple insert statement would be

I have 5 tables each in two databases database1 and database2 in SQL Server.
Now, I want to create a database diagram for documentation purpose in
database1 wherein I want to include the tables in database2. Is this
possible. If yes, how can I do this.

I am very familiar with insert statements, but how does a
value get passed for a user name and password from either
a web or windows application i.e
A simple insert statement would be

Hi, I have a SP that adds an Excel  file as a linked server, then tries to
send the result of a query into this file.
I get the following error :
------------