Viewing 15 posts - 6,661 through 6,675 (of 6,676 total)
If you cannot afford any downtime, the only option is to backup/restore. Now, since you will be moving your backup files to a network share (make sure you 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
January 16, 2008 at 10:50 am
Since they only need something to run queries - there are several low cost (and free) utilities available.
I prefer either Toad from Quest or DbVisualizer, but there is also WinSQL...
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
January 15, 2008 at 8:22 pm
I have no idea how many apps would run - all I know is that one of my vendors would not support the version we had on 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
January 6, 2008 at 7:19 pm
This sounds like a vendor supplied application. If so, and the vendor does not support this version on SQL Server 2005 - there are no options for you other...
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
January 6, 2008 at 7:02 pm
Take a look at the SQL Compare and SQL Data Compare tools from Redgate. I hope they are making these changes on a test system first. You can...
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
January 5, 2008 at 11:04 am
smknox (12/29/2007)
This doesn't seem to work:
CREATE PROCEDURE usp_ProgNote_Insert
@SecondaryKeyValue int
,...
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
December 29, 2007 at 12:44 pm
They are just icons for the maintenance plan. They have no special meaning.
The difference can be explained by looking at the version of SQL Server you are connecting 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
December 29, 2007 at 12:27 pm
SQLIS has plenty of examples for all types of transformations. You might want to take a look at the rowcount transformation examples.
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
December 26, 2007 at 10:06 am
Sure, what you have is:
,'TeamMentor' =
CASE
WHEN TeamMentorDate IS NOT NULL THEN 'Team Mentor'
WHEN (SELECT r.AchieveTitle FROM Repromotes r WHERE RepFlag = 'X' AND AchieveTitle = 'Team Mentor) THEN 'Team...
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
December 24, 2007 at 12:53 pm
Yes - you can, but I am not sure you need this. Anyways, for that part - you can use an EXISTS, or check for NOT NULL. Examples:
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
December 24, 2007 at 12:27 pm
Plenty of options and help at: http://www.sqlis.com
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
December 24, 2007 at 12:16 pm
SQL Server uses the Windows password policy mechanism. So, whatever is defined on your server (Windows 2003 or higher) is what will be used.
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
December 24, 2007 at 12:00 pm
midan1 (12/22/2007)
i ask the friends here if thay can help only !
i am working on complex project and i need it
to find the "day before Last day of...
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
December 22, 2007 at 1:27 pm
With your SAN an HP EVA - single disk group with 120 spindles, it won't make any difference at all. All LUN's are presented from the same set of...
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
December 16, 2007 at 9:53 am
I would be very concerned about this approach, since you no longer have any way of restoring your system to a point in time prior to your latest backup.
Take this...
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
December 7, 2007 at 11:26 am
Viewing 15 posts - 6,661 through 6,675 (of 6,676 total)