Viewing 15 posts - 6,091 through 6,105 (of 6,676 total)
First, I don't see any difference between the two queries. I am assuming you meant to modify the second query to something else.
As for your problem - can 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
September 10, 2008 at 3:31 pm
Where exactly in SSMS are you building this query? I have never seen a popup window when I have syntax errors - rather, the results pane will show 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
September 9, 2008 at 2:24 pm
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 9, 2008 at 2:15 pm
Is SQL Server Agent running under a domain account or local account (e.g. Local System).
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 9, 2008 at 2:15 pm
What is the error you are 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
September 8, 2008 at 9:19 pm
bdavis (9/8/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
September 8, 2008 at 3:54 pm
Try modifying the call to sp_send_dmail and prefix the call with the database and schema. The call should be:
Execute msdb.dbo.sp_send_dbmail ...
The other thing to try is to make sure...
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 8, 2008 at 1:45 pm
rbarryyoung (9/7/2008)
I like the powershell idea though, but I'm not proficient enough to evaluate it yet.
Yeah - I know what you mean, since I am only proficient enough to have...
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 7, 2008 at 7:10 pm
You can use either of the following:
-- ANSI standard
UPDATE test
SET col1 = (SELECT col1
...
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 7, 2008 at 11:06 am
For this type of process, I use a powershell script that runs on my central management server. The powershell script opens a connection to the database on that server,...
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 7, 2008 at 9:42 am
You can run the install from the network location where you copied the DVD contents. If that is not an option (bandwidth issues?), then I would recommend copying 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
September 3, 2008 at 2:27 pm
When I tested SQL Prompt, I liked it - but, I did not like the price or the fact that it only works for SQL Server. I also have...
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 2, 2008 at 8:27 pm
ALTER DATABASE tempdb SET RECOVERY SIMPLE;
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 2, 2008 at 2:10 pm
Maybe I am misreading this - but it sounds like all you need to do is change the join in the view from an inner join to a left outer...
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 1, 2008 at 10:10 am
How many pages do these tables have? Small tables will always show a high level of fragmentation.
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 31, 2008 at 7:29 pm
Viewing 15 posts - 6,091 through 6,105 (of 6,676 total)