PS. there is a report that you can run that will also show what schema changes have been made against your database but it will only show you the information...

if your looking for schema changes then you can create a DDL trigger on the database thats what i use to audit SP, Table, Trigger and index creations amendments etc

Try this

create proc somename

(@paramname int

)

as

begin

select what ever

from some table

where id=@paramname

end

I sure you get the jist:w00t:

Inner join your table on its self on booking_ID next select the columns you want from table a and then concatenate a+b like so

select A.BOOKING_ID , ...

if your using SQL2008 then you need to set your database to SIMPLE mode

here is what i use to clear all my transaction logs on my test servers, bear...

define complicated, what i may think is complicated other may think simple download adventure works database and have a look in there

are those values you added the actual string? can you provide some example DDL ?

As already mentioned it would be better to run this in batches however, is your database used on an evening? are there any downtime periods of the application as to...

Exellent Marvelouse "Excrament Marvaloid"

sounds to me like its an automated SQL job or maintenance plan have you tried to look at the current sql jobs and maintenance plans

Bring your results into an CTE also add row_number() to your select and then select from cte where row_number =1 like for example

;with duplicates (rn,one,two,three)

As

(select row_number() over(partition by one,two,three...

:ermm: from what a read as i understand you then you only need to replace * with ID sorry if im misunderstanding you but looking at your tables am not...

PS i also have several version of each script but i name and version control them accordingly like company,customer,scriptname,version

Like you i use a system of folders that a split in to categories, Performance, indexing etc

Hi yup your thread is interesting, assuming that in your table all the varchar values are in order as per your DDL then you could just inner join the table...