you have to first drop the dependent object related to that, find the indexes, constraints on that column and the delete those first and then that column.

Thanks jeff

jeff can u tell us what is SARGable WHERE clause??

hi,

you can achieve this through pivot here is an example of that

USE AdventureWorks

GO

SELECT [CA], [AZ], [TX]

FROM

(

SELECT sp.StateProvinceCode

FROM Person.Address a

INNER JOIN Person.StateProvince sp

ON a.StateProvinceID = sp.StateProvinceID

) p

PIVOT

(

COUNT (StateProvinceCode)

FOR StateProvinceCode

IN ([CA],...

hi,

if you use

USE TestDB

GO

there is no need to select any databases from the Database list the query is going to execute under TestDB only

sorry to say what you mean by currupted here??

is it not used, or in query its going as scan??

can you elaborate the scenario in some broad manner?

you can have transaction inside a trigger,

http://msdn.microsoft.com/en-us/library/ms187844.aspx

its a homework.

all the object associated with that will be dropped, like if you dropping a table the associated constraints, indexes, triggers,columns everything will dropped as it is higher body from those.

>> To do this I ended up writing a query with 6 joins for copying only. The data I am trying to copy is almost 1 million records<<

would you mind...

i think this is not the right place to ask this question, any hows if you google it you will find lots of sites for that.

@dev: what is the use of doing that, is this means DB tiring?

as i m seeing, its a pretty straight forward simple design, you can have tables like Equipments,Customers,HireEquipements, DamagedEquipments etc etc. and you have to set some business rules,

i will suggest...

Hi,

You can try SSMS its a free tool for sql server which will generate scripts for you.

same topic discussion is there in another thread of SSC just have a look on it.

http://www.sqlservercentral.com/Forums/Topic1146957-392-1.aspx