Well in this case , you can opt for SIMPLE recover model and take log backup on 15 min interval.

Sa is administrator, is has rights of everything. Some companies disable the "sa" account and let users handles everything with windows auth. So windows auth can be restricted to...

Thanks to all 🙂

can you update the SP ?

IF we think aboout security and unauthrized restriction then "windows authentication" would be better.

If this is the case then 🙂

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

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

joshanil (7/19/2010)

---

hi guys i am new in this forum i need your help

my db is full recovery mode

recently i take a full backup but don't have any log backup

after half...

Post some sample data along with your query.

Have you stopped it earlier intentionally or is it a newliy built server.

sqlbuddy123 (7/15/2010)

---

PK by default creates a unique clustered index if one doesn't already exists.

If a clusterd index already exists, you can specify NON CLUSTERED clause to create a noon...

What actually do you want to retrieve as information ?

may be this link can help you http://support.microsoft.com/kb/907877

Yes you can create

ALTER TABLE dbo.RFP_NSO_SEND_QUEUE ADD CONSTRAINT

PK_RFP_NSO_SEND_QUEUE_rfp_nso_send_queue_stub PRIMARY KEY NONCLUSTERED

(

rfp_nso_send_queue_stub

) WITH( FILLFACTOR = 75, PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,

ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS...

Good question , i took some minutes to understand this

google it as i did

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

yes it is possible