Thanks for the thought and link Andy. I did resolve this problem. I got the answer at PASS at the PSS/MVP session. Actuall none of the PSS...

See other my example here:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17947&FORUM_ID=23&CAT_ID=2&Forum_Title=General&Topic_Title=Runnig+total

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Will something like this work for you.

create table run(id int identity, num int)

insert into run (num) values(10)

insert into run (num) values(20)

insert into run (num) values(30)

insert into run (num) values(40)

insert into...

Interesting thought. Hummm..........

Right now we don't allow anyone to send mail to SQL Server.

It has been a long time since I played with xp_readmail and sending email...

Here is a way to do that by creating a pivot table query, no cursors here.

set nocount on

create table pivot_records ([Order] int,

...

That is kind of what I thought. Thank you for the feedback.

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

Need SQL...

You can use the WSCRIPT SHELL object to do asynchronous processing of SP's. Here is a simple example to demonstrate what I am talking about. This example creates a sp,...

You might try turning on Audit Level logging to ALL, and then reviewing 60 days worth of SQL Server logs to determine the logins that have logged in, then this...

Not exactly sure what you are saying here "I think you want to change the service account, remove admin permissions, then change back using EM, which should reset all permissions...

I agree it would be nice to transfer the default database. As the script comes from Microsoft it does not set the default database, and that is what I...

When you transfer master all the logins will come across so you would not have to run this script. This script is used to copy logins and passwords without...

I would suggest that you hash the passwords and then store them in you database. This will keep anyone even the SA from knowing the password. Now if...

Funny you should ask. Turns out the biggest table, and the one I was working with did not have a clustered index. From my testing it seems when...

As promised I said I would give a little recap of regarding resolving my used space verses unused space.

Now first let me say I'd like to thank both Jonathan and...

Might try something like:

declare @test-2 as varchar(25)

set @test-2 = 'sys'

set @test-2 = '%' + @test-2 + '%'

SELECT * from sysobjects where name like @test-2

-- or

set @test-2 = 'sys'

SELECT * from...