Asan FYI, the steps outlined above worked fine...stopping my regualr dev server and the new express server, renaming the dev msdb mdf and ldf files, and then replacing with the...

it returns this:

logicalFilenametotalMBusedMBfreeMBfree_percenttype

MSDBData4237.437500004237.437500000.000000000.00000000000000000Data

i've found some other links where they cannot explain the bloat, but the solution was to isntall an express version, stop tehs erver, adn swap out the new...

ok that returned this info for that database:

Database Name Log Size (MB) Log Space Used (%)

msdb 0.4921875 81.74603

so...

oh and i did do my due diligence before posting; i googled and went thru all the steps found here:

http://www.mssqltips.com/tip.asp?tip=1461

but with results like 135 rows of data, nothing there jumped...

Florian thanks for your function;

one format, the ISO one, is really handy for me, as I have to do a lot of that conversions;

ISO8601 (XML) ...

florian i named it with sp_ on purpose in this case, and then placed it in the master database; that way i can call it from any database i happen...

by data mmodel you mean a diagram, where all the tables are shown with likes representing foreign keys?

if you have the database, the schema is wide open for you to...

ok my google-fu is strong tonight;

SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --<<SQL Date to Epoch Date

SELECT DATEADD(s, 1239156328, '1970-01-01 00:00:00') --<<Epoch Date to SQL Date

found that over at http://www.epochconverter.com/%5B/url%5D

im...

duh...format 121 does exactly what you need, sorry i misread:

FormattedDate Code...

just use a combination of two built in CONVERT formats:

SELECT CONVERT(VARCHAR,@date,112) + ' ' + CONVERT(VARCHAR,@date,114)

--results: 20090407 20:58:00:280

nuts with over 100 posts, you know you should post the schema and data in a format everyone can use to help!

a wag of my finger at you!

CREATE TABLE...

i typically use this cursor to do the same thing...besides autoclose, i don't need to have the recovery at FULL on my developer machine:

USE MASTER

declare

@isql varchar(2000),

@dbname varchar(64)

declare c1 cursor for...

something like

SELECT * From YOURTABLE

WHERE FIELDNAME LIKE '%' + CHAR(10) + CHAR(13)+ '%'--vbCrLf

how about his:

exec sp_MSForEachdb 'SELECT ''?'' as DBName, ?.dbo.sysobjects.name AS TableName from ?.dbo.sysobjects WHERE ?.dbo.sysobjects.xtype=''U'''

I've got an upcoming article on how to do this in TSQL, with a complete solution:

all objects in dependancy order, along with the data.

while you are waiting for the article...