On Mon, Mar 12, 2012 at 11:37 PM, The Master Mind <rakesh.hen...@gmail.com> wrote: > 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 -------------------
DTS was SQL 2000 and replaced with SSIS in 2005. In 2005-2008 you can import data as well. > 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. ------------------------------ www.red-gate.com SQL Tool belt will help you out a lot. Not free and very costly, but the problems you site are all dealt with in the tool set. > 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. ----------------- Don't make changes then. -- Stephen Russell 901.246-0159 cell -- 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
