Ed

If the new owner isn't your username or dbo then you need to qualify the object name with its new owner.

SELECT * FROM newowner.MyTable

John

Probably the best way is to insert the result set of sp_helprotect @username='olduser' into a temp table and use that to build a script to grant or deny permissions as...

Ankur

I'm guessing you're looking at the result in grid format?  That will always be displayed on one row.  Try using Text format and see if that makes a difference.

If you...

This takes advantage of the fact that when you perform an operation involving two integers, the result is also an integer

UPDATE MyTable

SET IID = (ID - 1)/3 +...

The easiest way is to create roles and assign permissions to them.  Then, all users that need the same permissions can be made members of the same role(s).

John

Adam

No.  Books Online tells us that for the SELECT statement, the select list is as follows:

< select_list > ::=

    {    *

        | { table_name | view_name | table_alias }.*

        |     {...

DELETE FROM MyTable

WHERE col1 BETWEEN @a AND @b-2

AND col2 BETWEEN @c AND @d

Read about BETWEEN in Books Online before you use this so that you understand how it...

Ankur

Try this:

SELECT REPLACE ('I Love India', ' ', CHAR(13) + CHAR(10))

John

Tony

Check out GETDATE(), DATEDIFF and CAST in Books Online.

John

Adam

You can create a table with the same columns as the output of the stored procedure, then insert the results into it like this:

INSERT INTO MyTable ( <column...

Fredrik

NT AUTHORITY\SYSTEM only has access to the local computer.  You should start the SQL Server Agent service with a domain account that has permissions on the share you want to...

Arun

Double-click on the SQL Server resource in Cluster Administrator and go the Dependencies tab.  Add as a dependency every disk resource on which SQL Server data or log files reside.

John

Mike

Have you done any performance monitoring to find out what the bottleneck is on your current server?  You could save thousands if it turns out that all you need to...

You need to run comclust.exe, which configures MSDTC on a cluster server.

John

That all depends on how much the database is used.  If, for example, you're running queries that return large result sets then you may be filling up the buffer cache,...