That I am not sure of... However, I don't remember having a problem with it when I did it. Can you set up a test server for this?

Jared

Try this: GRANT VIEW DEFINITION TO LoginName

Jared

Perry Whittle (10/22/2011)

---

mvillar (10/22/2011)

---

hi everyone!!!where all databases and servers have Admin Domain users like almighty Sysadmins!, i like to close all of then, to make access restricted.... there is a...

We simply deny access and login rights on the status tab of the database login profile. This is for DOMAIN\Administrator login.

Jared

If it is all on the same server you should not have too many issues. Converting your reports may be the only thing that poses an issue, but I...

Evil Kraig F (10/25/2011)

---

jared-709193 (10/25/2011)

---

And then if you cannot prive it is a SAN problem, how do you prove it is...

Ahh yes... PEBCAC and a ID-10T error 🙂

Jared

And then if you cannot prive it is a SAN problem, how do you prove it is an SQL problem? 🙂

Thanks,

Jared

Evil Kraig F (10/25/2011)

---

john-671083 (10/22/2011)

---

I wrote an Invoicing application. It is written in Visual Studio 2008 and the data is stored in SQL Server 2008. This application has been running...

I'm sorry, maybe you misunderstand. Can you connect to the database using SQL Server Management Studio. I understand that the application cannot connect to the database, but can...

Evil Kraig F (10/25/2011)

---

jared-709193 (10/25/2011)

---

In my script I actually create the staging tables within the script on the partition schema. First I drop all non-clustered indexes, create staging tables on...

Evil Kraig F (10/25/2011)

---

You're not, and you're being very vague with your responses:

Also, you mention 10 partitions, and when asked for a...

I think I get it now. More of a round robin type thing. I just don't understand how the data is getting inserted. i.e. How do you...

How does it know what to partition on? A Date (i.e. month), a number that is inserted into the table (i.e. 1,2,3,4,5,6,7,8,9,10)? It looks like a number, but I...

WardyWonderland (10/25/2011)

---

Many thanks guys.

I have started reading the article and...