I am trying to import of data from my Access 2003 tables in to SQL Server
2005, via SQL Server Management Studio (Import and
export wizard). All accesstables have been imported with no errors except for
this last one "Transaktionsrader"

In my application installer, I'm planning on including SQL Server 2005
Express.  Can I also include the SQL Server Management Studio Express (on
the installation CD)?  Or MUST the user obtain this from Microsoft directly?
--Troy

I've installed the SSIS component and i'm trying to import data into an
existing table.  I can't find an option, via the import/export wizard, to
direct the import to a specific table.  What happens currently, is a new
table is created each time I import.  Does anyone know how to ...

I frequently have to copy fairly large datasets from an SSMS result set into
Excel.  This works fine, except that it seems each time I do a copy/paste,
the copied data remains in memory - but not visible on the clipboard.  So if
I copy 55K rows X 15 columns, this increases the ...

Hi, used to have no problems with generating database scrips in version
2000, but now in version 2005, these scripts actually do not work! I mean I
run them to modify objects on the another SQL 2005 database but nothing
happans!??? And their text looks very stange. What do i do ...

RE: Sql Server 2000
I am using the EM DB Maintenance Planner to set up maintenance for several
db's.  In the dialog box I have checked 'yes' to 'Reorganize Data and Index
Pages' and 'Check DB Integrity', and also 'yes' to 'Perform these Checks

I am wondering if there is an option I can set in SSMS (2005) that will
allow me to specify that I want to script object permissions when I generate
a create script by right clicking an object in Object Explorer.  I know that
there used to be such an option with ISQL.exe in ...

We have Microsoft SQL Server 2000 with Service Pack 3a installed. In
one of our databases, we have a table REQ with one of the fields
COMMENT being defined as TEXT. Now, when we try to view the COMMENT
field, it shows us only English characters whereas the Chinese

Hi, please tell me where I can find Common Objects in SQL Server
2005.....that who appear in Query Analizer (SQL Server 2000)
Common Objects:  Configuration Functions, Cursor Functions, Date and Time
Functions etc

We are having trouble tracking down some deadlocks and so I decided to use
the new event Lock: Deadlock Graph Event and I set the Events Extraction
Settings to Save Deadlock XML events separately, which was the only option I
could check. When I attempt to open the file in ...

And if so, any pros and cons ? I have heard that Spotlight can be an
overkill on OLTP applications.
Let me know..

I realize that this seems odd, but I want to change the copy paste
behavior in SSMS.
Right now if you have no text selected in SSMS and do a control-c the
entire line is copied, but I want the copy to be null.  Basicly I'm

I have looked for some time now and I cannot see how to install the
Performance Tools in a pre installed SQL Server 20005. How do I go about this?

I am receiving an Event 208 when running our autmated backup in Enterprise
Manager.  The job use to run fine however possibly a change in password
caused this to stop working?  The error states:
Event Type:    Warning

Though most of the changes we might be able to get used to, there is
one super annoying change we have not found the equivalent to:
What is the equivalent of using the 2000 EM
Right-Click--->Open--->Query method in 2005 ES?   That was always the