Viewing 15 posts - 6,226 through 6,240 (of 6,676 total)
I probably wouldn't use a dynamic SQL approach, because that is going to be much harder to work with on the report side anyways. How are you going 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
August 3, 2008 at 1:15 pm
Animal Magic (8/3/2008)
Ive slightly complicated matters here. there are a few areas where i have been looking to implement triggers, most are for email reasons, in which case...
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
August 3, 2008 at 1:05 pm
Did you change the account that is running SQL Server? For example, change from a domain admin account to a domain service account? Or, from local system 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
August 3, 2008 at 12:10 pm
Jeff Moden (8/3/2008)
There are a couple of ways to do it... the method...
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
August 3, 2008 at 12:01 pm
Animal Magic (8/3/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
August 3, 2008 at 11:55 am
JKSQL (8/1/2008)
The user using the sp will not have permissions to alter a table. So I can not disable...
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
August 1, 2008 at 4:06 pm
rbarryyoung (8/1/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
August 1, 2008 at 4:04 pm
I really don't have an answer to your specific question, but have you tried enabling the SQL Browser service on ServerA? That service should allow you to reference 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
August 1, 2008 at 4:01 pm
Deee -Daah! (8/1/2008)
When I use COALESCE to concatenate a string over many periods, it gave me the string backwards.
--using the table #test as is, gives me the results backwards...
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
August 1, 2008 at 3:56 pm
alorenzini (8/1/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
August 1, 2008 at 3:50 pm
alorenzini (8/1/2008)
I tried...
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
August 1, 2008 at 3:41 pm
alorenzini (8/1/2008)
Ok let eliminate the dynamic SQL. How would I introduce the @Level into the WHERE clause?
IF (@Status = 'All active')
BEGIN
SELECT *
FROM #DLFiltered...
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
August 1, 2008 at 2:50 pm
Art, all you needed to do was add parantheses around the bolded section to 'pair' those two criteria. That should fix the issue you have with that dynamic query.
BTW...
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
August 1, 2008 at 1:49 pm
Actually, it is quite simple - all you need to do is look at what you have.
SELECT *
FROM #DLFiltered
WHERE Active = 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
August 1, 2008 at 1:14 pm
alorenzini (8/1/2008)
SELECT * FROM #DLFiltered WHERE Active = 1 AND...
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
August 1, 2008 at 12:55 pm
Viewing 15 posts - 6,226 through 6,240 (of 6,676 total)