SQL Server Import/export

Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue....

Migrating data from Microsoft Access to SQL Server 2000

I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

How to upload data from Excel into SQL Server 2005

hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav

Updating Microsoft SQL Server tables from Oracle generates error

i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

Transferring SQL 7 DB to SQL 2005 DB

Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert

Is it possible to copy system DBs to another server?

Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

Creating XML file using SQL Server 2005

How to create a xml file using sql server 2005? what are all the steps to do for this?

For Save .doc file in Sql Server 2000

I want to Save Word File in SQl Server, how it is possible

Error when translating execute immediate from Oracle to SQL

SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* ...

Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format

i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

Saving Query results into Excel format

How can I save query results into .xls format directly from Microsoft SQL server Management studio?

I want to load XML to a table in SQL Server 2005

i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.

Oracle to SQL Server Migration - CURSOR type conversion

When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Oracle to SQL Server Migration - User Defined data types

Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

SQL 2005 to .XML

How do I automate 2 sql servers to replicate .xml files

xml create form sql database

i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file