Hello,
We are doing some maintenance on a small business sever and need to know how
to determine if sp4 for sql server 2k has been installed.
Is there a way to make this determination using tsql?
Thanks,
RichOn Wed, 15 Feb 2006 17:28:16 -0800, "Rich"
<Rich@.discussions.microsoft.com> wrote:
>Hello,
>We are doing some maintenance on a small business sever and need to know ho
w
>to determine if sp4 for sql server 2k has been installed.
>Is there a way to make this determination using tsql?
>Thanks,
>Rich
SELECT @.@.version
then compare results to:
http://support.microsoft.com/defaul...b;en-us;q321185
Roy|||SELECT SERVERPROPERTY('ProductLevel') will return 'SP4' if installed. Also
SELECT @.@.VERSION will include '8.00.2039' (or higher build with hotfixes).
Hope this helps.
Dan Guzman
SQL Server MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A30FCB02-59CF-4098-AB0C-FDB9429D7241@.microsoft.com...
> Hello,
> We are doing some maintenance on a small business sever and need to know
> how
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich|||SELECT @.@.VERSION
SP4 = 8.00.2039
(but you should have the hotfix 2040 at least)
Some links:
http://www.aspfaq.com/2160
http://www.aspfaq.com/2543
http://www.aspfaq.com/sql2000builds.asp
http://support.microsoft.com/kb/899761
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:A30FCB02-59CF-4098-AB0C-FDB9429D7241@.microsoft.com...
> Hello,
> We are doing some maintenance on a small business sever and need to know
> how
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich|||Thanks all for your replies. THat gave us the information we needed.
"Rich" wrote:
> Hello,
> We are doing some maintenance on a small business sever and need to know h
ow
> to determine if sp4 for sql server 2k has been installed.
> Is there a way to make this determination using tsql?
> Thanks,
> Rich
Showing posts with label business. Show all posts
Showing posts with label business. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
How to deploy Semantic Models manually?
Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:
"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.
A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,
I figured it out myself....
The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.
After that, you need to remove all the attributes of the Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work. xmlns:xsi="RelationalDataSourceView" The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component. R None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.
|||This has to be done manually with cutting and pasting? Is there an easier way?
|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">
|||
How to deploy Semantic Models manually?
Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:
"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.
A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,
I figured it out myself....
The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.
After that, you need to remove all the attributes of the Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work. xmlns:xsi="RelationalDataSourceView" The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component. R None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.
|||This has to be done manually with cutting and pasting? Is there an easier way?
|||Your xsi syntax is slightly incorrect. The valid attribute syntax is:
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">
|||
How to deploy Semantic Models manually?
Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:
"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.
A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,
I figured it out myself....
The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.
After that, you need to remove all the attributes of the Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.|||This has to be done manually with cutting and pasting? Is there an easier way?|||Your xsi syntax is slightly incorrect. The valid attribute syntax is: xmlns:xsi="RelationalDataSourceView" The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component. R None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">|||
How to deploy Semantic Models manually?
Using SQL Server 2005 Business Intelligence Studio, I created a Data Source (Test.ds), Data Source View (Test.dsv), and a Report Model (Test.smdl). It is very easy to deploy this model into a Report Server, from the Business Intelligence Studio, by right clicking the Report Model Project and choosing 'Deploy'.
But how do you deploy a model file manually to the Reports Server?
When I use 'Upload File' option in Reports Manager and choose the semantic model file (Test.smdl), it gives the following error:
"The DataSourceView is missing for the SemanticModel. SemanticModel must have exactly one DataSourceView element. (MissingDataSourceView) "I tried uploading ds and dsv and also tried merging dsv xml content into smdl. But didn't work.
A reply with how to include DataSourceView element into the model file, will be highly appreciated.Hi All,
I figured it out myself....
The report model file is an xml file containing information about the model in a language called ‘Semantic Model Definition Language’. Data source view file is also in xml format. You need to take the whole contents of the data source view (*.dsv) xml file and put it into the model file exactly after the ‘Entities’ node, ie, just before the closing tag of semantic model.
After that, you need to remove all the attributes of the Now you can safely upload this model file to the Report Server using Report Manager and then associate a data source to make it work.|||This has to be done manually with cutting and pasting? Is there an easier way?|||Your xsi syntax is slightly incorrect. The valid attribute syntax is: xmlns:xsi="RelationalDataSourceView" The tool that helps me out is located at http://www.sqldbatips.com/showarticle.asp?ID=62. It creates the scripts and you can tweak them to do single deployments for any model component. R None of this is working. when i try to save the model it asks me to save twice. then when i go back to smdl file i dont the changes, i see the old smdl that i had before pasting the datasourview node.
<DataSourceView xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsi="RelationalDataSourceView">|||
Subscribe to:
Posts (Atom)