This works perfectly in a SSMS 2008 query window:
use [HSS Maintenance]
exec HSS_Guest.[olap storedprocedure]
exec HSS_Guest.[MAKE OLAP_CUBE]
但是,当我通过使用“Start工作站”来进行“紧急工作”时,它总是失败的。
我尝试了操作系统(CmdExec)“Type”以及T-SQL,甚至SSAS I。
我是否曾问过一个Syntax问题,或者没有使用正确的“Type”?
充分利用企业版和软件; 服务器2008年。
我已将此谷歌化为死亡,并不认为我只能通过全球倡议来这样做。
请向我介绍一下我是如何umb的。
注——我试图从工作窗口中产生文字,并出现一个错误,即“没有行动要证明”
• 担任服务器的代理职务,其中含有你所贴有的密码。 删除“使用[HSS 维护]”线,而是在选择这一数据库的步骤上采用下降的菜单。
I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...
TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...
I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. ...
Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...
I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...
I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
I m trying to transform the SQL Query below into Linq to SQL select Categorias.IdCategoria, Categorias.Nome, SUM(lancamentos.valor) from lancamentos left outer join Categorias on Lancamentos....