Viewing 15 posts - 5,791 through 5,805 (of 6,676 total)
I would bet anything that the job is stalling on the WAITFOR command. 😛
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
December 21, 2008 at 6:56 pm
ps (12/21/2008)
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
December 21, 2008 at 6:38 pm
That's kinda what I thought - so, your choice is simple. You need to create a job that checks for newly created databases and, if found - back them...
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
December 21, 2008 at 11:44 am
RBarryYoung (12/21/2008)
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
December 21, 2008 at 11:20 am
Look in the SQL Litespeed help file on the command line utility - and extended procedures. I don't have the reference available right now - but there is an...
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
December 19, 2008 at 11:04 pm
So, the first thing we need to do is define the schema:
CREATE SCHEMA DELT AUTHORIZATION dbo;
Then, we would create the synonyms:
CREATE SYNONYM DELT.ACCT AS REPORTDB.DELT.ACCT
CREATE SYNONYM DELT.ORG_ACCT AS REPORTDB.DELT.ORG_ACCT;
Create the...
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
December 19, 2008 at 11:00 pm
SSRS outputs to Excel 2003 format - which has a maximum number of rows of 65357 (I think that is the number). If you have over 900,000 records -...
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
December 19, 2008 at 3:00 pm
Mike - are you sure all other connections are using the FQDN when connecting? Are you sure that all other connections are using a matching SPN record to connect?
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
December 19, 2008 at 2:13 pm
You can use a CTE or a derived table - here is an example using a CTE.
;WITH myCTE (field1, field2, field3, ...)
AS (SELECT {complicated sql...}
...
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
December 19, 2008 at 1:55 pm
I would recommend using synonyms for this. Much easier to manage and change as needed. Example:
-- create a schema for the synonyms, not really needed - could use...
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
December 19, 2008 at 1:30 pm
Lynn Pettis (12/19/2008)
I am sure you would help if you could. My problem is with applying SP 3 to a multi-instance x64 server running SQL Server 2005 Developer Edition.
If...
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
December 19, 2008 at 12:50 pm
Is that procedure the only procedure doing any inserts? Can you confirm that the inserts that you see that are blocked are all related to this procedure?
If so, that...
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
December 19, 2008 at 12:44 pm
Yes, you can have it both ways. And don't worry - most of us are confused about it also. I only know a few pieces of it myself.
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
December 19, 2008 at 12:24 pm
Yes, I think you understand what needs to be done. Just one clarification:
SETSPN -A MSSQLSvc/myserver1 ServiceAccount
SETSPN -A MSSQLSvc/myserver2 ServiceAccount
SETSPN -A MSSQLSvc/myserver3 ServiceAccount
I forgot to add in the service account...
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
December 19, 2008 at 10:42 am
Are you using the FQDN in all connection strings? I know - stupid question, but have to ask it anyways.
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
December 19, 2008 at 10:21 am
Viewing 15 posts - 5,791 through 5,805 (of 6,676 total)