Reporting Services Subscriptions

We recently migrated from Reporting Services 2000 to 2008 using the excellent (and free!) Reporting Services Scripter. However, it did not migrate the subscriptions. This leads to a problem: There is no way within the front end to tell what reports have subscriptions against them, especially if the subscriptions have been created by multiple people.

I therefore wrote the following SQL to get a list of subscriptions. The number of subscriptions returned was fairly low (30), so I could then manually recreate them on the new server.



select
     c.path ReportPath,
     c.name ReportName,
     u.UserName,
     s.*
from reportserver.dbo.Subscriptions s
inner join reportserver.dbo.users u
     on s.ownerid = u.userid
inner join reportserver.dbo.catalog c
     on s.report_oid = c.ItemID
order by
     c.path

The partition scheme "" is currently being used to partition one or more tables.

Couldnt drop rogue Partition Scheme due to rogue indexes.

Indexes were not visible through SSMS, but sp_help ‘tablename’ revealed a number of additional indexes, which were based on the partition scheme.

Drop the indexes using DROP INDEX, and rerun sp_help ‘tablename’. This should confirm there are no objects linked to the rogue partition schemes. The rogue partition schemes can then be dropped using DROP PARTITION SCHEME, before dropping the partition functions using DROP PARTITION FUNCTION.

To summarise:

Sp_help ‘tablename’

DROP INDEX IndexName ON TableName for all rogue indexes.

DROP PARTITION SCHEME PartitionScheme

DROP PARTITION FUNCTION PartitionFunction

DROP PARTITION FUNCTION PartitionFunction

DFS - File Filters

How to modify the file filters used by dfs.
Link

Microstation Clip To Boundary

To clip the reference files outside a specified area:

Place a fence.
Select File, References
Select all reference files
Select Tools, Clip To Boundary.

Microstation Bring To Front

V7:
wset add
wset drop

V8
ORDER ELEMENT FRONT

Troubleshooting SCECLI 1202 Events

Link

Microstation V7/V8 Parallel Install

Error: version mismatch. Program=(7.1.1.57). Resource File=(8.5.0.64)

C:\Program Files\Bentley\Program\MicroStation\ustation.rsc
Cannot find the resource file, microstation shutdown!

Drop Article From Publication With Subscribers

Link

Inno 3D 128MB GeForce FX5200 8xAGP TV-Out

Review
According to most reviews etc, this card comes with a large passive heatsink. However, the model I received came with a small, cheap looking fan which worried me greatly as I want this for a MCE PC. When I plugged it into my PC and turned it on I was pleasantly surprised. I tested it in a near silent HP box, and it is completely inaudible so the fan must be very quiet (I would guess <25db).

I was expecting the card to have a standard VGA output and an S-video out, with a composite converter. It actually had a composite port built into the card in addition to the above, which is a nice feature. Unfortunately, the quality of the composite output is quite poor and the NVIDIA flicker filter (which blurs things) needs to be turned up.

Performance is pretty good for a budget card on my ageing P4 2.0 Wilamette with PC133 ram. I got a 3DMark2001SE score of 4200-5200 compared to a score of 7200 when using a Radeon 9700Pro on the same machine. Interestingly, the score for both cards does not vary with resolution, which suggests the PC itself is the bottleneck (probably the memory). I tested it on FS2004 and with the settings at medium-high (capped at 50fps) it ran brilliantly, averaging above 30fps. It even runs adequately with AA turned on.

For MCE use it seems to fit my needs perfectly. It is very quiet, and on my machine live TV requires approx 25% CPU utilization compared to 30% for the Radeon 9700Pro. I am not sure why the utilisation is lower with the FX, unless it has something to do with the hardware mpeg decoding.

As noted above the composite output is pretty poor and lots of flickering can be seen without the flicker filter. I found the colour balance incredibly hard to setup, but perhaps I was just being fussy. Fortunately, the S-video output is completely the opposite. Images are very sharp with no flicker, and much better colour balance (I needed to make no adjustments).

In summary, this is a great MCE card, and easily fulfils my requirements for playing FS2004 on reasonably high settings with an ageing PC.

VS.NET 2003 Not Incrementing Build Number

Link

HP iPAQ h4150 Hard Reset

Turn unit on whilst depressing reset switch.

Extract MSI files from EXE

Most applications come packaged as a single EXE file which contains the MSI & CAB files. In order to deploy these applications using Group policy the individual files need to be extracted:

To extract:
file.exe /t::\Folder /c

You can also apply updates to existing applications. Firstly extract the msp file as above.

To patch:
msiexec /a msifile.msi /p mspfile.msp


N.B. In the case of a number of applications (such as office) you first need to create an administrative installation point by running setup with the '/a' switch.

In the case of office further customization can be performed by using the office resource kit, available at link.

ASP.NET, Datagrid, Textbox, Formatting

Link

I used the above link & created a single formatting function which replaced certain characters (such as vbcrlf) with their HTML equivilents. This was placed in a standard module.

Function ConvertToHTML(ByVal arg As Object) As String
Dim strTemp As String
strTemp = Replace(arg, vbCrLf, "BR")
Return strTemp
End Function

The databinding for the label control (the control which displays the data rather than editing it) was then modified from:
DataBinder.Eval(Container, "DataItem.TaskComments") to ConvertToHTML(DataBinder.Eval(Container, "DataItem.TaskComments"))

The aspx page cannot read a module function, producing the error 'Function not declared'. The solution to this was to create a wrapper function in the code behind page.

Public Function ConvertToHTML(ByVal arg As Object) As String
Return modFunctions.ConvertToHTML(arg)
End Function

SQL Mail: EXCEPTION_ACCESS_VIOLATION

Link

This appears to be a problem with later versions of SQL Mail (SP2, SP3). Try reverting to the SP1 release of sqlmap70.dll. This might solve the problem.

IBM x-series Server Will Not Boot From CD

If the integral CDROM drive is configured as a slave drive in this machine, it will not be able to boot from a CD. It must be the master drive in order to boot.