Many many thanks!

I was starting to get into dynamic sql and char(39)'s...

Havn't tested yet, but will this also work with apostrophes in the file name, E.g. "I'll be watching.mp3"

Hi,

Thanks for the reply.

The filename has embedded spaces in some cases, hence the double quotes around the filename only

Lynn,

Table as follows and sample data attached

USE [ISAlogs]

GO

/****** Object: Table [dbo].[WebProxyLog] Script Date: 03/18/2010 16:02:00 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[WebProxyLog](

[ClientIP] [bigint] NOT...

Many thanks Tim & SteveB

1) Initial issue migrating 2005 Reporting services DB's to 2008

2) Googled the issue - seems I need to upgrade my existing 2008 Standard to Enterprise edition BEFORE moving SSRS to...

Hi,

Basically need to upgrade my existing SQL 2008 Standard edition to Enterprise edition.

I came across the Upgrade the Edition for SQL 2008 and this seems like the right place to...