NJ-DBA (12/6/2011)

---

With the limited info you provided, I can say it's likely that the peformance gain you are noticing is due sql server caching the execution plan and reuses it...

With the limited info you provided, I can say it's likely that the peformance gain you are noticing is due sql server caching the execution plan and reuses it on...

I run the following to set page lock on for every index in every database on a server:

exec master..sp_MSForeachdb 'USE [?]

if ((select is_read_only from sys.databases where name=db_name())=0)

begin

SET NOCOUNT ON

DECLARE @DBName...

george sibbald (12/5/2011)

---

Thanks for sharing Warren. If this is to be used on SQL2005 and above you really need to be switching to 'create user' syntax rather than sp_grantdbaccess, else...

crazy4sql (12/5/2011)

---

Script is good if we have all the required logins in place else we still need to create the logins first.

Also sp_change_users_login, report only about the orphaned sql login...

vultar (11/22/2011)

---

Dev - I'd guessed they would probably behave the same but wanted to double check more anything.

NJ-DBA - That's worked a treat, much better & safer than editing the...

NJ-DBA (11/22/2011)

---

NJ-DBA (11/22/2011)

---

from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/

Here I will show how to find or change the default backup dircetory in various versions of SQL Server.

SQL Server 2008

Connect to the server in SSMS.

In...

NJ-DBA (11/22/2011)

---

from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/

Here I will show how to find or change the default backup dircetory in various versions of SQL Server.

SQL Server 2008

Connect to the server in SSMS.

In the...

from http://www.sqlservercentral.com/articles/Backup+%2f+Restore/71500/

Here I will show how to find or change the default backup dircetory in various versions of SQL Server.

SQL Server 2008

Connect to the server in SSMS.

In the Object...

NJ-DBA (11/10/2011)

---

Application folks have a process by which a job drops and creates database snapshots. In one particular, odd case, a snapshot has been dropped, but the sparse files...

christophe.bernard 47659 (11/10/2011)

---

Hi,

We worked with sql server 2005 and since last week end we have migrate all your server, database and so on to sql server 2008.

Now, we notice since...

Hmm, I guess the system accuont needs to be granted permissions to "send as" the sender email address you are using.

Sounds pretty solid to me.

The error message suggests it cant "send as" the sender you are specifying... so you said you specified your address as the sender- if you leave the sender address blank...

You need to talk to the person who administers your SMTP server. The easiest way, is for the mail server admin to configure the SMTP server to allow anonymous...