-
DTS runtime and Legacy Components are not supported on 64-bit
SQL Server 2005 provides a utility called DTS Migration Wizard to help you move your legacy DTS 2000 packages to SSIS format. It is not guaranteed to work perfectly, but it will make a best-effort attempt. Initially, you may want to install DTS runtime on the SQL Server 2005 box so you can continue running…
-
Give role authority to upload image files in DNN
I talked about roles and permissions in DotNetNuke (DNN) in this post. Sometimes you want to grant a role authority so users with that role can upload image files for their documents. Here is how you do it: 1. From the Admin menu, usually at the far right of the horizontal menu bar, pick File…
-
Great Flickr Greasemonkey Scripts
Update: Flickr changed its interface, so the scripts in step 2 and 3 no longer work. I will update this as I get more information. If you have Flickr account and use Firefox, I found 2 Greasemonkey scripts that are very helpful. They make photo editing so much more easier. They are both focused on…
-
Connect to a different database server within command line utility
In sqlcmd, you can connect to a different server by this command: :connect MyServer The above command will attempt to use integrated / Windows Active Directory authentication. To use traditional Sql Server authentication, use this instead: :connect MyServer -U MyLogin You can do the same kind of thing in Oracle Sql Plus by using this…
-
Drop the empty schema first before you can remove its user
A few weeks ago, I ran into an issue with a SQL Server 2005 database restored from a Sql Server 2000 backup file. I want to share how I resolved this, hopefully it will be helpful to somebody. You can restore a Sql Server 2000 database backup to a SQL Server 2005 server. When pages…