Browse by Tags

Sql Server - Outputting a table as an xml File

I had a need to do this recently and came across the following sql which you can run in analyser select * from tablename for XML RAW, ROOT ('root'), ELEMENTS XSINIL This will output your table and contents as XML within a single result and you just need to put this into an xml file. Hopefully...

Posted to Sql Server (Weblog) by Steve on 11-24-2009
Microsoft.ReportingServices.RsProxy.AccessDeniedException

I Came across this error message (Exception of type 'Microsoft.ReportingServices.RsProxy.AccessDeniedException' was thrown. ) today whilst installing SQL Server 2005 Reporting Services on a windows 2003 server thought i'd share the answer for anybody else search as there wasn't much on...

Posted to Sql Server (Weblog) by Steve on 02-05-2008
Sql Report services date picker problems - rsReportParameterTypeMismatch

If your having problems with your date picker switching date format on your reports this could well be the solutions. I was having problems whereas the first load of the page the date format was in American (MM/DD/YYYY) after a successful postback it was then english. This was obviously irratating. Seems...

Posted to Sql Server (Weblog) by Steve on 02-05-2008

Page 1 of 1 (3 items)

DotNetDeveloper