Viewing 15 posts - 241 through 255 (of 492 total)
Feature: Database Engine Services
Status: Failed: see logs for details
Feature: SQL Server Replication
Status: Failed: see logs for details
Feature: Full-Text Search
Status: Failed: see logs for...
May 13, 2011 at 8:33 am
If you have required only columns information then you can use this also
SET FMTONLY ON
GO
Select * from [linkedServer].[databaseName].[schema].[tableName]
May 13, 2011 at 5:12 am
INSERT INTO TAB1 values('Jahanzaib','Pakistan')
GO 400000
INSERT INTO TAB1 values('Colin Roberts','UK')
GO 400000
INSERT INTO TAB1 values('Binary','South Africa')
GO 100000
INSERT INTO TAB1 values('SuperMan','USA')
GO 100000
that is an example to load the dummy data just execute it...
May 13, 2011 at 5:06 am
Check the properties of the Linked Server as mentioned by the Deepak and shown in the attachment
May 13, 2011 at 4:54 am
Excluding database files from the anti-virus is common others stuff is to restrict extra processes ,application,access on database files folder to other users and ports with the help of anti-virus...
May 13, 2011 at 4:49 am
If you can use Replication then go to this because linked server have performance issue always because network will involve and you will fetch whole data from the Server A...
May 13, 2011 at 4:44 am
.net framework will be install with the SQL Server 2008 R2 setup,you have to install VS 2008 SP1 if available on this server and update windows Installer 4.5
May 13, 2011 at 4:33 am
the obvious danger of adding all those certifications after your signature is you put yourself up for a fall.. I can only assume you've never used a log shipped standby...
May 13, 2011 at 4:20 am
Microsoft support Active/Active Cluster but what does it mean active/active,its for multiple instance on a cluster and there is no any type of load balancing
May 13, 2011 at 4:05 am
owner of the job ?
job history error ?
May 12, 2011 at 8:37 am
you can create the ODBC DSN connection and then create a linked Server with it
check the information regarding PROTOCOLS
May 11, 2011 at 11:48 pm
Editor: Post removed as it promotes copyright infringement.
May 11, 2011 at 5:59 am
Apply first the Service Pack 2 if this is not R2 and apply CU 7 if this is R2,this problem has resolved in these updates
SQL Server 2008 R2 Service Pack...
May 11, 2011 at 5:57 am
There is no any term like Database Partitioning ,the correct term is Table partitioning and Index partitioning
http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx
visit on the link for further clarification
May 11, 2011 at 5:39 am
Viewing 15 posts - 241 through 255 (of 492 total)