Viewing 15 posts - 211 through 225 (of 608 total)
A KILL command will generate that error. Check the error logs to confirm.
October 16, 2013 at 4:42 am
The mail server is not authenticating the sender (your SQL Server). Are you using an exchange server?
October 16, 2013 at 3:53 am
balasach82 (10/15/2013)
October 16, 2013 at 3:26 am
I live and work in Africa and here our bandwidth is too expensive, too slow and too unreliable. We are a long way from "leaning cloud first". At the moment,...
October 16, 2013 at 1:39 am
http://support.microsoft.com/kb/972936
You are on RTM. The latest service pack for 2008 R2 is SP2.
October 15, 2013 at 7:53 am
DECLARE @P_AsonDate AS DATETIME = GETDATE(),
@Str_ToDo AS NVARCHAR(MAX) = '',
@Params AS NVARCHAR(MAX);
SET @Str_ToDo = 'SpTable_2mail @P_AsonDate';
SET @Params = '@P_AsonDate AS DATETIME';
EXEC sp_executesql @Str_ToDo, @Params, @P_AsonDate = @P_AsonDate;
October 14, 2013 at 5:47 am
You are executing exactly the same query 6 times because of the cursor. There is absolutely no reason to use a cursor for this. Why would you want to use...
October 14, 2013 at 4:00 am
This should get you on the right track
DECLARE @Body NVARCHAR(MAX);
SET @Body = N'<HTML><BODY><TABLE BORDER="1">' + CAST((
SELECT
(SELECT name AS 'TD' FOR XML PATH(''), TYPE),
(SELECT object_id AS 'TD' FOR XML PATH(''), TYPE),
(SELECT...
October 11, 2013 at 7:22 am
[JOKE]
What's in tbl_gods_lineOfBusiness. Does the query only run on Sunday's?
[/JOKE]
October 11, 2013 at 4:47 am
There are a number of performance issues here. I would quote a client 2 days minimum to optimize this one. However what did jump out at me was the excessive...
October 11, 2013 at 4:41 am
Index and statistics maintenance should only run on the primary. We have our maintenance jobs running on primary and secondaries but we exclude read only databases.
SELECT
*
FROM
sys.databases
WHERE
DATABASEPROPERTYEX(name, 'Updateability') = 'READ_WRITE'
October 11, 2013 at 3:35 am
Hi Tom,
Here is a blog post regarding this:
http://sqlblog.com/blogs/merrill_aldrich/archive/2011/11/25/one-database-or-ten.aspx
The most important idea about the log is this: the only way to get a transactionally consistent set of data over time is...
October 11, 2013 at 1:11 am
http://technet.microsoft.com/en-us/library/ms180099(v=sql.90).aspx
sp_makewebtask is retained for backward compatibility. New Web pages are more easily created using Microsoft SQL Server 2005 Reporting Services (SSRS).
This feature will be removed in the next version of...
October 11, 2013 at 12:51 am
Viewing 15 posts - 211 through 225 (of 608 total)