Hi All. I have just updated the SQL 2000 Developer Edition to SQL 2005
Dev Ed on my PC. I used query analyzer exclusively in 2000 so I am
sorry if these are stupid questions.
1. If I am writing a general query in the new query window (Data | New

I'm running a query through query analyzer, outputting the results to a file
in an effort to move some data from one bug tracking system to another.  
Simplified down to the basics, my query looks like this:
SELECT '<MyXMLTag>'+CAST(TextField AS VARCHAR(8000)) + '</MyXMLTag>'

Hi everyones,
Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005?
thank you
serge

I am in the process of evaluating SQL Server 2005 (Developer Edition) on a
Windows 2000 SP4 member server in a Windows NT domain with three domain
controllers (not active directory).  I have installed both operating system
and SQL server software from scratch and succeeded at the ...

Helo group:
I was using a SQL Srvr 2000 in a Win 2003 box. I had configured the SQLMail
and everything was working, but now I´m receiving this message:
xp_sendmail: failed with mail error 0x80004005

Hi...
I've noticed when using Microsoft SQL Profiler, when prepared statements are
in use, yields only such information as "sp_execute 3, 12, 34" etc. This
contrasts with using stored procedures, whereby I get the entire "Select"

when I open a DTS package (or create a new one) I get the error:
DTS Designer error
The system cannot find the file specified
then the package opens, but there are no objects in the "tasks" pane (the

We are having a website that generates postscript files when an order is
placed on it. These files are placed in a folder on the network.
I have been told to Load the postscript files into an existing sql database
and then delete the file from the folder.

I have a SQL user on a 2K server that has an invalid default database
(dbname in syslogins is NULL).  I have both Enterprise Manager (EM) and
SQL Studio Management Studio (SSMS) installed.  I can set this attribute
in EM, however when I try to set it in SSMS I receive the ...

when I try to run a select-statement to an oracle database (10.1.03) with a
parameter from the SQL-area in MS Reporting I get a message like:
'The provider can not determine parameter information and setParameterInfo'
is not called' (or similar, the original message is in german).

I am familiar with loading a DB so that it will work under MSDE.  This
is the command I use:
osql -S ServerName\InstanceName -E -i ScriptName.sql
So now I uninstalled MSDE and am using SqlExpress instead. To do the

Using SQL Server 2005.
(Tested on Developer edition running on XPSP2 & Enterprise Eval running on
Windows 2003 SP1)
1. Create a backup device Device1

when i design a report using SQL 2005 and try to run it in production mode
with setting the servertarget rul property of the project to http://localhost
i get an error that it cant connect to the local host, but when i click the
preview tab i find the report with correct data so ...

Does anyone know of a quick method to data from a Foxpro database to SQL
2005.
Tony.

I have following problem, one of our SQL2000 databases is being feed every
night from external CRM system by mean of ODBC DSN data source, most of the
time is working fine but sometimes we have an instance there not all of the
data is pulled over, I can go then and add missing ...