Viewing 15 posts - 5,386 through 5,400 (of 6,676 total)
Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response :w00t:
http://www.sqlservercentral.com/Forums/Topic697843-146-1.aspx#bm697863
Really - let me...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2009 at 1:48 pm
If you are seeing this message in your logs, then you have a user/service/application trying to login to SQL Server using Windows Authentication when that user/server/application has not authenticated on...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2009 at 1:29 pm
Yes, you are trying to login with Windows Authentication when you are not authenticated on the domain. Either authenticate on the domain - or, use Runas to run as...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2009 at 1:20 pm
And what about the case when you have information in the header record that needs to be associated with the detail records? For example, if we have an employer...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2009 at 12:50 pm
You are welcome and thanks for the feedback.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 15, 2009 at 9:17 am
Probably - but not without a lot more information. Please review the article I link to in my signature. This article will show you how to post your...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 8:50 pm
Yes i am running steve's code and still i get 2251 records.
I examined the result and the code is picking up all possible matching suitid so I am getting...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 8:45 pm
Sponge (4/14/2009)
Thank you very much for your reply. Steve: To answer your question I am using a mainteance plan so the backup actually dumps first and then perges...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 4:51 pm
andrewd.smith (4/14/2009)
SELECT MemberId, AVG(LabValue)
FROM (
SELECT...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 4:15 pm
Well, do you want the last two months average - or the average from the last two entries? Is it possible that you could have results for the last...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 4:02 pm
Krishna Potlakayala (4/14/2009)
And also I think it wouldn't be a clean shut down of SQL server as in WITH NO WAIT but I am not so sure though.
It is a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 2:51 pm
Select Memberid, avg(labvalue)
From MemberLabResult
where labid = 1
Group by Memberid
Having
avg(labvalue) > 4 or
avg(labvalue) < 4
Add your date filter to the where clause:
WHERE labid = 1
...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 2:49 pm
When you take a resource offline in cluster administrator - it is the same as stopping the service. It is a service shutdown - and yes, the system will...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 2:43 pm
Find the job or job step (probably in the full backup) that disables the transaction log backups. On SQL Server 2000 - you can't run both a transaction log...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 1:46 pm
In SSMS - right click on the Error Log folder and select configure. You can configure the number of SQL Server error logs that will be kept.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 14, 2009 at 1:39 pm
Viewing 15 posts - 5,386 through 5,400 (of 6,676 total)