had a little tinker with this one...

ran script in 2005 to confirm that the question was correct for 2005.

Then ran the following

Create Table Test(col varchar(10))

GO

Insert into Test

Select 1

union Select 2

union...

this question is flawed...

if the SET READ_COMMITTED_SNAPSHOT is set to on for the database you are using then the query will return 1 and 2...

I'm being picky here I...

Ok so it's configuration manager.

sac doesn't ship with 2008 that I know of... What happens to the command line tool?

William Vach (1/9/2009)

---

I don't believe that you can move the mssqlsystemresource (resource) database. See the portion of the following article regarding moving the resource database: http://msdn.microsoft.com/en-us/library/ms345408.aspx%5B/quote%5D

looks like that...

hmmm... just going slightly off piste here but that mssqlsystemresource db has been a constant source of irritation for me... especially where the log and mdb have been installed on...

why oh why did I think this was a trick question?:)

Of course .ldf is a sql server file extension... but is .ldf really a "sql server database" file extension. My...

I guess that I have to concede that the question has been correctly posed.

Nevertheless, it is tempting to think that functions should act in "isolation", and it kind of...

http://en.wikipedia.org/wiki/Random_number_generator

given that there is still considerable debate as to the "True Randomness" of computer generated random number algorithms it would be reasonable to assume that there are definitions...

Am in there with the nay-sayers... For a single connection... RANd() behaves deterministically if following a seeded definition. Give us our points!

cute point about vardecimal... thought about using it, but it doesn't ship with express or standard editions... shame!

Wouldn't want the poor dears confusing "IT guy" with "it girl" would we? One is reputed to be "unattractive, and antisocial, but blessed with a brain the size of a...

sorry looks to me that Jeff has just made the point I'm trying to make. Thanks to all!

I kind of agree with what you are saying about decimal vs float for financial data... Actual financial data is stored seperately using the appropriate datatype. This table is used...

I think you could say the same about just about any career. Doesn't stop it from being true. Sensible stuff!