hello I am having some problems with SQL server 2005

1) How To import excel file in SQL Server 2005 ???
    I am using the DTS Package for data import and export. It always gives
the error...
    I am not able to import the excel shit to SQL 2005 table.. This process
works for SQL Server 2000

2) Also when  I change some columns or add columns to table Every time i
used to keep the track what i have changed
    using alter statement. I add the row to tables. If i script the table
defination the table is newly created by dropping old table.
    Is There is any way alter table defination without loosing the data in
the table.
    I am having 730 tables in my Data Base. When i release the version of
my software every time i have to keep the track for all
    database and for all clients on which date which client is given the
updation. I having more than 100 clients  and 2 client
    companies  also their clients.


-- 
Rakesh Hendre,
Sr. Software Engineer
Brilliance Software Systems.
Mob : 9960001862

-- 
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to dotnetdevelopment@googlegroups.com
To unsubscribe from this group, send email to
dotnetdevelopment+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net

Reply via email to