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...

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

...

I also agree with Wayne. None of the answers were correct.

Ramdas Baghel (3/10/2011)

---

check http://mssqltips.com/tip.asp?tip=2319%5B/quote%5D

Thank you. That is a pretty drastic approach, since I would lose my configuration as well, but it would certainly solve the problem!:-)

I don't see them in the registry. I have searched the registry for the names, but they are not there.

It may be that SQL 2008 allows values to be assigned to local variables in the declaration, but SQL 2005 does not.

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...

Jumping in...

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...

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...

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...

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...

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...

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...

Are you executing the task from vba? or from visual studio?

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....