As has been said earlier in the thread, usage of the DBs will set the practical limits. Another limit that might affect some is that Enterprise Manager will not...

Just keep adding them. As soon as one WHEN-test evaluates to true that tests THEN part will be assigned to the receiving variable or as in this case a column...

Shawn, Frank is absolutely correct in saying that all the columns of a row are always stored together, whether or not the table is a heap and has any non-clustered...

Can you alias the results so..

select case 1 when in (1, 2) then 'a' else 'b' end AS myAlias ?

Yes, the result is a column in a resultset and works...

It tells you the average time that any process had to wait for latches. Latches are short-term syncronization objects. Note that it only includes those times when a process actually...

An interesting thing to note is that this is solved in SQL Server 2005, using a new allocation unit called overflow data. See more in my blog entry http://www.hedgate.net/blog/2005/04/10/support-for-large-rows/

Yes, you can manage SQL Server 7 instances with Enterprise Manager 8.0.

I would definitely want to see some proof on that. It seems to me that he was talking about forward-pointers, which are used for heap tables when a row is...

>You should see this piece of p00 report writing tool that im lumbered with.

Well then you have got some work to do ahead of you. In the same way as...

Which version of VS2005 do you have? The project type "SQL Server Project" is only available in Professional Edition and above. It's located in the Database project folder under Vsiual...

Good luck then.

Seriously though, constructing RTF by hand is a nightmare. I would definately suggest implementing a client that pulls the text...

You should really consider doing this kind of presentation logic in the client. But anyway, you can of course include formatting in the output. But how to do it depends...

I've been thinking about the features for a perfect discussion forum recently. One of them would be an FAQ that is shown on the Create New Thread page, containing questions...

I do not think you can create a role for giving rights to DBCC DETACHDB. Since there is no permissions check in sp_detach_db I assume it is a hardcoded check...

>It worked OK, but the numbering appears totally random.

What you are using is a strange feature of SQL Server, where it increments a variable once per row even though it...