Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script don't work

Status
Not open for further replies.
graabein

graabein

Programmer
Oct 9, 2002
186
NO
Hi, I'm working on several SQL Server 2000 databases and I want to copy my changes from one test database to another.

I have generated one SQL script that copies every table and stored procedure and when I run it in query analyzer it says command executed successfully, but when I look at the database where I ran it, the new tables and procedures are not there!

What am I doing wrong?

[elephant2]
graabein
 
Sort by date Sort by votes
Well, you are posting in the wrong forum. This should be in a SQL server forum.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
207
carp
carp
Tetol
  • Locked
  • Question
Update script is changing the number of records for the values updated each time I run the query
Replies
1
Views
184
carp
carp
aleceiffel
  • Locked
  • Question
Select only rows that don't have duplicates in certain fields
Replies
2
Views
100
PHV
PHV
simsen
  • Locked
  • Question
select distinct don't work as I thoght
Replies
4
Views
58
simsen
simsen
PaulVR
  • Locked
  • Question
Rows to columns: finding a workable solution
Replies
0
Views
76
PaulVR
PaulVR

Part and Inventory Search

Sponsor

Back
Top