22 Haziran 2012 Cuma

How to run big sql files

To be  able to run big sql files you can use sqlcmd.exe
which is located on:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn

Example
SQLCMD -S SERVERNAME\INSTANCE -P Password -U Username -i C:\sample.sql -o C:\output.txt

For SQL 2014 the directory of sqlcmd.exe has changed:
<INSTALL DIRECTORY> \Client SDK\ODBC\110\Tools\Binn

21 Haziran 2012 Perşembe

Reinstall a WSP Package in Sharepoint 2010

Steps:
1. Retract
2. Delete Solution
3. Add Solution
4.Deploy Solution

1.Retract:
Go To Central Admin - System Settings - Manage Farm Solutions - Select and Retract the solution

2.Delete Solution:
Open PowerShell as Admin
Type
Remove-SPSolution –Identity YOUR_WSP_NAME.wsp

3.Add Solution:
Open 14 hive in cmd
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14
Run command:
stsadm.exe -o addsolution -filename D:\YOUR_WSP_NAME.wsp

4. Deploy Solution:
Go To Central Admin - System Settings - Manage Farm Solutions - Select and Deploy solution