Viewing 14 posts - 16 through 29 (of 29 total)
I don't think it's a question of trusting maintenance plans vs trusting third party apps or your own scripts. Any of these things can fail for many reasons. What you...
November 26, 2010 at 12:38 pm
I understand those groups were specific to 2005, however, 2008 had equivalently named groups for two of the three groups that I listed so I believe they are still relevant....
February 2, 2010 at 5:02 pm
Awesome GSquared, that worked!
I had also tried 'SET CONCAT_NULL_YIELDS_NULL OFF' and that worked as well. I wasn't sure if this would have adverse effects so I'm going with your...
August 20, 2009 at 1:10 pm
Thank you, PS! You definitely got me moving in the right direction. I am now successfully sending results to my inbox. I have more challenges ahead of...
August 20, 2009 at 12:54 pm
Right, the filegroup contains logical names, and those locigal names can be split amoung multiple physical locations.
That's being said, an object, such as a table can be in...
July 23, 2009 at 10:27 am
Thank you for the information 🙂
This project started as a report to see how much space a database was consuming on specific storage locations. Then a request came in...
July 23, 2009 at 9:22 am
I took the SQL Server 2005 Dev and Admin course. It was a very high level introduction to 2005 (I know at the time, they offered courses that covered...
March 23, 2009 at 9:16 am
SQL TASK
OK, first make sure the variable you created is of type 'object'.
Then, when you open your SQL task, click on 'General' and set the ResultSet to 'Full result set'.
Now...
March 20, 2009 at 7:31 am
ok, that's all I got 🙂 hopefully someone more knowledgable will respond to your issue.
good luck!!!
March 19, 2009 at 2:50 pm
OK, I'm for the most part a beginner so forgive me for even trying to help here, but I'm trying to help....
I was getting very odd errors on a project...
March 19, 2009 at 2:38 pm
Have you looked at what the actual value of @query is being set to? Perhaps it's not being set correctly?
March 19, 2009 at 2:18 pm
I took a SQL course from HOTT and it was worth every penny.
Not only was the course useful, but when they cancelled the class that was being held in my...
March 19, 2009 at 12:03 pm
You can use an SSIS package for this.
Frist create a variable to store a result set in.
Then you would want to create an 'Execute SQL Task' that will contain...
March 19, 2009 at 11:52 am
Viewing 14 posts - 16 through 29 (of 29 total)