Viewing 15 posts - 31 through 45 (of 93 total)
True about the other ways to get this kind of data, and I use both of those fairly frequently as well. This is for those times when I have several...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
December 6, 2012 at 12:49 pm
That got it. Thank you for all the help.
If someone comes across this post later, and wants to see a walk through, I'll upload the screen capture of what I...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
November 26, 2012 at 2:57 pm
Glad I posted this, because my brilliant idea caused the system to crash.
I tried the Tasks > Copy Database option. I made it most of the way through, but that...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
November 26, 2012 at 2:41 pm
Ok, I have a solution for my first question. I am sure there must be a better way to do this, but this is what I've got so far:
Exec dbo.upObjectQuickDrop
...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
November 5, 2012 at 9:47 am
ScottPletcher (10/8/2012)
SELECT lastname
FROM HR.Employees
WHERE
lastname LIKE '%[/]%' AND
lastname NOT LIKE '%[/]%[/]%'
Still have to add the line that removes / in the first character....
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
October 8, 2012 at 2:11 pm
Lowell (4/26/2012)
i put this proc in master, adn whenever i need to refresh myself with date conversions, i just run "sp_dates" in SSMs, to get a quickie...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
April 26, 2012 at 12:01 pm
I found the solution on another forum.
Script Task code:
Public Sub Main()
Dim vFTP_Loc As String
Dim vFile As Object
Dim vFileObject As Object
Dim vFolder As Object
Dim FSO As Object
Dim vFileCount As Integer
Dim vConnection...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 22, 2012 at 11:48 am
I found the solution on another forum.
Script Task code:
Public Sub Main()
Dim vFTP_Loc As String
Dim vFile As Object
Dim vFileObject As Object
Dim vFolder As Object
Dim FSO As Object
Dim vFileCount As Integer
Dim vConnection...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 22, 2012 at 11:43 am
I have done both the full restore (listed in first post with time taken to complete the restore) and now Restore VerifyOnly, and all of those tests show the files...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 21, 2012 at 4:25 pm
The links already given above will work a great deal better than what I'm about to show, but...
My wife says I love complicated things, and I'm sure that will show...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 21, 2012 at 4:12 pm
SQLKnowItAll (3/21/2012)
Have you verified the integrity of the backup file?
If you mean do I know that the files work during a restore, yes they do. What other way would you...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 21, 2012 at 3:27 pm
Perfect, that seems to have gotten it so far. Now I'll see if this works in an SSIS package. I'll post an update about how it goes when I test...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
March 12, 2012 at 3:52 pm
Elliott Whitlow (2/24/2012)
SQLRNNR (2/24/2012)
Jeff Moden (2/24/2012)
Attacking SSIS at last...
I finally started doing the same thing and had to stop. They really took serious offense to me hitting the server...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
February 24, 2012 at 2:57 pm
Thank you all for your responses. You've given me a great deal to think about, and a greater focus on my research for this weekend.
I want to make sure that...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
February 24, 2012 at 9:59 am
Ok, I believe I've figured it out, and I feel a touch foolish for missing such a simple solution:
TestString = Chr(34) & "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" & Chr(34) &...
[font="Arial"]“Any fool can know. The point is to understand.”
- Albert Einstein
"DOH!"
- Homer Simpson[/font]
February 13, 2012 at 12:40 pm
Viewing 15 posts - 31 through 45 (of 93 total)