James

Reporting Services Subscriptions

2010-02-08T20:18:00.000Z

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.

2010-02-05T08:41:00.001Z

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

DFS - File Filters

2005-11-22T17:46:00.000Z

How to modify the file filters used by dfs.
Link

Microstation Clip To Boundary

2005-11-09T11:45:00.000Z

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

2005-11-09T10:54:00.000Z

V7:
wset add
wset drop

V8
ORDER ELEMENT FRONT

Troubleshooting SCECLI 1202 Events

2005-10-25T09:55:00.000+01:00

Link

Microstation V7/V8 Parallel Install

2005-09-21T13:21:00.000+01:00

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

2005-09-15T08:35:00.000+01:00

Link

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

2005-08-15T17:12:00.000+01:00

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

2005-06-13T17:53:00.000+01:00

Link

HP iPAQ h4150 Hard Reset

2005-06-07T10:30:00.000+01:00

Turn unit on whilst depressing reset switch.

Extract MSI files from EXE

2004-12-08T13:19:00.000Z

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

2004-12-01T11:03:00.000Z

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

2004-11-30T13:34:00.000Z

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

2004-11-25T11:55:00.000Z

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.

Access Denied, ASP.NET, Domain Controller, Identity Impersonate

2004-11-24T14:19:00.000Z

Access Denied, ASP.NET, Domain Controller, Identity Impersonate

If attempting to run an ASP.NET application from a web server which is also a domain controller you may encounter an 'Access Denied' error message, when the application uses indentity impersonation...

Magic File Renamer

2004-10-27T17:24:00.000+01:00

http://doodu.tripod.com/

Magic File Renamer...

Intranet site is identified as an Internet site when you use an FQDN or an IP address

2004-10-26T16:03:00.000+01:00

Intranet site is identified as an Internet site when you use an FQDN or an IP address

When attempting to open an access file using a FQDN it is incorrectly identified as an internet site.
http://support.microsoft.com/?id=303650

DCPROMO: failed to modify the necessary properties for machine account

2004-10-22T13:21:00.000+01:00

DCPROMO: failed to modify the necessary properties for machine account

Discussion Thread
Microsoft Article

SQL Server 2000 Operations Guide: Capacity Planning

2004-10-19T15:39:00.000+01:00

SQL Server 2000 Operations Guide: Capacity Planning

Link

Register DLL with Right-Click

2004-10-13T17:36:00.000+01:00

http://www.mydesktophelp.com/tips/t3.htm
This .REG file allows DLL/OCX files to be registered with a simple right-click.

Debug Stored Procedure: EXCEPTION_ACCESS_VIOLATION

2004-10-13T17:24:00.000+01:00

Debug Stored Procedure: EXCEPTION_ACCESS_VIOLATION

Link

asp:textbox format

2004-10-13T11:29:00.000+01:00

You cannot include DataFormatString in an asp:textbox like you can an asp:boundcolumn. However, you can format it in the binding expression as shown in the link:
DataBinder.Eval(Container, "DataItem.DateRequired", "{0:d}")

SQL Parameter Possibly Null

2004-10-13T10:19:00.000+01:00

I needed to include a date column in my datagrid which could possible be null. I therefore had to insert null, or the value entered by the user if appropriate. I wrote a small function which created the parameter:

Function CreateSQLDateParam(ByRef Name As String, ByRef Val As String) As SqlParameter
Dim SQL_P As SqlParameter
SQL_P = New SqlParameter(Name, SqlDbType.DateTime)
If Val <> "" Then
SQL_P.Value = CDate(Val)
Else
SQL_P.Value = DBNull.Value
End If
Return SQL_P
End Function

Setting DataGrid Textbox

2004-10-13T09:42:00.001+01:00

Setting DataGrid Textbox to current date by default.

I needed to set a textbox control within a datagrid footer to display the current date by default. This is the solution I found after a little research. I used the DataGrid_ItemCreated event:

Private Sub DataGrid_ItemCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid.ItemCreated
Dim strTemp As String = "TextBox"
Dim temptext As TextBox
temptext = e.Item.FindControl(strTemp)
If Not temptext Is Nothing Then
temptext.Text = Date.Today
End If
End Sub