You can't specify a parameter with a dynamic name for the object to update. You would need to use dynamic sql. But what are you trying to accomplish here? There...

Just a guess, but is named pipes enabled on the server? Check in Surface Area Configuration utility.

Just surround the call to xp_cmdshell with time measurment, like this:

DECLARE @start DATETIME

SET @start = GETDATE()

EXEC master.dbo.xp_cmdshell 'command here'

PRINT DATEDIFF(ms, @start, GETDATE())

Vaibhav, these are difficult questions since there are many answers and different people will have different opinions. In any case though the answer is always "it depends".

And if it is the text of a procedure you are looking for you should take a look at syscomments. Or, better yet, use the system stored procedure sp_helptext to...

Just a guess, since I have not used that cd of course, but maybe the SQL Server 2005 Developer Edition is a separate installation? The Visual Studio 2005 installation installs...

I do not think it is possible to install the clients only, if that is what you are asking. Maybe with August CTP (if it ever gets here...) it will...

With proper indexing max() should be as fast as the following, which would otherwise be the fastest alternative:

SELECT TOP 1 column

FROM table

ORDER BY column DESC

Use a comma to specify the port, such as 123.123.123.123,2433. Or you could create an alias in Client Network Utility and register the server using that name.

There are no automatic audit logs in SQL Server. You can use Profiler to trace any activity you want and store as audit logs if you wish. In SQL Server...

I have no problem running June CTP right now. Are you sure that you do not have Beta 2? What output does SELECT @@version give you? Mine says this:

Microsoft SQL...

To be able to see the SQL Server 2005 instances on a machine you must have the SQL Server Browser enabled and started. Use either the Configuration Manager or Surface...

You won't relly come up with anything new by installing it. It is a great product, there is a lot of nice new features, and it is a beta so...

Ok, I have now checked what it says in Inside SQL Server 2000, and I do not make the same interpretation as you do. I cannot find anywhere where she...

But it is still not row-by-row, if by that it would mean "as opposed to being set based". You are talking about the physical implementation. In fact, take a look...