Can you post a screen shot of the page?

sqlfriends (6/12/2012)

---

If I have a login (a single windows user) that is a dbowner of a database, but the login is also in a group that only has db reader...

To provide you with the best help possible we really need more information. Please read and follow the instructions in the first article I reference below in my signature...

Brandie Tarvin (6/12/2012)

---

Lynn Pettis (6/12/2012)

---

toddasd (6/7/2012)

---

Anyone here move to a standing workstation or give it a try? It's supposed to be much healthier for blood flow and muscle use (as...

Sean Lange (6/12/2012)

---

Lynn has a great blog post with lots of common datetime routines. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

See if that helps.

I am willing to help but since this sounds like homework the best...

I can't see a reason for a separate instance for SSIS, but I could see having a separate system for running SSIS packages (not the same thing in my opinion).

toddasd (6/7/2012)

---

Anyone here move to a standing workstation or give it a try? It's supposed to be much healthier for blood flow and muscle use (as Brandie states.) It's...

sonia.burns (6/12/2012)

---

Thanks Lynne, I am just restoring last nights logs to the mirror and then I will probably delete the endpoints and start again (3rd time lucky maybe), I will...

Why would I use a script component when I can define each column of...

Have you done this:

GRANT CONNECT ON ENDPOINT::endpoint_name

TO < domainaccount >

where enpoint_name is the mirror endpoint and domainaccount is the account that owns...

And SQL Server Business Intelligence Development Studio is pretty broad....

TrippBlunschi (6/12/2012)

---

EDIT: Topic should have been Eliminating rows WITHOUT a change.

I have the following table...

DECLARE @test-2 TABLE

(

Id INT NOT NULL,

ModifiedDate DateTime NOT NULL,

Status INT NOT NULL

)

INSERT INTO @test-2 VALUES...

sonia.burns (6/11/2012)

---

I apologize if this does exist somewhere, I did look....... honest and didn't find an answer. It seem as though a lot of people have this problem but I...

Jai-SQL DBA (6/12/2012)

---

1.Which Rebuilding of index takes time

Clustered Or Non Clustered --And WHY ?

2.When SQL SERVER Backup is Taken ,how to Check that the Back up Done is fine ..

(Without...

george sibbald (6/11/2012)

---

when logshipping the only backups of the log must be done via the logshipping jobs.

You will have to remove the 10 min log backups outside of logshipping and...