473,503 Members | 1,797 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

creating a back up [create and insert statement] for a table in mssql server 2005

2 New Member
hi all,
i have a php application connecting to mssql server 2005. i want to generate sql script for backing up a table with create statement and complete inserts. i dont want to use data publishing wizard. how can i do it.

Thanks
Sep 6 '07 #1
1 1095
ck9663
2,878 Recognized Expert Specialist
hi all,
i have a php application connecting to mssql server 2005. i want to generate sql script for backing up a table with create statement and complete inserts. i dont want to use data publishing wizard. how can i do it.

Thanks
or you can do a SELECT .... INTO NewTableName from MyTable...
Sep 6 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3763
by: Karsten | last post by:
Hi, I want to create dynamic reports with C# and MS SQL-Server 2005 Reporting Services. Since the reporting service uses a data-table or data-view, I want to create a view dynamically. How...
3
5162
by: AlaQunaibi | last post by:
Hi All, Can anyone help me to create ASpNet user in Sql server 2005?
0
1428
by: M | last post by:
TableAdapter Configuration Wizard do not create Insert Statement(It Creates SELECT, UPDATE, DELETE statements) So if I try using Myadapter.update(MydataTable) to add a new row. I get Error...
1
885
by: moncelh | last post by:
Please, how to create a table with SQL statement in SQL Server 2005 including an ID number for the first field as well as an incrementation? Thank you.
0
2939
by: aleu | last post by:
Hi, I was wondering whether any of you is monitoring MSSQL server 2005 (whatever information could be obtained) from a remote Linux server with the use of SNMP or WMI-perl scripts (for example...
0
1349
by: ruchika mahajan | last post by:
Hi all...MSSQL serevr 2000 Trace Event Column ObjectType gives value 17 for object table for events Object:Created and Object:deleted.Can anyone tell me all the possible values for MSSQL 2000 Trace...
0
3689
by: masterorb | last post by:
Hi, I am trying to open a connection between a PHP page and MSSQL Server 2005 (as opposed to MySQL). I found a tool online that seems to accomplish this: http://www.freetds.org/. However, I get...
6
7507
by: sangam56 | last post by:
C:\Documents and Settings\oOo\Desktop\Introducer Table.jpg Hi all. I have a table in sql 2005 management studio express edition. The table consists of three columns: IntroducerID, LeftCustomerID and...
1
2542
by: Gurpreet Singhh | last post by:
whats error in java statement to insert data into sql server 2005??? # String query = "insert into dbo.guru VALUES('"taskdata.getTaskid() +',' + taskdata.getTaskname()...
0
7199
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7076
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7274
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6984
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7453
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
5005
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3151
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1507
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
732
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.