Kelsey Thornton (3/1/2012)

---

I don't dispute there are many reasons why this might be desirable, or even required.

My point was simply that a little background information into why the port number...

Assuming these are direct attached (local disk or SAN), then to SQL Server, a drive is a drive. There is no effect on SQL Server of two equivalent drives. If...

I'm not sure about this. My reading of the license docs, which are vague to be sure, is that anything...

Incorrect leap of logic. The swipe card is not the device. The...

OCTom (3/1/2012)

---

As I approach my golden years I know that what Steve discusses is important but impossible. Whenever one part of life takes up more time another part must give...

Good points, Gus, though I'm not sure I'd say most kids can't figure those things out. At least I hope that's not the case. Some days I wonder as well.

I...

Thanks for the update, and an interesting solution. Some things in there we should have added to the SQL Saturday site.

I think the spike is temporary, and as I mentioned, it's about perceptions. Right now the cloud gets a lot of press, which means to managers, it seems "hot", so...

changing the path

http://geekswithblogs.net/renso/archive/2009/10/21/how-to-set-the-windows-path-in-windows-7.aspx

You can rename the file, you can change your path variable, or you can click the icon in the menu.

This is a basic Windows function, not a SQL Server one....

satishm123,

We are happy to help, but your post doesn't indicate any research, nor does it ask pointed questions. If you don't understand something you researched, then post a specific question...

For the install, double click setup.

There should be a group for the service account. Go into the Computer Management, Users and Groups, and Groups. The group for the SQL Server database engine service should be...

Are all three procs owned by the same person? If so, you get an ownership chain there.

Try this, Joe is a normal user, not roles/rights assigned.

-- As DB_Owner

CREATE PROCEDURE dbo.spRefresh

AS

BEGIN

...

It's legal, but I agree with Recurs1on that it's confusing and not clear.

I don't use DELETE FROM (or INSERT INTO), but rather the

DELETE t

from xxxx t

...