Yes, it can be used for commercial purposes... many well known products (e.g. Backup Exec) have used the free version of SQL Server for a long time.

ricky.chauvin (10/28/2009)

---

Cheers I'll look at that correctly once I've finished fixing the data that everyone has entered wrong...

Thank god im young and healthy otherwise my blood pressure might be a...

You can take the database offline as follows:-

ALTER DATABASE [dbname] SET OFFLINE

Try something along these lines:-

create table test (err int)

go

insert test select 0

insert test select 0

insert test select 333

insert test select 212

insert test select 22

select sum(case err when 0 then...

Gail Shaw has written a fine article on this sort of query, which addresses just the sort of issues you are seeing.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

If it's a function, then you explicitly declare the return type anyway.

If it's a stored procedure, then you could always...

You don't have to do a full restore to revert things back to the way they were...

If you use the system stored procedures sp_change_primary_role and sp_change_secondary_role to switch the roles...

There's nothing different about moving tempdb in a cluster (other than making sure the same drive letter is mapped on all nodes).

Failing over will cause it to move, but.... you...

You will be getting NULL if any one of the columns you are concatenating is NULL.

If this is what you are trying to avoid, put SET CONCAT_NULL_YIELDS_NULL OFF before you...

My pleasure, Mr Fox;-)

BOL is your friend... look here

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

They are 2 completely different things, which is why I asked what you were...

That is one thing I haven't heard Microsoft being accused of!!

Have you checked UPDLOCK in Books...

First a question... why is this urgent?

Second.. What are you trying to do... What makes you think Mirroring and/or Clustering are something you might want to use?

From your questions, I'm...

Have a look in SSMS at the Default Language for the Windows Login that is actually executing the BCP... I'd hazzard a guess that one of them is "English" and...