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

...

John is correct here, the logging is the same.

Actually, the logs written are always the same, regardless of recovery model. What differs is how long the log records are retained,...

It completely depends on your path. I would guess 2012, but you'd have to test it.

http://www.amazon.com/Securing-SQL-Server-Protecting-Attackers/dp/1597496251/ref=sr_1_1?ie=UTF8&qid=1330464136&sr=8-1

Might watch out for this: http://blog.trivadis.com/b/nicolasmueggler/archive/2008/01/17/installing-sql-server-2005-after-visual-studio-2008.aspx

VS2008 has some SQL components in there to work with SQL Server instances, and those are rev'd after the SQL Server 2005 components.

If you right click SSMS in the menu and select properties, you will see the shortcut it refers to.

It is still "ssms.exe"