Viewing 15 posts - 76 through 90 (of 139 total)
Vivien Xing (11/6/2008)
2. You can use snapshot of the mirrored database for reporting purpose or R/O.
But if we want the secondary(mirrored db) which will be read only to be used...
November 7, 2008 at 8:57 am
Jack Corbett (10/20/2008)
October 20, 2008 at 9:36 am
MANU (10/3/2008)
October 5, 2008 at 6:16 am
MANU (10/3/2008)
October 5, 2008 at 6:08 am
steve smith (9/25/2008)
1. Data is stored in tables.
2. Views display data stored in tables.
How do you intend to 'replicate' (not 'remotely...
September 25, 2008 at 2:07 pm
Thanks for the reply. Per the properties of the SSIS package, the full path of the package shows as "C:\SSISpackage\package1.dtsx", so based on this I think the package is getting...
September 24, 2008 at 7:34 am
I do'nt remember what mode was selected during the installation. Usually what mode do we have to select while installing sql 2005? So that I shall be careful in selecting...
September 17, 2008 at 3:05 pm
No it's not the same values, one has the follow:
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fswiss\fprq2\fcharset128 Arial Unicode MS;}{\f2\fnil\fcharset0 Microsoft Sans Serif;}} {\colortbl ;\red0\green0\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\b\f0\fs20 Mechanical \b0\f1\par \f0\fs18\line Department \par \par...
September 2, 2008 at 1:36 pm
This is what I am trying to do:
IF order EXISTS in the orders table
Begin
Insert that order into DuplicateOrders table
End
Else --Not existing in orders table, new order
Check if the...
August 27, 2008 at 8:20 pm
SrikanthSv (8/11/2008)
so add this tag in the connection string value
it'll be like
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.xls;Extended Properties=Excel...
August 11, 2008 at 3:55 pm
SrikanthSv (8/11/2008)
Use IMEX =1 in the connection property string of the excel connectionthat'll set the mode to import and all the values will be populated.
Please let me know where I...
August 11, 2008 at 3:32 pm
Thanks for your response, actually we have a user's table in the database, whenever a new user wants to get access to that web application that user will be added...
August 1, 2008 at 7:14 am
I am sorry for not being clear. I need to know about disaster recovery. Actually we have clustered servers for all our applications. Our networking team is taking care of...
July 29, 2008 at 11:35 am
Steve Jones - Editor (6/2/2008)
The data from SQL Server can be easily exported using DTS or...
June 3, 2008 at 2:36 pm
Viewing 15 posts - 76 through 90 (of 139 total)