My problem is that the data source does could change precision without letting me know. The data store is quite large and I want to use the smallest...
I am writing a stored procedure that inserts data into a table. The data may change over time and I want to ensure that the procedure will fail at a...
To clarify: I understand that the XML datatype strips out the XML Declaration and white space. I am not trying to store that in the database; I just...
I am using BCP to export the contents of a column that has an XML datatype to an XML file. Everything is working fine except the XML file is missing...
Do any of the dynamic management views (DMV's) provide the current processor utilization percent like you would find in PerfMon?
Thank you for your quick response. I am aware of the <HTMLViewerStyleSheet> property that can be added to the config file and that does work fine if...
I am using Reporting Services 2005 and have created a custom stylesheet to be used with the HTML viewer via URL access, by adding the parameter...
Thanks! Just what I was looking for!
I have approximately 400 - 600 tables that need to have their filegroups changed on a new SQL 2005 installation. In 2000, I could go the table...
Jasper Smith's RS scripter looks like it may be our best solution. We are trialing the software now; and this is probably how we will transfer the...
We will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In...
I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very...
Separate names with a comma.