CREATE TABLE #WHO (

  SPID  INT,

  Status  VARCHAR(30),

  Login  VARCHAR(50),

  HostName        VARCHAR(30),

  BlkBy  VARCHAR(5),

  DBName  VARCHAR(30),

  Command  VARCHAR(16),

  CPUTime  INT,

  DiskIO  INT,

  LastBatch VARCHAR(14),

  ProgramName VARCHAR(30),

  SPID2  INT

)

 INSERT INTO #WHO

 EXECUTE sp_who2

I agree. It depends on what you mean by 'direct' access.

I can read all of the entries in the 'authors' table of the 'pubs' database without querying the table directly....

You will probably have noticed that this is NOT a direct cut and paste from BOL.

BOL states "pubs.dbo.authors" whilst the question states only "authors".

I got the question "wrong" because I,...

According to microsoft support:

This command is intended to be a diagnostic tool for Microsoft Product Support Services. The format of the output and the level of detail that is provided...

Taking just the columns then and ignoring any indices or null masks, using bit switches would use 5 bytes per row. Four for the Int and one for all the...

Since space is an issue, why are the columns marked as nullable? It seems that if space is so restrictive that you have to...

Sorry Philippe, but you are incorrect. There used to be a difference in versions pre SQL 7.0 but now they both do the same thing. Neither options will write to...

Probably just another incident of Microsoft deciding that that was what you really wanted.

As I said earlier, DATALENGTH gives the number of bytes used. Be carefulll with nVarChar fields though.

StefanJ, If you get 5 then you didn't type it in correctly. There are four blanks in total, two at the start and two at the end.

SET @myString = 'bbTESTbb'

This is supposed to be question of the day for 24 May. If you want to raise a new topic then you should do that.

To answer your question though, you...

That was quite a straightforward question but can anyone tell me the difference between USER, USER_NAME(), CURRENT_USER and SESSION_USER? which all seem to return the same thing.

How about SUSER_SNAME() and...

I also only have sql 7.0. The error logging in this version is practically useless for large DTS's as it only uses the internal names for each step and not...

Unfair! For those of us who are (still) on SQL 7, the setting is on the Advanced tab of the Current Connection Options form.

Took...

Furthermore, you can use the results from your cursor to build up a SQL string and then execute the string dynamically. This is highly flexible but has the downside that...