venoym (8/23/2011)

---

I thought it was a fine question.

I'm surprised by the number of people who are complaining about the existence of a Test2 db or not. I would...

Nice to be reminded of basic how things work ....

Using OPENROWSET for example:

SELECT * FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','Excel 8.0;DATABASE=c:\temp\items.xls;IMEX=1;HDR=No','SELECT * from

[items$1]')

Note the IMEX setting. If it is NOT present the open rowset reads the first 8 or so...

Tom you must have been accessing the QOD when I had...

Surprised at the numbers (3 out of 4 incorrect), for what is a rather simple question.

To follow up on Lowell's excellent code AND provided that you wanted the 2nd result set from sp_helplogins you could perform the following.

1. Using SSMS, script the code...

See if this gives you the information you seek.

sp_helplogins

For your information it is located in the Master database.

Nice question, and even better the first one to answer it correctly ... yea bragging ...... what the heck .....

This article on SSC should assist you

http://www.sqlservercentral.com/articles/Advanced+Querying/onthetrailoftheisoweek/1675/

Be sure to read the comments on the article

Remember:

The @@ERROR function can be used to capture the number of an error generated by the previous Transact-SQL statement. @@ERROR only returns error information immediately after the Transact-SQL statement that...

You may find the reason by reading this article by Gail Shaw:

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Start by reading:

http://msdn.microsoft.com/en-us/library/ms144245(v=sql.90).aspx

Or:

http://www.sqlservercentral.com/articles/Upgrade/65872/

The default time span for Microsoft SQL Server is 1950-2049, which represents a cutoff year of 2049. This means that SQL Server interprets a two-digit year of 49 as 2049,...

To offset the demise of a few GOOGLE apps, realize that:

Early in the formation of Google.org, Google took the value of 10% of the 3 million shares from Google's...

(And the code that splits the string into individual words I have posted is code written by Jeff Moden) that was edited by myself to use your sample data. ...