I am trying to load a text file into SQL Server 2005 and I get the following
error messages at the validation stage:
Messages
•    Error 0xc00470fe: Data Flow Task: The product level is insufficient for

Does running the SQL maintenance tools such as indexing and checking while
users are using the database cause problems?
Thanks

Hi,
Environment: Win2000, SQL2000
Both the command file and SQL2000 are installed on the same machine.
I have a command file with the following SQL statement:

I want to execute more than 30 sql files in the command line.
isqlw -d DatabaseName -E -f "*.sql"
   ---> this opens all the sql files in the query analyser.
isql -d DatabaseName -E -i "*.sql"

Hi I am having problem connecting to my local sql server(my machine).
Though I am connecting to the network server fine but as I try to
connect to Local it gives me following error.
Unable to connect to SQL Server EUSD123:

In SQL 2000 Query Analyzer, when I generate a script of a table it generates
the default name in addition to the default value for a column when I
generate the table. In SQL 2005 Object Explorer, the default value for the
column is scripted but the default name is not in the ...

How can I open a file in an existing query window ?
I did this frequently to very often in sql server 2000 query analyzer.
I'd open a script file, complete running it, open the next file and so
on.

I'm importing data from formatted text files with accent (Latin1). My
database is set to French_CI_AS. I use bcp with -C"Latin1" or
-C"French_CI_AS" but bcp seems to  ignore the flag and every single accent is
left behind.

My developers just started having this problem a few weeks ago.  Nearly
any type of "design" table changes are failing in Enterprise Mgr.  This
only seems to be happening on the servers running Enterprise Edition.
Standard Edition and MSDE do not have the problem.

Can someone help me for a SQL query to delete all the transactions from 2
SQL table?
Here is what I want to do.
"Go thru all the transactions in both table A and B

I defined an "external tool" in SQL SMS 2005 to launck the notepad. Every
time when I click it SMS tries to save all my pened windows (opened queryes -
and I have a lots), asking me the save path and name. It's very weird. May I
disable it, or it is a bug?

I have a database with a column defined as varchar(100) called Surname.  
When I use Query Analyzer to retrieve data from the column and display as
text, I get strange text appearing for one of the records.  Thus, the field
contains "Wilson" but when I run the following:

Sqlserver 2005 Management Studio 'Object Explorer' lists servers, similar to
Sqlserver 2000 Enterprise Manager.  However, I can't find any way to sort
object explorer's items?  Also Enterprise Manager let you create folders to
organize your registered servers; I can't find a way ...

How do you convert a time stamp into actual date in SQL
When we try to convert it, date that we get doesn't make sense (date we
supposed to get is like year 2001, but date seem to be very very old)
MC

I created a project type "SQL Server Scripts" in "Microsoft SQL Server
Management Studio", and the default structure created was:
+ Project Name
    + Connections             (Type 2)