Viewing 15 posts - 4,546 through 4,560 (of 6,676 total)
rhunt (9/28/2009)
Yeah, I think I'm going to back up the databases and pull a drive from the mirror...seems like the best approach.Thanks. RH
I have done the same thing on prior...
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
September 28, 2009 at 2:54 pm
The next thing to check is that the user for that connection has Execute privileges for the stored procedure (which includes access to that database).
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
September 28, 2009 at 2:43 pm
FWIW - when you get to SQL Server 2008 SP1 (and greater), you will have the ability to rollback a service pack. But, until then - to rollback you...
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
September 28, 2009 at 2:36 pm
Michael Valentine Jones (9/24/2009)
Lynn Pettis (9/24/2009)
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
September 28, 2009 at 2:28 pm
gmamata7 (9/28/2009)
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
September 28, 2009 at 1:31 pm
You can convert the CTE's into derived tables - are as Steve mentioned, create Views for each one. For example:
SELECT {column list from derived tables}
FROM (SELECT {list of columns...
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
September 28, 2009 at 10:15 am
Person is the schema the object belongs to.
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
September 27, 2009 at 11:11 am
Books Online is the documentation for SQL Server. You can get to it either by going to Help from SSMS, or:
Start | Programs | Microsoft SQL Server 2005 |...
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
September 26, 2009 at 5:46 pm
If you do not filter the update (use a where clause), SQL Server will update every single row in the table. I would recommend using the where clause because...
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
September 25, 2009 at 3:36 pm
espanolanthony (9/25/2009)
But that will create lot of fragmentation. and i think after that rebiulding idexes is not a good idea since that will take...
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
September 25, 2009 at 3:31 pm
;With budgets (account, total)
As (Select account
,sum(amount)
From dbo.Gl
Where accType...
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
September 25, 2009 at 3:24 pm
Seth,
Yes, that was part of what I was thinking - but, the original query did not have anything in the select and was trying to reference columns using the fully...
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
September 22, 2009 at 5:10 pm
That is good to know - glad I could help.
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
September 22, 2009 at 2:58 pm
I don't think the problem is the linked server, but the fact that you are not aliasing the tables. You can no longer use the full table reference for...
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
September 22, 2009 at 2:46 pm
If you create a physical disk resource and want to be able to access that resource through the cluster then you have to have an IP address/name for the resource...
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
September 21, 2009 at 9:22 pm
Viewing 15 posts - 4,546 through 4,560 (of 6,676 total)