The %username% produces the following error if run through sql agent:

Login failed for user '%username%'.

But works if run through xp_cmdshell.

So basically I'm guessing no environment variables get replaced with there...

It returns the computer name on which the command runs. Why are you asking?

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here:...

No, not running this on a cluster.

Thanks for the solution, that would work, as well as the one provided by mccork.

Really I was wondering if anyone know why...

Wonder why starting a new shell makes a difference in a SQL Agent job?

Gregory A. Larsen, DBA

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

Need...

Here is an article I wrote that might give you another method of scripting login migrations:

http://www.sqlservercentral.com/columnists/glarsen/migratingloginstoanotherserver.asp

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy...

Think you want something like this:

create table t1(c1 int, c2 char(5), c3 char(5))

insert into t1 values(1, '0100T', '9999T')

insert into t1 values(2, '00000', '09999')

insert into t1 values(3, '10000', '69999')

select * from...

oops. found a bug, try this one:

----------------------------------------------------------------

-- Display average row size for each table in a database

-- Author: Greg Larsen Date: 12/18/2003

----------------------------------------------------------------

set nocount on

declare @old_tname varchar(100)

declare...

Sorry about that blank post. Ok took a stab at creating the Average Records Length query. I use the information in sp_spaceused to calculate the average. ...

quote:

---

I'm looking for a tool that would calculate the min, max and average row size of a table. This tool would...

More information about the book can be found here:

http://www.sqlservercentral.com/bestof/

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

When you do a point in time restore the database will be restored to that point in time. Now if you can identify the corrupted transaction and the data...

Now there is a bold suggestion. Would you consider deleting records manually for a system table as a "good practice" or one of those "bad practices".

My normal...

Might try something like this:

select substring(convert(char(30),getdate(),109),13,8) +

' ' + substring(convert(char(30),getdate(),109),25,2)

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a...

Some other options for doing what you want can be found my article posted here:

http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

Gregory A. Larsen, DBA

Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here:...

You might also look into using the "Batch Requests/sec" in smaster..sysperfinfo table

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