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"

Is this native SQL Server backup, or a third party backup?

Is it local, or to a remote drive or share?

http://msdn.microsoft.com/en-us/library/ms189315.aspx

You should be able to see the linked servers listed in Management Studio for all instances. As for searching across them all, you have to connect to each and then...

It's a little hard to understand what is wrong since you haven't formatted things well. Do you mean that if you run this:

raiserror 22004 'This is a test'

You get...

An update statement doesn't have a select. It should be like:

update a

set a.column = a.column + 1

from Table1 a

inner join table2 b

...