Alasdair Thomson (4/20/2010)

---

I don't believe so as I believe it only use's the 2003 rendering engine. Have you tried renaming the .xls output to the .xlsx?

Let me know...

Steve Jones

The TJX thing, that was interesting. In 2001 we were just starting to deploy wireless around the JD Edwards campus. .........So I wrote a short story about a former...

Please, please help those who want to help you by posting your problem following the second link in my signature block,for what will help you get a good answer

Without the table definition, some sample data, and your T-SQL statement (Refer to the first link in my signature block for the complete format, etc., to receive tested help) the...

Thanks for that info, alas I could not use it to support the answers, since it would not be avaiable...

dunnjoe (4/16/2010)

---

This was a good question, and makes me wonder if it is a good idea to have auto stats turned on.

When I ran it on one of my servers...

Why do you want to create them without all the...

Jason it's late go home. If I remember correctly it is Las Vegas where you work?

If so, stop at a few places along the strip, have a glass of...

Pray tell Jason, what is this seemling unquenchable thirst for SP_Who ....

whatcha going to do with it?

Heck Jason even this old timer does NOT save stuff that old.... Yikes

Here it is:

CREATE PROCEDURE sp_who2 --- 1995/11/03 10:16

@loginame sysname = NULL

as

set nocount on

declare

@retcode ...

This is, I am sure NOT the best way, but since CTEs

can not be used in SQL 2000 the best I could come up

with is a 3 step...

This may or may not be the proper place for this background material, but being a long winded individual given to exchanging tidbits technical information with others involved with SQL...

Hawkeye_DBA

SQL Express has a unique database setting, which I believe is new to sQL 2005 ... here is a link to check if this is your problem.

http://technet.microsoft.com/en-us/library/bb264564(SQL.90).aspx

From the above:

The sqlservr.exe...

Have you reviewed:

@@IDENTITY, SCOPE_IDENTITY, and IDENT_CURRENT are similar functions because they all return the last value inserted into the IDENTITY column of a table.

@@IDENTITY and SCOPE_IDENTITY return the last identity...