I'm attempting to upgrade a SQL 6.5 server directly to 2000 (in a test
environment for now) using the upgrade wizard.  The following error occurs
early on in the process:
"Couldn't create or register the SQLUpgrade DSN"

I'm trying to select data from a field that varies between 5 to 7 characters
in length.
I want to trim the last (right) 3 characters, to return values that are 2-4
characters in length.

Can someone tell me if there is any difference in the audit log available in
SQL Server 2000 and Yukon?
TIA
irfan

How do I get it back to the default 'Results in Grid'?  No matter if I
change it and close, change is and save and close, it always comes up as
"Results in Text" and has to be changed everytime I open QA.
Scott

I have following questions regarding C#  Assembly and Threading.
Let me know the precise answer or lead me to the proper materials.
1.  Is memory leakeage possible in .Net Manager Code ?
2. Is memory leakage possible in .Net Unmanaged Code ?

the Object Browser in Query Analyzer does not display columns for my views.
I can open it up new or click refresh. In either case it displays the hour
glass figure and then 10 -15 seconds later nothing appears.
Works fine for tables.

We're in an evaluation for a backup compression tool for SQL Server 2000.
Right now Lightspeed from Imceda seems to be on top from the technical
side. Good compression, good speed, reliable, lots of features and beeing
used also by big companies (not that this alone would mean its ...

I just installed SQL 2k5 CTP.  When i try to start profiler it never
shows a window.  In the task list i can see profiler90.exe in memory.  I
 kill it and try again but i never get a window.
Dan

Is ISQL the only thing I need to package with my install to execute scripts
to create the database and it's content?
Do I need licenses for doing that?
Thanks.

I have a simple SQL script with some stored procedure;
within sp_, I've put some comments with "special" character (ie 'è'
'à' and so on....).
When I execute this script:

My librarian has a problem with is computer. He uses it to store all of
his client's asks, his inventory, etc... on a SQL server's database,
with the help of a third part program, and he never restart his computer.
He few weeks ago, some problems on our city (in France), make his

I use the Maintenance utility to backup the database.  I have specified for
it to delete any backup older than 1 day, but it doesn't delete anything.  
The old backups end of taking up all the disk space, and then the backup
doesn't complete.

I'm trying to get the debugger to work. I have SQL Server MSDE SP3a loaded on
a Windows XP SP2 machine. The debugger comes up but does not catch
breakpoints.
I tried to use the sql command Exec sp_sdidebug 'legacy_on' but when doing

Sorry for the basic question but I have an application loaded that included
SQL Server 2000. I would like to know how to find out which edition it is?
Personal, Desktop, Standard, Enterprise, etc... Is there a tool or way to
determine this?

this took some while for me to find out:
I've got a printer shared and connected to a W2k Workstation. On my W2k
Server I've set this shared printer as default printer...
I shut down the workstation and open Query Analyzer (QA) on the server, then