check out the ISO8601 style of the convert function. This will give you everything in an internationally recognised textual format.

 select convert(varchar,getdate(),126)

= 2005-01-19T08:35:05.507

That's the format I prefer.

I spent the last 4 years thinking about database change management and DB Ghost is what I've come up with. It works for both large and small environments and because...

This is the way I would do it:

I would use my source control and allow developers access to the functions and stored procedure projects only. Then I would build the contents...

Utilize your source control to store your DDL statements which are changed - then you have a complete audit trail. This is the best method I know - our software...

Check out DB Ghost (http://www.dbghost.com) for a complete solution to database versioning and change control. An article was published on this web-site about the methodology used which recieved rave...

check out http://www.dbghost.com for a process to follow that can a long way to satisfy any auditing requirements.

check out DB Ghost for a solution to database change management. For an excellent read check out this http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf

regards,

Mark Baekdal

http://www.dbghost.com

+44 (0)208 241...

The information can help "Voi Coi" if he chooses to use it. No information definetly doesn't. I totally believe the application can have a positive effect here as I have...

Hello Frank.

The tool is not for free, I can't afford for it to be. This is my full-time job so as my wife and children cannot live on air -...

What you are about to do can have very serious implications as you may be breaking your database without knowing it (which is why sp_rename posts...

What I do when changes occur is to build the database from the source code. This means if there are any procedures that may reference the table using select *...

First of all I would like to say congratulations to the winners.

I must admit though that I find it strange that products that are less than complete and have...

you can download the data and schema scripter which comes as part of the download for DB Ghost. It does schema and data scripting.

check out http://www.dbghost.com

check out http://www.dbghost.com which gives out a free schema and data scripting tool as part of the evaluation of the product.

Check out http://www.dbghost.com - it is the tool as talked about in Darrens article.