We have an XP workstation containing a very important MSDE-based
application. Its MSDE database isn't likely to change for quite a
while.
The app contains an internal backup method (File, Backup, Backup) and

I need to convert SQL Server 6.5 data to SQL Server 2005 (Express).  How do I
do that? Where do I get the necessary tools?

what default sample does SQL 2000 use when you issue an Update Statistics
command?  How do I set it so that SQL will use the same sample all the time?  
I am finding that when I run DBCC show_statistics many of my larger tables
(million rows or more) will have a sampling much ...

I'm hoping someone here will be able to tell me what's going on.  Here's
what's happening:
On my old laptop, I had SQL Server Enterprise Manager installed, I believe
it was version 8, but maybe not.  Noticeably, when designing views, things

By mistake I added the "Next topic" and "Previous topic" twice in the
toolbar and I don't know how to remove/delete one of them. To add the "Next
topic" in the toolbar by bring up the Customer window(right click on toolbar
and choose customize). Select "Help" in the categories ...

I have a client that installed SQL Server Enterprise Edition for the Engine
but already had SSMS Express Edition installed.
Now I need to uninstall the Express Edition of the tools and install the
full featured edition.

The Security Catalyst had an interesting post last week, The
Psychology of Fraud -Revisited.
In the post, Sarbanes-Oxley auditors are criticized for focusing on
minutia that is costing corporations millions, while the real cause of

i have sql server 2005 express
and i cant find the sql server agent that was like in sql server 2000
why is that? where are the jobs?
thnaks i nadvance

The sql server 2005 managment studio that I work with does not recognize a
-- as a comment when I am executing a script when the -- starts in column 1.
I can put the -- starting in column 10 to whatever as long as there is a sql
statement and the -- on the same line.

I'm hoping that someone can help me clarify some questions I have
regarding BACKUP and how files are replaced. Ideally I want to perform
backups to a single file, replacing the appropriate backup when it
expires. How can I do this?

I am trying to print a report from Reporting Services in C# code. Is this
possible?

Can i use SQL Server 2005 Express Management studio to connect to a SQL
Server 2000 Instance.

There seems to be a problem with SQL Profiler 2005 recently. It was working
till date and recently it is not starting up all of a sudden. I get the below
message.
PROFILER90.EXE - Application Error : The application failed to initialize

With earlier versions of SQL server and Enterprise Manager it was easy to
see which sql server agent jobs have failed - you could just look down the
list for any jobs with a red X by the job name.
Though with SQL server 2005 and Management Studio there's no indicator for

Our IT production support team stores miscellaneous SQL scripts for support
items on a SharePoint server (WSS 3).  However, to edit these scripts, the
user must save a local copy of the file, make the change and then re-upload
it, ensuring the name is the same.  This triggers ...