I thought we'd had that "issue" rectified. If this is not the case I can remove this. In my defense I did try and contact you, which I duly mentioned...

Quote taken from a study:

India, whose IT exports are more than triple the size of its domestic IT market, still has a piracy rate of 74 percent...

Interesting.

Companies that send all their work to be done off-shore ignore cultural differences between say India and developed countries where the evidence suggests it is acceptable to...

Get some database change management software. That way you can work with your source control in the way it was intended. Application code is usually held in source control why...

I do a full build from source at regular intervals using DB Ghost database builder (http://www.dbghost.com). This ensures no one has unwittingly broken the database due to changes.

select * from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='VIEW' and objectproperty(object_id('[' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']'),'IsSchemaBound')=1

regards,

Mark Baekdal

http://www.dbghost.com

http://www.innovartis.co.uk

+44...

I'd do it the other way around IE:

your way...

select *

into beta.work.dbo.Table_backup

from _all_props

my preference...

select *

into dbo.Table_backup

from SourceServer.SourceDatabase.DatabaseOwner._all_props

regards,

Mark Baekdal

http://www.dbghost.com

you may need to use a text datatype for the column to accomodate for large inputs.

regards,

Mark Baekdal

http://www.dbghost.com

http://www.innovartis.co.uk

+44...

we also do an application - DB Ghost - that creates schema and data change scripts with a twist - it works with your source control and the scripts always...

sp_rename is a procedure that I think should only be used for tables and the child objects of tables where the object doesn't have any entries in the syscomments table which...

take a look at this article:

http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

It's the foundation for the software components called DB Ghost (http://www.dbghost.com) a total database change management solution which promotes the idea...

question? Why don't you have a test platform where changes are made and tested then the changes are uploaded to your production system through reliable change management? It means this...

and what order would you call that?

If you can't mathematically explain an order you can't do it via a set method. The rules you perscribe aren't logical, they're probably a...

you may want to try the DB Ghost data and schema scripter, it's free and it has a COM interface so you can easily create a script to automate the...

DB Ghost has this functionality.

1. Script out the database to a temporary directory using DB Ghost data and schema scripter.

2. Using option 1 of DB Ghost, build a database using...