GSquared pointed me in the right direction.

trustworthy was required, and i tweaked my version of the script until it works.

I created two new sql login users, "bob" and "jeff" with...

i think th etrick is to simply use integer division to get the mod = 0

here's how to do it with a tally table:

select N from master.dbo.Tally

where n = 1...

here's my version, where i figured i'd find and replace from an existing set of commands i know works fine:

i greated a login named 'bob' with connect priviledges. this created...

don't you have to add a USE DATABASENAME command before you add the user, otherwise it would just re-add the user to the existing connected database?

there you go then, no worries.

about the only thing i could suggest is a lot of people here recommend creating a list of commands in a varchar(max) string and then...

since HTML is text, i would have used a varchar(max) column instead of varbinary(max)

you can convert to NVarchar(max) to see the contents.

select CAST(YourVarbinaryColumn as nvarchar(MAX)) From YourTable

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