All I did was confirm your code is essentially the same on my SQL2005/1Gig ram 2.8 machine.

My first guess was because you were using a @table variable for your Tally...

Extract, transform, load - Wikipedia, the free encyclopedia

basically getting data from one source and bringing it into anohter , realtime would be as it happens or changes.

i think you are after this command, which allows you to see structure of tables(but not hte data), as well as the text of procs and views, right?

GRANT VIEW DEFINITION...

you'll want to simply Add these commands to the top:

SET STATISTICS IO ON

SET STATISTICS TIME ON

--SET SHOWPLAN_TEXT ON

then run your two queries together....actually run them a couple of times...

the query i posted...

ok i'm guessing your query got changed to make it less complex for the web...

but there seems to be a some steps tha seem weird to me.

if you yank out...

there was a similar thread on the issue, and even though the person had updated usage, updated statistics, the issue did not clear until they DROPPED their current statistics, then...

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