I ran into an issue the other day while importing data from an Excel file into SQL Server 2005. I had columns that contained fields that have more than 255 characters. When running the import, SSIS failed because it kept truncating the fields which caused the task to fail. It fails because the Microsoft Excel…

This is a great tip to enable remote desktop: 1. Open the registry editor: Start –> Run –> regedit –> OK 2. Select the Connect Network Registry option under the File menu and find the machine you want to connect to. 3. Goto this key: HKLM\SYSTEM\CurrentControlSet\Control\Terminal Server 4. Under the Terminal Server key, you’ll find…

Type ‘gpedit.msc’ at the command line Open this policy and click on ‘Disabled’ and then click ‘OK’. To force this changes instead of rebooting just open a command window and type: ‘gpupdate /f’ to force the changes.

To replace or insert a character at the end of any line: Find what: \n Replace with: [what ever you want]\n To insert a new line: Find what: [character to insert new line at] Replace with: \n To add characters to the beginning of each line: Find what: ^ Replace with: [whatever you want]^

Sometimes services are left behind when you uninstall a program. To remove that service, just open a command prompt window and type: sc delete [service name] If you know how to work with the registry you can delete the key here: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

Here’s a quick code snippet to search through all the stored procedures in a SQL Server database for a keyword: SELECT o.object_id, o.name, SQLM.Definition FROM sys.objects o LEFT OUTER JOIN sys.SQL_modules SQLM ON o.object_id = SQLM.object_id WHERE SQLM.definition LIKE ‘%incident%User2%’ AND o.type=’P’ ORDER BY o.name Just replace the ‘SQLM.definition LIKE’ with a keyword that you…