Viewing 15 posts - 5,191 through 5,205 (of 6,676 total)
I have seen these kinds of problems when the client tools used to create the maintenance plan is a lower version than the system where the plan exists.
Verify that 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
May 15, 2009 at 2:25 pm
Luke L (5/15/2009)
The short answer is no, you can't really change the datasource at run time...
Huh - take a look at this article: http://www.sqlservercentral.com/articles/Development/2945/
Also, a simple google search on 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
May 15, 2009 at 2:17 pm
Not sure of your actual requirements - so, please read the article in my signature if you need additional help.
Try this:
SELECT ID, [month], [year], Period
FROM dbo.OpMonthlyBonus
WHERE Period = CASE WHEN...
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
May 14, 2009 at 8:17 pm
Gail wrote a great article I link to in my signature. It would be worth the read for you.
As for using TRUNCATE_ONLY - there is absolutely no reason 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
May 14, 2009 at 8:14 pm
Please review the article in my signature. To better answer your question we are going to need table definitions (create table statements), sample data (insert statements) and expected results.
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
May 14, 2009 at 4:29 pm
mark (5/12/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
May 12, 2009 at 9:37 am
The easiest way is to log into SQL Server with the desired account and change the name of the maintenance plan, and then change it back. Open each sub-plan...
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
May 12, 2009 at 8:14 am
mark (5/12/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
May 12, 2009 at 8:04 am
Been there done that - just remember, this is a 'scripting' language and as such does not tell you when you have made a typo. I have seen where...
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
May 11, 2009 at 8:48 pm
I tested that against one of my 2008 systems and it returned "10". Try adding Write-Host $srv.VersionMajor before the if statement and see what is being returned from 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
May 11, 2009 at 8:29 pm
For objects inside the database (e.g. stored procedures, functions, views, tables, etc...) I use the comparison tools from Redgate (SQL Compare & SQL Data Compare).
For objects (scripts) outside of 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
May 11, 2009 at 3:12 pm
Shawn Therrien (5/11/2009)
Jeffrey Williams (5/11/2009)
Shawn Therrien (5/11/2009)
I do apologize. I didn't realize that VPN software didn't work with a 64bit OS and was stranded away from my work materials.
Not 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
May 11, 2009 at 3:06 pm
I am not clear why you felt it was necessary to truncate the log. If you run out of disk space to perform the backup - the backup job...
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
May 11, 2009 at 2:48 pm
Alvin Ramard (5/11/2009)
Grant Fritchey (5/11/2009)
Well to get the thread back "on topic" (as if), this one has managed to raise my blood pressure with his/her response.Suffice to say. I'm done.
Someone...
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
May 11, 2009 at 2:28 pm
For each database, you could do the following:
GRANT UPDATE ON SCHEMA::dbo TO {user/role};
Assuming the schema you want to grant update privileges to is 'dbo'. If not, change the schema...
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
May 11, 2009 at 2:25 pm
Viewing 15 posts - 5,191 through 5,205 (of 6,676 total)