Chris Harshman (11/22/2016)

---

If you grant the user privileges at the schema level instead of the database level, then they could create and alter procedures at will, but not be allowed...

GilaMonster (11/21/2016)

---

You can create a DDL trigger to roll back the DROP PROCEDURE, but if the user has CREATE & DROP permissions on the database, they'll be able to drop...

From what you have written I guess you job is trying to access backup file to restore it to another database.

Can you check whether the jobs are failing when restore...

MinhL7 (11/14/2016)

---

This is the error when I try to install SQL Server 2014. How do you fix it?

The application has failed to start because its side-by-side configuration is incorrect. Please...

Eirikur Eiriksson (11/7/2016)

---

Rechana Rajan (11/7/2016)

---

Eirikur Eiriksson (11/7/2016)

---

Rechana Rajan (11/7/2016)

---

We have two node cluster with 3-2014 Standard edition OLTP instances and 1-2012 Enterprise analysis server instance.

Earlier the server had evalution edition...

Check for any other error in errorlog.

Eirikur Eiriksson (11/7/2016)

---

Rechana Rajan (11/7/2016)

---

We have two node cluster with 3-2014 Standard edition OLTP instances and 1-2012 Enterprise analysis server instance.

Earlier the server had evalution edition and because of that...

Sue_H (10/31/2016)

---

Rechana Rajan (10/31/2016)

---

Thanks Sue.

Can i delete those procedures? Its creation date is showing 1 year...

Ed Wagner (10/31/2016)

---

Thom A (10/31/2016)

---

Rechana Rajan (10/31/2016)

---

Thanks Sue.

Can i delete those procedures? Its creation date is...

Thanks Sue.

Can i delete those procedures? Its creation date is showing 1 year old.

Can anyone help me on this Please

Ed Wagner (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

Ed Wagner (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

We are creating a data archive plan for one oof our big table which have more than 8...

TheSQLGuru (10/23/2016)

---

Note that if you decide to shrink the main database after pruning data that evolution will cause EXTREME FRAGMENTATION of all your objects!!! You will need to leave free...

Eirikur Eiriksson (10/23/2016)

---

Ed Wagner (10/23/2016)

---

Eirikur Eiriksson (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

We are creating a data archive plan for one oof our big table which have more than 8 million records in jusst...

Eirikur Eiriksson (10/23/2016)

---

Rechana Rajan (10/23/2016)

---

We are creating a data archive plan for one oof our big table which have more than 8 million records in jusst 8 months ....