Recent IT Questions

1 - 16 of 16
<<PREVIOUS 1 NEXT>>

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....

asked by Sagar2000

  5 pts.

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.

View Answer   |  Dec 9 2008  8:00 AM GMT
Microsoft Access, SQL Server 2000, Database migration
asked by VBNET

  5 pts.

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

asked by Ambrish 82

  230 pts.

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.

asked by Balecha

  10 pts.

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

View Answer   |  Oct 9 2008  9:33 AM GMT
SQL Server 2005, SQL Server 7.x, SQL Server migration
asked by Bertski

  15 pts.

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...

asked by Db23

  230 pts.

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?

View Answer   |  Oct 8 2008  4:54 AM GMT
XML, SQL Server 2005, SQL Server import/export
asked by Sunithashree

  5 pts.

For Save .doc file in Sql Server 2000

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

asked by Karankhandelwal

  5 pts.

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' /* ...

asked by Ariel

  5 pts.

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.

View Answer   |  Sep 8 2008  5:33 AM GMT
XML, SQL Server 2000, SQL Server import/export
asked by Mitha

  10 pts.

Saving Query results into Excel format

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

asked by Preetg

  5 pts.

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.

View Answer   |  Aug 29 2008  8:58 AM GMT
XML, SQL Server 2005, SQL Server import/export
asked by Mitha

  10 pts.

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.

asked by Kumar9378

  25 pts.

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

asked by Kumar9378

  25 pts.

SQL 2005 to .XML

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

View Answer   |  Aug 21 2008  9:13 AM GMT
XML, SQL Server replication, SQL Server 2005
asked by Camofa

  5 pts.

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

View Answer   |  Aug 7 2008  5:22 AM GMT
XML, SQL Server import/export
asked by 11111122222

  5 pts.

1 - 16 of 16
<<PREVIOUS 1 NEXT>>