if any foreign keys exist between your tables,your sp_msforEachTable might fail...they have to be dropped in FK hierarchy order.

there's a lot of ways to get your tables in FK order,...

i left them out on purpose; the format of 0 = format of 100,1=101 etc; just duplicates of the same formats; I thought it's easier to just stick with the...

well guids are supposed to be unique; although the algorythm got a little weeker when they disconnected it from the MAC address of a NIC card for the seed, it's...

way to go!

i can't tell you how many times that same thing has happened to me here...start forming a question, and as I'm typing i think of a possible solution.

I've...

could it be that the SQL Service got stopped and is not running on your laptop now? go to control panel?Administrative Tools/Services, and make sure your SQLServer is running, then...

sp_MsForEachdb still uses a cursor behind the scenes;

using a cursor is not necessarily a bad thing...that's why they exist, because some things cannot be done without RBAR processing;

the issue with...

it started out life as SQL Express and then had SQL Express With Advanced Services re-installed over the top of it:

select @@version

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)...

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...