View Complete Post
If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.
MSDN Magazine July 2009
From a developer's perspective, once a database's schema has been defined and the tables, stored procedures, and other database objects have been created, it can be forgotten, abstracted away into the data access layer of the application's architecture.
MSDN Magazine May 2006
I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool
<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of 'xyz_old' does not exi
st in the server with the ID of 'ABCD\Sql_AS', or the user doe
s not have permissions to access the object." Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>
I have tried using different account for impersonation but everything fails.
Any help would be really appreciated.
I have a SharePoint 2007 database that is 16GB in size and I want to know why, and how I can reduce the size. Ideally I would like a trimmed replica to use as a developer workstation that retains a good sample data set, and has the ability to be
Can you please tell me if there are any third party tools or other methods to accomplish this? I have found the Microsoft tool (stsadm) to be very limited in this regard.
I have a problem with deploying SQL Analysis database from dev server to production , because I do not have an admin privileges , I cannot use Create script
The only action that I have , is to execute Alter Script against Any Empty database,
However I cannot use ImpersonateServiceAccount because it needs Admin privileges
So, I always use ImpersonateCurrentUser
as you know, I have to supply my credential.
are there any way that I can Deploy the db to the production with the same impersonation type
as it was before?
I have some problem here..
I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..
does anybody have the script to attach the database?
Many thanks and regards...
I am not able to connect oracle database from MS-Analysis Services.
All my Fact tables and Dimension tables are residing on Oracle database.Both the Oracle database and MS Analysis Services are on the same server.
I am working on the node and I was able to create the datasource using "Microsoft OLE DB Provider for Oracle " and the test connection also succedded but while creating the cubes using the cube wizard it throws error saying " Connection to the data source Failed".
Any one could help me in this regards.
What are the ways to connect the oracle DB from MS Analysis Services.
Is this problem becoz of any permission settings, how do I give permissions for the users.
At present, I am facing a typical while processing a cube. In my package, I am processing all the dimensions and cubes through Analysis services task of the package. Now, I took the backup of the Current
Analysis services database and restored it with other name and I changed the Analysis Services Connection in the package also. But, While running the pakcage, still the package is pointing to the old Analysis services databases only and it is updating all
the dimensions and cubes of that database.
Please help me on this to proceed further.
I' using SQL server 2008 R2 with merge replication. Suudenly if I tray to start Generate scripts tool to generate scripts for view, functions and sp's on one database generation of scripts block on Getting the list of objects in 'database' faze.
This faze run indefinitly and listing of object and generation of scripts don't take place.
Database has more then 1600 merge articles.
Thanks in advanced.
I am making a project on Data Mining, I am using the Office 2007 Excel, SQL server as a sample mining tool, i have practiced and understood using Adventure works database , but i NEED a different Database so as to connect it to analysis service and demonstrate
data mining using excel in my own project, WHAT AND HOW DO I GO ABOUT IT?
Could somebody recomend me good tool for autofilling of SQL Server 2005 database? Open source is desirable.