Viewing 15 posts - 1 through 15 (of 15 total)
That is great info for a newbie like me! Thanks so much for helping out!
July 20, 2009 at 8:39 am
Oh...I see what you mean. I can now figure out what the rest of the stored proc is doing based on these dates. Thanks a lot!
July 20, 2009 at 8:38 am
Thanks so much for helping out. I will use the syntax posted in the solution.
Here is the part that I had needed help with in my where clause...
June 28, 2009 at 10:45 pm
Thank you so much for your time and detailed instructions. It worked this time!
June 25, 2009 at 11:37 am
I tried using the select node approach but I dont think I am using the correct syntax. I used a code sample from http://support.microsoft.com/kb/318499 for this but...
June 25, 2009 at 8:13 am
Thank you so much. I will give this a try and post a reply when it works!
June 24, 2009 at 12:01 pm
aah...as you can see I am really a newbie at writing queries. Thank you so much for your help!
September 10, 2007 at 9:39 am
Thanks for the reply, I had tried the (site = 'M' and career_level <> 'u') but I get only students on Campus M who are not undergrads with that.
September 10, 2007 at 9:27 am
Thanks! Now I have divided my task into two "Execute sql steps"
1. Backup a db
BACKUP DATABASE rmsReal
TO DISK='c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\BU_remReal.bak'
2. Restore it as a different db
March 17, 2006 at 7:39 am
The Execute SQL task gives an error saying I need at least one connection. What does that mean?
March 16, 2006 at 8:51 am
Thanks for your help. I am trying to automate this process and was wondering how to do that.
March 15, 2006 at 1:09 pm
I tried that but I am still getting the same error. Is there any other way for me to clean the txt file before I bring it in using DTS?
May 17, 2004 at 1:46 pm
Never mind! I just found out I needed to set the object to Nothing
set oFSO = Nothing
April 9, 2004 at 2:47 pm
When I tried to save the script, it is giving an error. It says that the job was not saved because all objects that were created were not destroyed. The error code...
April 9, 2004 at 2:15 pm
Thanks for your help! I really appreciate it.
April 9, 2004 at 11:12 am