If you want to recover this additional space taken, then check the db growth first (otherwise the space you recover may just get re allocated) I usually have this get...

There is but it's not a recommended approach as you need xp_cmdshell switched on etc. Also do you have Database mail activated? The best way is via SSIS, but you...

Try XML RAW, XML AUTO, XML EXPLICIT and XML PATH and google them..

Not too sure what you are saying in your post but an XML file is usually data which you want to import or export in and out of your database,...

I have found a crude method of archiving this...

SELECTLEFT(CONVERT(NVARCHAR, datWork_dtDate_Received, 107),3) + '-' + RIGHT(CONVERT(NVARCHAR, datWork_dtDate_Received, 107),2) As datWork_dtDate_Received

That worked perfectly! Thank you! Can't believe I didn't think of that!

Use udbEXTRACT

Go

SELECT sys.schemas.name AS SchemaName ,sys.all_objects.name AS TableName, sys.all_columns.name AS ColumnName, sys.extended_properties.name...

I tried the following as suggested, the code runs but I get results (properties info returned), I just get the column names defined and nothing else, even though the table...

This can be done, check the following link out...

http://blogs.msdn.com/tudortr

You can do this in 2005 but doesn't look as good as dundas, but at least its free, done in a similar way to conditional formating, you would have pictures...

You can't in short, not unless you set up a subscription to a report selecting xls as the output format and have it either email a user or email them...

You should be able too if you are using the dundas functionality... What options are available to you?

You can't in SSRS, the chart functions are just too limited, check out Dundas... You can download for evaluation:

http://www.dundas.com/

I believe that the parameters are ordered in the order they appear in the where clause...

Check out Dundas, it comes free in SQL 2008 but in 2005 costs, but really addresses the limitations of charts in SSRS.

http://www.dundas.com/

The only way this can be done (that I am aware of) is a very convoluted process changing the style sheets which is coded in xml and isn't an easy...