http://whitechief.itpub.net Isolating Web Sites and Applications (IIS 6.0)Although some of the Web servers that you deploy host only one Web site or application, you might also need to host multiple Web sites and applications on the same Web server. When a Web server hosts multiple Web sites and applications, each Web site and application requires a certain level of isolation. For example, an Internet service provider (ISP) might host Web sites and applications for hundreds of organizations, each having a unique Web... http://whitechief.itpub.net/post/1825/114075 Wed,14 06 2006 00:47:47 I am here to provide a config file sample to show how to configure a smtp server in reporting service 2005.config file: reportingserviceinstallationdirreportserverrsreportserver.config <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>[servername.domainname]</SMTPServer> <SMT... http://whitechief.itpub.net/post/1825/101705 Wed,24 05 2006 04:55:16 In my work, I need to call a java web service with basic authentication. I searched on google and got http://mark.michaelis.net/Blog/CallingWebServicesUsingBasicAuthentication.aspx.As it was said, the process is like this:1, Add the web service reference2, Copy the web service reference.cs code to a class you added yourself.3, Drop the web service reference4，override the getwebrequest method and add the authentication header. http://whitechief.itpub.net/post/1825/84656 Fri,05 05 2006 04:28:24 我们在建立数据库的时候，需要为每张表指定一个主键，所谓主键就是能够唯一标识表中某一行的属性或属性组，一个表只能有一个主键，但可以有多个候选索引。 因为主键可以唯一标识某一行记录，所以可以确保执行数据更新、删除的时候不会出现张冠李戴的错误。当然，其它字段可以辅助我们在执行这些操作时消除共享冲 突，不过就不在这里讨论了。主键除了上述作用外，常常与外键构成参照完整性约束，防止出现数据不一致。所以数据库在设计时，主键起到了很重要的作用。常见的数据库主键选取方式有： 自动增长字段 手动增长字段 Uniq... http://whitechief.itpub.net/post/1825/75810 Thu,27 04 2006 04:35:45 A stored procedure + configure it to run when starting up + query it from analyzerCreate/Alter proc dbo.SecurityTraceasBegin Declare @TraceIdOut int Declare @On bit declare @ret int declare @status int declare @filename nvarchar(245) SET @On = 1 set @status = 1 set @filename = N'C:audit'+replace(convert(varchar(19),getdate(),126),':','') exec @ret=sp_trace_create @TraceIdOut OUTPUT, 6, @filename --select @TraceIdOut if @ret<>0 begin raiserror('Failed to create a trace',16,1) end exec sp_trace_se... http://whitechief.itpub.net/post/1825/75804 Thu,27 04 2006 02:23:21 1, Windows event log2, SQL Server Error log3, Use c2 audit optionEXEC sp_configure 'show advanced option', '1' RECONFIGURE EXEC sp_configure 'c2 audit mode',1RECONFIGURE 4, using the customized script As I mentioned earlier, whenever SQL Server restarts, all trace configuration information is lost and requires reentry—a time-consuming and problematic proposition. You need to reenter the commands necessary to enable tracing as soon as the server starts but before a user logs on. Listing 3... http://whitechief.itpub.net/post/1825/74115 Wed,26 04 2006 06:44:14 There is a support article for sql server 2000. http://support.microsoft.com/kb/842421/The commands for sql server 2005 are almost the same. The biggest difference is to add a new parameter: -i InstanceNameSo, the commands are like this:cd "C:Program FilesMicrosoftSQL Server90ToolsBinn"rskeymgmt /?rskeymgmt -e -i INST2005 -f swc -p 123456rskeymgmt -r installationid(to be replaced) -i INST2005rskeymgmt -a -i INST2005 -f swc -p 123456 http://whitechief.itpub.net/post/1825/70660 Thu,20 04 2006 07:06:24 select system_userselect current_user http://whitechief.itpub.net/post/1825/64430 Fri,31 03 2006 08:11:51 Some tips:1, Using the local windows accounts to be the roles of jobs instead of domain accounts.2, Using the client alias configuration tool and hosts file to cheat the system if it complaint "cannot use ip or server alias in replication" http://whitechief.itpub.net/post/1825/64429 Fri,31 03 2006 08:08:41 公司决定使用microsoft reporting service 2005. So I just installed one instance on my own machine. After the installation and configuration, it is runing well now.In a word, my feeling is that SSRS 2005 is still not so stable. I encountered many small problems that seemed very wierd. Because of time limit, I just uninstall it and reinstall it again and again. And finally, it works. The following is some points worthy of notice.1, The users cannot reach the reporting service website.Why: the windo... http://whitechief.itpub.net/post/1825/52834 Tue,14 02 2006 06:44:22