Viewing 15 posts - 61 through 75 (of 182 total)
Have you seen the sql error logs? Can you post it?
The files are in the install folder, within LOG folder, open them with notepad. The most recent is ERRORLOG.
February 23, 2007 at 1:49 pm
You have to give access to the reports. In the report manager, go to properties tab, there is a security section, add the users that will use the reports and...
February 22, 2007 at 4:44 pm
While the DROP is running, look in SP_WHO for a blocking process.
February 22, 2007 at 4:24 pm
Connect to your SSIS server where you want to copy the package, right click on MSDB or File System, and select Import Package, specify the server where the original package...
February 22, 2007 at 1:45 pm
The error is because of the second query, if you want to make changes to the data, you can update the table @G.
Also, you're missing a return at the end...
February 22, 2007 at 1:25 pm
You need to give access to dtproperties table and to all stored procedure that starts with dt_.
October 26, 2006 at 5:01 pm
You need SQL 2005 for running RS 2005 server, but for the data source you can access SQL 2000 with no problems.
February 23, 2006 at 1:26 pm
Check if you are added to the Olap Administrators group.
February 23, 2006 at 8:55 am
I think it's not created by default. You can create it with a type DWORD.
You can read more here: http://www.support.microsoft.com/default.aspx/kb/834419/en-us/
and here: http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp?frame=true&_r=1
February 23, 2006 at 8:14 am
By default, local administrators group are included as Olap Administrators. You can exclude Domain Admins from local administrators or, if you have SP4, you can modify the following key:
February 22, 2006 at 1:58 pm
From windows, you can expand a volume if you have more space on disk.
I've done this sometimes when we need more space, but I have the data on a...
December 2, 2005 at 1:58 pm
In this way you can call a DTS from a stored procedure:
http://www.databasejournal.com/features/mssql/article.php/1459181
From a DTS, just insert the Execute Package Task and configure it to run your DTS.
December 2, 2005 at 1:44 pm
En SQL2000 no existe una forma fácil de particionar la información. Lo que tienes que hacer es copiar los datos de la tabla principal a la tabla histórica y luego...
December 2, 2005 at 1:36 pm
Operations are not permited in the select clause, you have to create a new calculated member, something like this:
{ [Measures].[Calculated] }on columns
from
[myCube]
December 1, 2005 at 1:30 pm
When you run xp_cmdshell with a non sa account, it's executed in the context of the proxy account, so this account needs access to the objects.
From BOL, "xp_cmdshell":
November 24, 2005 at 4:02 pm
Viewing 15 posts - 61 through 75 (of 182 total)