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/
Tuesday, September 21, 2010
SSIS: [Send Mail Task] Error: Either the file "FileName" does not exist or you do not have permissions to access the file.
This is because when you create the file it put a lock on the file in SSIS.
Solution: Close the file using FileStream.Close() method.
FileStream File1 = new FileStream("C:\Text1.txt", FileMode.Create);
File1.Close();
Solution: Close the file using FileStream.Close() method.
FileStream File1 = new FileStream("C:\Text1.txt", FileMode.Create);
File1.Close();
Monday, September 20, 2010
SharePoint: Deactivated users are still showing up in Staff Directory.
Deactivated users are still showing up in Staff Directory.
1. On the Site Settings page of the portal site, on the User Profile, Audiences, and Personal Sites page, click Manage profile database.
2. On the Manage Profile Database page, click Configure profile import.
3. On the Configure Profile Import page, in the Source area, click Custom source.
4. Click OK.
5. On the Manage Connections page, do one of the following as appropriate to your situation:
o Click the name of the domain that you want to edit, and then click Edit.
-or-
o Click New connection to add a new domain controller that contains the user profiles that you want to import.
.
6. On the Edit Connection or Add Connection page (as appropriate to your situation), in the Search Settings area, do the following:
a. In the Search base box, type the distinguished name (DN) of the Active Directory object from where you want to import the user profiles.
The DN of the search base object defines the location in Active Directory where you want to start your search. The following are examples of DNs:
DC=DomainName, DC=com
CN=Users, DC=DomainName, DC=com
OU=OrganizationalUnit, DC=DomainName, DC=com
b. In the User filter box, type the following LDAP search filter:
(&(objectCategory=person)(objectClass=user)( !(userAccountControl:1.2.840.113556.1.4.803:=2)))
c. Under Scope, specify the scope level, page size, and page time-out options that you want.
1. Click OK.
1. On the Site Settings page of the portal site, on the User Profile, Audiences, and Personal Sites page, click Manage profile database.
2. On the Manage Profile Database page, click Configure profile import.
3. On the Configure Profile Import page, in the Source area, click Custom source.
4. Click OK.
5. On the Manage Connections page, do one of the following as appropriate to your situation:
o Click the name of the domain that you want to edit, and then click Edit.
-or-
o Click New connection to add a new domain controller that contains the user profiles that you want to import.
.
6. On the Edit Connection or Add Connection page (as appropriate to your situation), in the Search Settings area, do the following:
a. In the Search base box, type the distinguished name (DN) of the Active Directory object from where you want to import the user profiles.
The DN of the search base object defines the location in Active Directory where you want to start your search. The following are examples of DNs:
DC=DomainName, DC=com
CN=Users, DC=DomainName, DC=com
OU=OrganizationalUnit, DC=DomainName, DC=com
b. In the User filter box, type the following LDAP search filter:
(&(objectCategory=person)(objectClass=user)( !(userAccountControl:1.2.840.113556.1.4.803:=2)))
c. Under Scope, specify the scope level, page size, and page time-out options that you want.
1. Click OK.
CRM : An error occurred while promoting a Microsoft CRM e-mail message
Attachment of size bigger than 8 mb are not allowed to be tracked in CRM 4.0
Work Arounds:
You need to change the
following 2 lines in your web.config file to increase the size beyond 8MB
1.
This maxRequestLength determines the size of files being attached in CRM as
well as adjusting the size in the Settings area.
2.
This second maxRequestLength line determines the size of email attachments
that can get tracked when users press track in Outlook.
Note:
Editing web.config did not resolve the issue, but when I changed the 'Maximum
file size' value in Settings>System Settings>E-Mail tab it worked.
Location of web.config: c:\INetpub\www
Work Arounds:
You need to change the
following 2 lines in your web.config file to increase the size beyond 8MB
1.
This maxRequestLength determines the size of files being attached in CRM as
well as adjusting the size in the Settings area.
2.
This second maxRequestLength line determines the size of email attachments
that can get tracked when users press track in Outlook.
Note:
Editing web.config did not resolve the issue, but when I changed the 'Maximum
file size' value in Settings>System Settings>E-Mail tab it worked.
Location of web.config: c:\INetpub\www
SQL : Database cannot be opened due to inaccessible files or insufficient memory or disk space
STEP1: identify the db status:
use master
select databaseproperty(‘db_name’,'isShutdown’)
Most of them it would return 1 in this situation
STEP2: Clear up the internal db status:
use master
alter database db_name set offline
it would return with no error in most cases
STEP3: Get detail error message:
use master
alter database db_name set online
After step3, sql server will first verify the log file, if the log file is okay, it will verify the rest of the data file(s). Most of time it is because of the file location or file properties setting. For example if it is file location issue:
alter database db_name
modify (file=’logical name’, filename=’physical name’)
go
use master
select databaseproperty(‘db_name’,'isShutdown’)
Most of them it would return 1 in this situation
STEP2: Clear up the internal db status:
use master
alter database db_name set offline
it would return with no error in most cases
STEP3: Get detail error message:
use master
alter database db_name set online
After step3, sql server will first verify the log file, if the log file is okay, it will verify the rest of the data file(s). Most of time it is because of the file location or file properties setting. For example if it is file location issue:
alter database db_name
modify (file=’logical name’, filename=’physical name’)
go
SQL : SQL Timeout from Management Studio
I get the message - "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" - when working with large tables in Management Studio.
If you change the Execution time-out you need to open a new query over a new connection:
File -> New -> Database Engine Query
Instead of changing the execution time-out through Tools -> Options you should be able to specify it when opening the first query/connection to a SQL Server in the "Connect to Database Engine" dialog box:
Options -> Execution time-out.
If you change the Execution time-out you need to open a new query over a new connection:
File -> New -> Database Engine Query
Instead of changing the execution time-out through Tools -> Options you should be able to specify it when opening the first query/connection to a SQL Server in the "Connect to Database Engine" dialog box:
Options -> Execution time-out.
SQL Server : Transaction Log Full
USE DatabaseName
GO
DBCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY
DBCC SHRINKFILE(, 1)
GO
GO
DBCC SHRINKFILE(
BACKUP LOG
DBCC SHRINKFILE(
GO
SQL : SQL Timeout Firewall Issue
Everytime after the Server updates, it resets the Firewall option to ON and which causes anyone to connect to SQL.
Go to Control Panel -> Firewall -> Set it to Off.
Go to Control Panel -> Firewall -> Set it to Off.
CRM : Creating Replica of Existing Organization
1. Create new organization
2. Create all new user accounts
3. Create a new “Account” with name “Org User”
4. Import the customizations
5. Import the data for Species
6. Create new Subject lists for abuse types
7. **Confirm everything**
8. Publish the Customizations
9. **Test**
10. Register the plugin.
2. Create all new user accounts
3. Create a new “Account” with name “Org User”
4. Import the customizations
5. Import the data for Species
6. Create new Subject lists for abuse types
7. **Confirm everything**
8. Publish the Customizations
9. **Test**
10. Register the plugin.
CRM : Outlook installation on Exchange Server 2003 issue.
“Microsoft Dynamics CRM for Outlook cannot be installed on a computer where Microsoft Exchange Server versions prior to Exchange Server 2007 are installed.”
Fix:
1. Open registry editor.
2. Export everything under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Exchange key.
3. Delete the key.
4. Install CRM client and then re-import the key back in.
Fix:
1. Open registry editor.
2. Export everything under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Exchange key.
3. Delete the key.
4. Install CRM client and then re-import the key back in.
HTML : Striketrhough
To place text onto your site that appears to be crossed out, we use the tag.
Hello
Hello
Hello
SQL Server: Changing from Single User Mode to Multiple User Mode
select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = 'databasename'
go
kill 64
go
EXEC sp_dboption 'databasename', 'single user', 'false'
from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid
where d.name = 'databasename'
go
kill 64
go
EXEC sp_dboption 'databasename', 'single user', 'false'
Subscribe to:
Posts (Atom)
