COPYING ROWS FROM ONE TABLE IN A SERVER TO ANOTHER TABLE IN A SERVER

There can be situations where we need to copy a few rows from  Server S -> Database S -> Table S       (to)           Server D->Database D-> Table D This can happen when we have updated table with current values in our dev server that we need to move over to production.  The steps below describe the […]

SQL DataConnection in InfoPath forms: Part 1

We can set our InfoPath forms to receive SQL data. In order to do that we need have a A SharePoint library to hold our data connection files. Our list will use this data connection to retrieve rows from SQL DB. Its fairly straightforward to create a library in SP site. Go to your SharePoint […]

Copy data from one server to another server (SQL)

Scenario:  Server S -> Database S -> Table S       (to)           Server D->Database D-> Table D This can happen when we have updated table with current values in a Development/ Test server that we need to move over to production.  The steps below describe the T-SQL method of performing the move. –Step 1:set identity_insert DestinationTable on –Step […]

SharePoint 2010 installation on SQL 2012

Some links I found helpful in SP 2010 installation. Yes, its in french and you can translate it into english! http://www.gokanozcifci.be/subsite/how-to-install-SharePoint-2010.html Can’t install server farm using local account? heh…there is a workaround using powershell. It works. http://sharepoint.microsoft.com/blogs/fromthefield/lists/posts/post.aspx?id=112 This should get you running. http://social.technet.microsoft.com/wiki/contents/articles/9305.how-to-install-sharepoint-2010-with-sql-server-2012-on-windows-server-8-en-us.aspx NO? Install SP1, apparently its essential to counter “sp_dboption SQL procedure not found” […]

SQL Server 2012 vs MySQL statements

  SQL Server 2012 MySQL 5.5 1 use master;select  *  from sys.databases; show databases;   2 create database yourDatabaseName; Create database yourDatabaseName;   3 use yourDatabaseName; use yourDatabaseName;   4 select * from sys.tables; show tables;   5  create table yourTableName(     tablesPrimaryKey varchar(10) primary key, field1 varchar(10),field2 smallint, field3…. ); create table yourTableName( tablesPrimaryKey varchar(4) primary key, field2 varchar(10), field3 smallint(10),… ); 6 exec sp_help yourTableName; Describe yourTableName;   7 […]

Find out which version of SQL Server 2005 or 2008 is installed in the machine

So, blogging after a super long hibernation. Good to be back! I was trying to install SP3 for SQL Server 2005 and it kept failing on me. Got so frustrated until I found this nifty little query that does just that. Gives the version of SQL Server installed. 🙂 Here it is! SELECT @@VERSION GO […]