That could be painful but not impossible.

The symmetric...

No problem, I will try to post some additional info on how to work with these objects in this thread;

a lot of that will probably overlap with similar info...

I saw this link just now:

[p]http://www.sqlservercentral.com/Forums/Topic795626-150-1.aspx[/p]

One recommendation is to change the isolation level of ReportServerTempDB to READ COMMITTED.

I wonder if anyone has attempted this?

spraocs (10/26/2010)

---

Hi Mike,

Thanks for an excellent article.. I am a developer and not a DBA. However, I cannot implement encryption without knowing the details in-depth about the same. Your article...

amit_gupta01 (10/25/2010)

---

I have not come across any standard tool for SSAS so far... but you can monitor performance in profiler by starting new trace and capturing related events. Mainly facts...

Here are a few:

- database mail (as opposed to SQL MAIL)

- SQL CLR (for file-system operations, web services, regular expressions)

- service broker

- "EXEC @sql AT LinkedServerName" syntax

- module signing (EXECUTE...

Got following error on local server when running DTCping:

++++++++++++Start DTC Binding Test +++++++++++++

Trying Bind to RemoteSrvr1

10-22,...

I wonder why in that link they are using SQL CLR to implement module signing. It's not necessary.

The same solution can be implemented with straight...

Suresh B. (10/21/2010)

---

It may not cause security issues.

But, in my opinion, it is better to give DBMail access to only limited number of users.

Because, it is possible to send...

Frequent shrinking/expansion of the log file will also cause it to get more fragmented, another reason why you should avoid repetitive shrinking.

Run queries below to troubleshoot db-mail issues:

--get failed messages over last 5 days:

SELECT * FROM msdb.dbo.sysmail_faileditems

where datediff (day, sent_date, getdate()) < 5

--get mailitem_id from query above - eg. 2024 -...

praveen_vejandla (10/16/2010)

---

We have database mirror configured between source and destination SQL 2008 servers with no safety and no witness.

Suddenly if primary server is intentionally shutdown or it goes down, I...

Let's also not forget backing up the distribution database, if using replication.

reggie burns-317942 (10/15/2010)

---

Could I see a performance change with 2000 and 2008 if they are configured as

2000 has Windows2003 Enterprise with 8GB RAM

2008R2 has Windows2008 R2 Enterprise with 8GB RAM

Could...

See also this link:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=66d3e6f5-6902-4fdd-af75-9975aea5bea7&displaylang=en

SQL-2008 Post-Upgrade Tasks - Upgrading to SQL Server 2008

-------------------------------------------------------------

1.Change the db compatibility level to 100.

2.(ONLY for database upgrades from SQL Server 2000 to SQL Server 2005/2008)

Execute DBCC...