I am new to SQL Server and would like to know whether SQL server has built in optimization manager, in terms of Read and Write ?
View Complete Post
I need to install SQL Server Enterprise Manager to run with SQL Server 2008 to define the email settings which will help me to send email through transact sql. Can anyone any link from Microsoft to download ?
Also, Is there any other way to define settings for SQL Email which should not include any further installation with the current SQL Server 2008 ?
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 built a custom SSIS component for connecting to SQL Reporting Services in SSIS - including a custom data source and custom connection.
It works fine using 32bit DTEXEC and dtsdebughost, but I cannot get it to load in a 64bit environment.
Initialy I was compiling the dlls as MSIL (target=any), then I recompiled specifically targetting x64 (copying the dlls to the 64bit location and deploying to the GAC), just to see whether the problem was because of using an MSIL binary.
The 32bit version works as expected - are there any additional registration steps required for a 64bit Connection manager beyond copying to the /connections directory and installing into the GAC?
The output from DTSEXEC:
c:\Program Files\Microsoft SQL Server\90\DTS\Binn>DTExec.exe /f "e:\temp\SSISCus
tomADComponent\TestSSISSolution\Integration Services Project1\Package.dtsx"
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:07:30 p.m.
Error: 2010-09-22 12:07:43.89
Description: The connection type "SSRS" specified for connection manager "SQL
Server Reporting Services" is not recognized as a valid