tony28 (4/28/2013)

---

opc.three (4/27/2013)

---

It has to do with how a...

Ok, that confirms that the person owns the database. Chances are they created the database initially since SQL Server will make the database creator the database owner and many people...

It has to do with how a plan is...

Agreed. If you reread...

I could not care less what Sergiy says about anything and do not need a translator of his thoughts. I actually think its odd that you continue to do that....

For a database that does not need point in time recovery, yes, I would recommend changing to Simple recovery mode.

Try to keep it professional Sergiy.

You forgot to supply a WHERE clause in the query that uses the VIEW. You need a predicate that folters on the column where your check constraint is:

SELECT * FROM...

That's not entirely accurate. You are right in that when in...

Tony414 (4/23/2013)

---

Hello,

First off I am new to this forum and don't know much about sql. I guess that's why I am here 🙂 I hope I am in the right...

Best I can tell from some basic testing on this side, changing the database owner does not require exclusive access to the database.

When you run the command, look at the...

A proper solution would be to get rid of the use of xp_cmdshell all together.

The recommended way using either a SQL Agent job or a web service that invokes...

ankur_libra (4/26/2013)

---

Hi All,

As per below link article:-

http://support.microsoft.com/kb/970070

Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems was made available from

"Cumulative update package 4 for SQL Server 2005 Service...

It might be the UI design causing confusion, or being plain wrong.

What does this say?

USE YourDatabaseName;

GO

SELECT sp.name

FROM sys.database_principals dp

...

Sergiy (4/26/2013)

---

You might be surprised - but SQL Server has it too.

And cowboy developers may (most certainly will) ignore that scaffolding in PowerShell as...

Sergiy (4/26/2013)

---

opc.three (4/26/2013)

---

A stand-alone PowerShell prompt on Homer's machine does not offer much over a stand-alone CmdShell prompt on Homer's machine in the way of added security, only in functionality....