Error:
TITLE: Object Explorer
------------------------------
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
------------------------------
BUTTONS:
OK
------------------------------
Fix: Install SQLServer2005_BC & SQLServer2005_DTS softwares from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988
If you are still not able to get it working. Please follow the below steps:
The issue was with PATH environment variable setting.
After changing the order in the path setting it got resolved.
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
Incase of 64 bit machine:
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;
Be sure to restart the SSMS after changing the PATH env variable
Friday, November 4, 2011
Monday, October 11, 2010
TSQL Currently logged windows user name
SYSTEM_USER
Example:
DECLARE @sys_usr char(30)
SET @sys_usr = SYSTEM_USER
SELECT 'The current system user is: '+ @sys_usr
GO
Example:
DECLARE @sys_usr char(30)
SET @sys_usr = SYSTEM_USER
SELECT 'The current system user is: '+ @sys_usr
GO
Sunday, October 10, 2010
Your Current Security Settings Do Not Allow This File To Be Downloaded
Through trial and error, I found that in addition to enabling "File Download" (Tools > Internet Options > Security (tab) > Internet > Custom Level > Downloads >> File Download) you also have to Enable (or set to Prompt) these other two options:
"Launching applications and unsafe files" and
"Launching programs and files in an IFRAME" (this one is only needed if your download occurs in an IFrame),
These 2 options are found under the "Miscellaneous" subsection, on the same settings screen as the "File Download" option.
After making these changes, I was then able to download files from sites, without having to put them into the "Trusted Sites" zone.
Hope this helps/works for others.
"Launching applications and unsafe files" and
"Launching programs and files in an IFRAME" (this one is only needed if your download occurs in an IFrame),
These 2 options are found under the "Miscellaneous" subsection, on the same settings screen as the "File Download" option.
After making these changes, I was then able to download files from sites, without having to put them into the "Trusted Sites" zone.
Hope this helps/works for others.
Thursday, September 30, 2010
Thursday, September 23, 2010
'xp_cmdshell' does not exist
In order to configure xp_cmdshell, first need to enable the advanced options and then only all the advanced configuration options works out.
It can be done as follows:
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO
Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.
It can be done as follows:
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell',1
GO
RECONFIGURE
GO
Refer http://msdn.microsoft.com/en-us/library/ms189631.aspx for more options.
Wednesday, September 22, 2010
SSIS: Performance Tuning
http://www.simple-talk.com/sql/ssis/sql-server-2005-ssis-tuning-the-dataflow-task/
Subscribe to:
Posts (Atom)