My cube has 12 monthly partitions. After it processed a few partitions, I got the error: "Memory error: Allocation failure: Not enough storage to...
Thanks for the good recommendation!
One of my SQL users needs to run DBCC traceon command. That command requires sysadmin permission to run. But I do NOT want to grant this user as...
On previous SQL 2000 server I can easily estimate the total space used and the percentage of free space left in each database file by right click...
Thanks for all of your help!
I run DBCC Shrinkfile command on my SQL 2005 server. Does DBCC shrinkfile requires OS resources, such as memory, CPU usage? How much does it cost?...
I run sp_who2 to check SQL server 2005 activities. I find some SPID with Status=SUSPENDED. What does this mean? Thanks for help! George
A user in my team created a report by using Report Services 2005 from "Business Intelligence Developer Studio" tool. When he tried to "Deploy Report...
This is AS2000 with SP4 installed. Still keep getting the error from the server event viewer: "The MSSQLServerOLAPService service terminated...
My Analysis service 2000 used work fine. But recent days it generates lots SQLDmpr###.mdmp files. What are they? My process cube takes much long time...
Thanks for the feedbacks. I went back to try the install client components. I was able to select Client Tools which contain "Management Studio",...
merrillaldrich; You have good exapmle on the trouble situation. Looks like it is needed to perform significant tests before upgrade to SQL 2005 from...
I have SQL Server 2005 installed on my XP desktop. The installation went smooth. But after it completed, I can not see "Management Studio", "Business...
I am not able to start SQL Server 2005 Agent Service. Current I have SP2 installed. The error message shows: "SQLAgent$SQL2005 service started and...
Thanks for recommendations!
I have SQL Server 2005 Trial version installed on my XP desktop. Now I receive SQL Server 2005 Developer Edition CD (legal one). Do I have to...
Are there any articles to direct me to create a SQL job which can execute SSIS package on SQL server 2005? By the way, on SQL server 2000 I use...
Is it possible to browse SQL 2005 SSAS cube byhttp:// ? If yes, how to do it? Thanks, George
Hi, I create a report by using Visual Studio. When I tried to "deploy report", I got the error: "Deploying tohttp://server01/ReportServer Error...
When I tried to accesshttp://localhost/Reports from my server, I got error: 'rsReportServerDatabaseUnavailable'. How can I fix this issue to access...
Separate names with a comma.
