Oooops.... Pretty Long thread (was almost lost :-))...

Few recommendations:

•Extra indexes are not always bad. And they are not burden on server also. For Example DW schema, you may have N...

Did you read the article I suggested to you? Nevermind. Please have a look...

Good. What's the frequency of Log Backups? When...

In fact Thanks to you. You gave me a good subject to study upon. Please count me in 😉 for R&Ds, if you...

USE AdventureWorks2008R2 ;

CREATE USER CustomApp WITHOUT LOGIN ;

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

To remove a node from an existing SQL Server failover cluster

1.Insert the SQL Server installation media. From the root folder, double-click setup.exe. To install from a network share, navigate...

OR

CREATE USER user_name

[ {...

I investigated further and here is something that might help you.

The service master key is automatically generated the first time it is needed to encrypt a linked server password, credential,...

I checked the article RESTORE SERVICE MASTER KEY (Transact-SQL) nothing much their except FORCE option which can lead to data loss.

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

I went through the document Windows Data Protection (quick...

winston Smith (11/15/2011)

---

Dev (11/15/2011)

---

The Service Master Key is the root of the SQL Server encryption hierarchy. It is generated automatically the first time it is needed to encrypt...

It worked for you but it’s not recommended (could be very risky). In worst scenario it could lead you to system crash as well.

faroz2003 (11/14/2011)

---

Hi Dev,

Thanks for reply this query

Select A.*,B.*

from A Full Outer Join B

on A.Id=B.id

where A.Id is null

or b.id is null

My tables doesn't have column call "id" then...

A possible reason could be SQL Server Login's Default Database setting. If you don't specify any database name in connection string it will jump to Login’s default. Connection's DB Name...

It’s time for Development basics... 😉

Three-Tiered Distribution

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

The MSDN article doesn't say anything about privileges. Basically what you need is...