Any backups or snapshot of drives available?

Gianluca Sartori (9/30/2011)

---

Setting up email notifications for failed jobs is very easy. See here[/url].

Adding the failure reason and message is a bit more complicated. Instead of relying on standard notifications,...

I can see so many advices going for a sql server reboot. This should be your last resort when nothing else works. Today you might have the luxury of doing...

Ninja's_RGR'us (9/22/2011)

---

Oh darn, a view in a view + slow linked server.

Sounds like I'd do a sp for each report they need.

I'd also look at some sort of replication, or...

Ninja's_RGR'us (9/22/2011)

---

The short answer is that neither of the servers know what the other server sees.

So the safest way to go about building a plan is to download all data...

sqlnaive (9/15/2011)

---

I'm giving following value for connection and its giving me error while connecting to SQL 2008. The same when running for SQL 2005, its working fine.

value="server=ServerName\Instancename,PortNumber;database=DatabaseName;uid=UserId;pwd=P@ssw0rd"

Error message:

"A network-related or...

Thanks to both of you for your replies.

We are using default isolation level and in their stored procedure they will just write some select commands as this server is just...

@SQLFRNDZ (9/7/2011)

---

We have a database which is push subscriber for a publisher in other environment (other group in my company)

In order to audit the dml changes in subscriber tables...

Chuck 17099 (9/6/2011)

---

Hi Chandan,

The logfile pretty much shows the same thing as the web page plus a bunch of stuff I don't understand. I'll copy it here in case it...

Chuck 17099 (9/6/2011)

---

Good morning Chandan,

Thanks for your reply. I checked the SQL server log and there are not entries at the time of the error. I also check the SSRS...

Chuck 17099 (9/5/2011)

---

I have re-installed my SQL and the default instance of SQL 2008. I have restored the databases including the ReportServer and the ReportServerTempDB databases. I have re-installed SSRS...

Use the following command to list all the plans:

SELECT [text], cp.size_in_bytes, plan_handle

FROM sys.dm_exec_cached_plans AS cp

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

WHERE cp.cacheobjtype = N'Compiled Plan'

AND cp.objtype = N'Adhoc'

AND cp.usecounts = 1

ORDER BY cp.size_in_bytes DESC;

If...

niravbhat (9/1/2011)

---

I am getting following error please guide

The Replication agent has not logged a progress in 10 minutes. This might indicates an unresponsive agent or high system activity,...

Leave the re-initialize...

open the properties for that publication---> Add your table--> Press OK and come out of that wizard.

now, go to the replication and right click on your publication--> View Snapshot agent...