there was just someone else a day or two ago that got gmail to work; it trick was a weird port for secure connection,

here's the link:

http://www.sqlservercentral.com/Forums/Topic545821-146-1.aspx

nothing exists automatically for this; you'll have to start a serverside trace, let it run for a while, and use the trace results to do your statistics;

you can get a...

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