Viewing 15 posts - 6,331 through 6,345 (of 6,676 total)
ALZDBA (7/19/2008)
Thank you for providing the extra parameters Jeffrey.Apparently those weren't in BOL sep. 2007
Interesting, I didn't even think about the version of BOL I was using - but I...
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
July 19, 2008 at 9:39 am
jonathanmreynolds (7/18/2008)
As for your problem with multiple rows - that is going to be caused by the joins. In the following:
from transactions t
Inner Join...
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
July 18, 2008 at 11:39 pm
,(select sum(t1.amount)
from transactions t1
...
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
July 18, 2008 at 7:15 pm
jzurbo77 (7/18/2008)
I need to expand...
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
July 18, 2008 at 3:12 pm
Okay, I think this is what you are looking for - but I cannot be sure. I am not sure whether or not you need to tie transactions by...
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
July 18, 2008 at 2:18 pm
Take a look at the following:
Select name
,create_date
,modify_date
...
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
July 18, 2008 at 12:49 pm
Jose-cin (7/17/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
July 18, 2008 at 12:04 pm
If your database is in full recovery model, the best way to truncate the log is to back it up - frequently.
If your database is in simple recovery model -...
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
July 17, 2008 at 8:06 pm
Yes - I believe Standard only supports two nodes, but yes - it can be clustered.
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
July 17, 2008 at 5:12 pm
Keith Knox (7/17/2008)
thanks...
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
July 17, 2008 at 5:04 pm
I had to reformat this to get an idea of what is going on. Here is the reformatted query:
CREATE PROCEDURE usp_rptOpenTicketsByYard
AS
SELECT tblTickets.*
,tblTicketStatus.status
,tblTicketPriority.priority
,tblCallTypeSub.Description
,tblTicketCallTypes.CallType
,tblUsers.First_Name
,tblUsers.Last_Name
,tblYardInfo.YardName
,tblTickets.CreatedOn
,tblTickets.Yard
,tblTicketPriority.PriorityStatus
CASE
WHEN tbltickets.ProjectTicketOption = 0
THEN "Ticket"
ELSE "Project"
END
...
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
July 17, 2008 at 5:02 pm
First thing you need to do is check the SPN record for that instance of SQL Server. If you do not have access to this, talk to the network...
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
July 17, 2008 at 2:51 pm
Yes, you are right - ALL does not appear to be available for schema. So, you are going to have to list all of the permissions you want.
GRANT permission...
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
July 17, 2008 at 2:07 pm
ganeshmuthuvelu (7/16/2008)
I have a Schema by name "Common" in which I want a set of users "user1, user2, user3" to have full control on it. That means they can create,...
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
July 16, 2008 at 5:03 pm
DKG (7/16/2008)
Is ther any way i can add all the stored procedure of database into the ROLE - in one go?
The following command grants access to ALL stored procedures in...
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
July 16, 2008 at 4:57 pm
Viewing 15 posts - 6,331 through 6,345 (of 6,676 total)