Hai All,
can any one out there help me in the following scenario.
I have a Remarks column in a table which is NVARCHAR field and length set
4000. This column value is set by a SP. Case is that when the remarks grows

Web Data Adminstrator Problem
Hey all,
Okay so here is my problem. I have installed WDA on a 2003 server with sql server 2000 and sharepoint 2003. When I go to start the Microsoft SQL Web Data Adminstrator program and I choose the IIS option I get the following error:
Server ...

Is backup and restore the best way to simply copy a database from one
SQL Server 7.0 database with 'select' access to another SQL Server 7.0
database on another machine with 'all' access ? Or is there another
easier way with the SQL Server 7.0 tools ?

I have migrated by SQL2000 install to ActiveDirectory from NT40 domain.  
During the process I had to change the agent that runs sql engine.  The
domain of the ID changed.  Now I have lost my counters for the sql instance
and don't know where to find them... kind of like the three ...

SQL 7.0
Is there a way to count the number of times a table is
accessed with a Select statement? This select is from a
third party application not a stored proc or QA.

We have a database solution that was created by a 3rd party vendor. Over time we have replaced their applications with our own in-house applications, however not all of our programs have been upgraded so some of the tables and stored procedures may still be in use. Is there a ...

Windows Server 2003 running SQL Server 2000 SP3a
When I run SQL Profiler against the local database, I can start a trace, but
I can't stop it.  I click the Stop button and see "Stopping trace"
indefinitely.  New events continue to scroll in the window, but the trace

I would like to include all processes on a particular machine using
SQLH2.  I am trying to pinpoint a specific application that is causing
issues on the machine.  But in the following line (clipped from
H2PerfConfigFile.xml ...

I have a maintenance plan to backup my database and the T-Logs.  When I go to
the directory were I set these to be backed up to I have the DB backups but
there are no .TRN files for my t-logs.  any idea why my maintenance plan
wouldn't backup my t-logs?

I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT.  I also have the
same version of SQL installed on W2K / P3.  The Enterprise Manager seems to
run much slower on XP than on W2K.  A simple click in the left pane (e.g. on
'databases') results in 20-30 second wait (the disk ...

A very simple question...
When I edit the data in a table how can I enter a Guid value in Enterprise
Manager?
I've tried:

I need to implement an automated change configuration notification process
for all my current SQL server configurations.  I don't know if SQL-DMO is the
way to go here, but I certainly do not know enough about it to be proficient.
Any web links and info would be greatly ...

I cannot get the below to grab multiple attachments, I need it to grab
three .csv files and it gets the first one no problem but then it says
the second doesn't exist when I know it does.  Anybody ran into this
problem?

I'm using SQL Server 2000 (latest service packs) and MSDE (latest
version).
I'm trying to copy a database (all of it) from SQL Server 2000 to MSDE.
On the export wizard I am selecting:

Dear Collective Wisdom,
Noticed something odd back when we first upgraded to XP in that when one
goes to view an existing relational diagram object for a database in
Enterprise Manager, everything appears blank in the diagram. New