Viewing 15 posts - 1 through 15 (of 54 total)
I clicked on the link to download SSMS v17.1 in the SQL ServerCentral.com The Voice of the DBA feature for today. I have deactivated, un-installed, and re-installed all the products in...
July 20, 2017 at 12:52 pm
I use window functions all the time. I am looking forward to upgrading from SQL 2008 R2 to get more window function features.
SELECT DISTINCT ComponentKey
December 5, 2013 at 8:04 am
I also agree with Wayne. None of the answers were correct.
June 7, 2011 at 7:14 am
Ramdas Baghel (3/10/2011)
Thank you. That is a pretty drastic approach, since I would lose my configuration as well, but it would certainly solve the problem!:-)
March 10, 2011 at 11:21 am
I don't see them in the registry. I have searched the registry for the names, but they are not there.
March 10, 2011 at 10:02 am
It may be that SQL 2008 allows values to be assigned to local variables in the declaration, but SQL 2005 does not.
March 23, 2009 at 6:57 am
You could also use a different approach and build the backup job by creating a new maintenance plan (open the management node). This will give you the option to schedule...
August 18, 2008 at 7:46 am
I assume each debit and credit is associated with a user identifier and has a post date time stamp. If that is the case, it seems to me that...
August 4, 2008 at 8:03 am
There may be a field that you can use as a status field in the existing table structure. You could set a job to update that field every night, and...
July 24, 2008 at 6:46 am
hmmm...I have to think about this.
I have an appointment the rest of today, and will not get back to this until Monday. If you find a solution in the...
October 5, 2007 at 1:13 pm
Sorry, I have worked in vba and in Viasual Studio (current version), but not in Visual Basic 6.0. However, the commands are the same as those that I used in...
October 5, 2007 at 12:07 pm
Thanks for your response. I am not sure I want to design the packages again. I have noticed, like you, that once I have chosen one level of protection, it...
October 4, 2007 at 2:59 pm
You may want to try to actually do those steps in SSIS instead of having SSIS call the dts package. This might solve the problem.
While SSIS will run SQL 2000...
October 4, 2007 at 2:05 pm
Are you executing the task from vba? or from visual studio?
October 4, 2007 at 8:56 am
I have found that it is actually easier just to back up from the SQL server to a network share, since either way you are moving data over the network....
October 4, 2007 at 8:49 am