Or you could have a job that goes through a list of databases and does what you want.

cab u post tables structure and some sample data.

Have to agree with David and Grant. Scripting is the way to go. This is the way i do it

DevDb -> TestDb -> StagingDB -> Production db.

I have been surprised...

oops... Nice question sergiy. I was surprised with the number of incorrect answers myself included.:)

i dont think having SQL 2000 will create any problem... iam not sure though... keep us posted.

unless you have profiler running a trace or you have a trigger which stores audit data like "who did what" in a table, it may not be possible.

Hi

Check the collation of your server and database.

the maximum size of a row of a table is 8060 bytes. Its not dependent on server specs.

Ooops i meant rights on that particular procedure if they have been set that way. Seems like we are...

Any change in User rights of the user connecting to server.

How much data is there in your tables and how much more data will be there in the tables in the future.

Ng Kean Tuck (8/27/2008)

---

yes, it was refreshed also. if it wasn't there, i might not be able to script it right? and it only happened to 1 sp... (as far...

Update employee set Passportcode = Passport.Passportcode

From PassPort WHERE Employee.employeeId = PassPort .PassportId.

I suggest you look into BOL and try it out yourself. then if you have doubts ask here....

yes you have to set the correct settings in the application.

what type of value are you trying to insert.

Hi

If you really want a instance with a specifc instance name you will either have rename the instance as mentioned in the earlier post or install one more instance.

Is ...