Viewing 15 posts - 76 through 90 (of 270 total)
You could try profiling the merge replication to gain a better insight into what is happening behind the scenes.
Paul
July 3, 2007 at 8:30 am
From Microsoft KB224071:
In SQL Server 2005 and in SQL Server 2000, you cannot detach system databases by using the sp_detach_db stored procedure. When you try to run the sp_detach_db 'model'...
May 18, 2007 at 9:59 am
If you are connecting to SQL Server 2005 remotely, you will need to enable this feature using the SQL Server 2005 Surface Area Configuration tool. Select "Surface Area Configuration for...
May 15, 2007 at 7:56 am
You can use the extended SP xp_cmdshell to execute DOS commands to perform file operations such as copy, delete and rename, etc.
Paul
May 15, 2007 at 7:46 am
Check that the user is not an administrator on the production server. If so, he can get access to your SQL Server as sysadmin through the BUILTIN\Adminstrators account.
April 26, 2007 at 7:19 am
If you ran it with the SET NOCOUNT ON statement, then the system message should have been suppressed.
April 25, 2007 at 7:15 am
Not sure if you have done the initial analysis of the log output as yet, but here is a start:
February 12, 2007 at 7:09 pm
The @@rowcount system parameter indicates the number of rows affected by the LAST statement. Since you have no statements preceding the conditional 'IF' statement, it will always return zero.
If you are...
February 6, 2007 at 5:16 pm
Importing/exporting data from/to a flat file is common; appending data to a flat file isn't. To my knowledge there is no SSIS component that would do batch insert to a...
February 6, 2007 at 5:03 pm
Since this is a forum dedicated to SSIS, I would suggest that you either use the Bulk Insert Task or the Data Flow Task components in SSIS, depending on your...
January 31, 2007 at 4:21 pm
OK. I think this is a quirk with SSIS, similar to applications like ERWin when it comes to preserving the positioning of the 'connectors'. My advise would be to either (i)...
January 31, 2007 at 4:04 pm
The only 'connections' I can think of is the 'connection managers' pane in 'control flow' tab for a SSIS project. In that case, depending on how you sized the pane,...
January 29, 2007 at 10:50 pm
I think both points are valid to an extent. For me, the reason to remove the BUILTIN\Administrators account is to reduce the 'potential' for compromise to the databases under my...
October 26, 2006 at 12:09 am
A few thoughts.
2. Yes, a good idea to use SSIS.
3. Historical load was simple - usually the easiest part of the load.
4. Incremental load based on business date timestamp -...
October 24, 2006 at 8:10 pm
Have you tried to validate the subscribers to make sure that they have the same record count? If not then simply determine the missing record and add it to the...
October 24, 2006 at 6:47 pm
Viewing 15 posts - 76 through 90 (of 270 total)