How Do I Implement Snap Shot Replication..?
Jan 11, 2008
how do i implement Snap shot replication..?
(IN SQL EXPRESS SERVER)
thanks.
ADVERTISEMENT
Problem With Merge Replication--with Snap Shot Agent
Sep 20, 2004i am having a problem with the merge replication.
has over 400 thousand records and is running on a hp server with a raid 5 configuration.
i am trying to create a merge replication on another server with the same configuration.
i am facing problems in 2 places.
firstly i created a push subscription and ran the snap shot agnt.
but the snap shot agent times out and expires .. as a result of which i am not able to create the initial snap shot on the subscribers end.
next i thought i would manualy create a snap shot
and so i backed up the dabase from the publisher and restores it on the subscription side.
now i tried to create a new subscription by chosing the option... the dabase alredy conists of the data base and schema
and i get a n error saying
"SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers:
ICE: Error 20086: Publication '%s' does not support the nosync type because it contains a table that does not have a rowguidcol column
what do i do to solve this problem....
please try and give me a solution to solve either ways.
thanks,
--ggupta
Snap Shot Agent Refuses To Snap New Articles.
Sep 7, 2005Hi There
View 4 Replies View RelatedHow To Implement Replication
Mar 26, 2008Want to implement replication in sql server 2005
Kindly let me know how to do it.
Please
regards
cmrhema
How To Implement Transactional Replication Through Scripts
Sep 29, 2005Hi All,
I am required to setup Transactional Replication between two database servers (SQL Server 2000) but am expected to do it through scripts and not through wizards.
So can anybody help me out on that front?
Thanks & Regards,
Rohit Saksena
Can I Implement A Replication Between Sql Server 2005 And IBM AS400 DB?
Jun 7, 2007Hello,
I want to set up As400 DB as a publisher and the sql server 2005 as a subscriper, so that I can read some data from AS400 DB in sql server 2005 and every evening, I need the replicated data from AS400 to be refreshed.
Can I do it ? If yes, how to do it?
Thanks
How To Implement The Replication With The System Stored Procedures Or TransactSQL?
Jun 8, 2004how to implement the replication with the System Stored Procedures or the Transact-SQL ?
i want to encapsula my replication and make it be reusable and ease to use.So i want to do the replication in a script file.how can i do this?
Thanks.
Implement Manual Replication Between Two SQL Server 2005 Express?
Mar 2, 2007Hi,
I need to synchronize the data between two SQL Server 2005 Express.
The database is really simple, just few tables (but data are inserted very often) without any triggers.
Since Express edition could not behave as a Publisher I was thinking about implementing manually a sort of Replication mechanism... It should be a sort of Transactional Replication with queueud updating.
Does it sound a good idea?
Has anyone done this before o there are better solution?
Thanks in advance,
Stefano
How To Implement Alter Database Implement Restrictions On SQL2K ?
Dec 28, 2007Hi Guyz
it is taken from SQL2K5 SP2 readme.txt. Anyone have idea what to do to implement this ?
Our sp2 is failing. we suspect the above problem and researching it.we are running on default instance of SQL2K5 on win2003 ent sp2
"When you apply SP2, Setup upgrades system databases. If you have implemented restrictions on the ALTER DATABASE syntax, this upgrade may fail. Restrictions to ALTER DATABASE may include the following:
Explicitly denying the ALTER DATABASE statement.
A data definition language (DDL) trigger on ALTER DATABASE that rolls back the transaction containing the ALTER DATABASE statement.
If you have restrictions on ALTER DATABASE, and Setup fails to upgrade system databases to SP2, you must disable these restrictions and then re-run Setup."
thanks in advance.
Snap In Errors
Nov 8, 2004Hi guys, when I try to open EM I get this error.
Snap-in fialed to initialize.
Name: Microsoft Sql ent Mgr
CLSID:{00100100-186011d0-8ef5-00aa0062c58f}
Do i need to re-install the sql client tools?
Thanks for your help.
SQL Snap-In Not Initialized
Feb 3, 2007I am getting the error message:
Snap-In Not Initialized
Name: Microsoft SQL Enterprise Manager
CSID:00100100-1816-11d0-8ef5-00aa0062c58f
I have tried all the suggested fixes and nothing is working.
I unstalled and reinstalled SQL 2000
I unregistered and reregistered sqlmmc.dll successfully, but the error still exists.
When I checked the registry, I do not see an entry for Microsoft SQL .
What should I do know?
Is my last resort to rebuild the server?
Thanks
Snap-in Failed To Initialize
Feb 19, 2008When i try to open Sql Server Enterpris Manager the following error msg appers
Snap-in Failed to initialize
Name- unknown
CLSID{--}
how to solve this pbm help me very urgent
MMC Snap-in Failed To Initialize
Sep 16, 2004I am getting this problem when I try to open a DTS package.
MMC: Snap-in Failed to Initialize: Name: Meta Data Services:
CLSID(xxxxxxxxxxx)
Have anyone encountered this problem?
Lystra
Snap-im Failed Initialize
Jun 9, 2008I have problem with sql server configuration tool. it can not be opened
View 3 Replies View RelatedMMC Couldnot Create Snap In
Feb 1, 2008This is very old problem but I couldn't able to solve the following problem with the solution given for this.I had SQL 2000 installed, and later installed SQL 2005 with Visual Studio 2005. Now my enterprise manager tool no longer works in the MMC. I am not sure whether it is related to the SQL 2005 install or not.
The error I get is the :
MMC Couldnot create snap in
I reinstalled SQL 2000 enterprise manager, but it still gives the same error. Query Analyzer and other SQL utilities still work fine, as do other MMC items such as Biztalk Admin, Component Services, etc.
I tried to solve this by MMC and try to add SQL Server Enterprise manager,but I couldn't find Enterprise manager in the list.
I really appreciate if anybody can help me.
Thanks in advance
Regards,
Sireesh Chigurupati
Add Multiple Columns In One Shot
Oct 18, 2002I have a table and want to add 20 more columns to it. I'd like to name these newly added columns such as fname1,fname2....
I don't want to type them mannully. I tried to use loop. But when I use "alter table add" in the loop, I couldn't find a way to substitute the column name in the loop.
Is there any other good solution to this?
Thanks
Add Multiple Columns In One Shot
Oct 18, 2002I have a table and want to add 20 more columns to it. I'd like to name these newly added columns such as fname1,fname2....
I don't want to type them mannully. I tried to use loop. But when I use "alter table add" in the loop, I couldn't find a way to substitute the column name in the loop.
Is there any other good solution to this?
Thanks
Add Multiple Columns In One Shot
Oct 18, 2002I have a table and want to add 20 more columns to it. I'd like to name these newly added columns such as fname1,fname2....
I don't want to type them mannully. I tried to use loop. But when I use "alter table add" in the loop, I couldn't find a way to substitute the column name in the loop.
Is there any other good solution to this?
Thanks
SYBASE, I Know It Is Not SQL Server But This Is A Long Shot
Oct 1, 2001To anyone who knows how to use sybase. One of our guys has put in a sybase system and not told the rest of us about it and know their is a problem and it is in my lap. Surprise, surprise.
Just asking does antyone know how to rebuild a sybase database after it has been recovered from previous data and is now twice the size that it was origonally. Please help if any one can>
Many thanks to any one who can help.
Modify All Store Proc In DB In One Shot
May 19, 2004Is it possible that i can use a store proc to modify all the rest of my store procedures that i have in my DB ??
I have so many created allready and it will be to long to go throught each one of them to modify my text inside.
what i wish to do is a store proc that will allow me to loop to all my store proc of the current DB and look inside for specific text that i would like to change with the new value !!
any advise or example..
thanx.
SQL Server 2000 Enterprise Manager Snap-in Missing
Nov 11, 2006After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 or repair it? Please advise. Thanks.
View 3 Replies View RelatedIntegration Services :: Multi Files In One Shot
Jul 21, 2015i have multiple folders in a directory and each folder contains multiple files of same extension but with different formats(columns) and names(xmp: file aand file b). We have a data task in which we are joining(merge) both files and loading into table..should i use foreach, but then it takes 1 file at a time and i need the other file also to join it in data flow.
View 4 Replies View RelatedHow To Set Store Procs And Table Rigths In One Shot ??
Jan 22, 2008Dear all,
I am not so in database administration and I wold like to get some glue how to do what I am looking for.
I have a set of procedure and view in my Database HISTORY, then I define Grant the Execute rights to all those procedure for user NTAuthorityNETWORKSERVICE.
Then I have a second database named CONFIG where table might be accessed by store procedure of the database HISTORY. So first of all, in addition to set the EXECUTE grant access to my strore proces of database HISTORY, I need to set the SELECT grant access to all tables from database CONFIG on which are access by my storeprocs of database HISTORY.
First of all is it correct to set rights like this ?
Second, is there a way to set the access right of all my desire procedure in one shot ( script or something else ) becasue I have doen it manually and its painfull ?
If yes how to do that
thanks for help
regards
serge
Problem In Creating Database And Table In One Shot
May 9, 2006I need to create a database and then create tables in it..
IF EXISTS (SELECT name FROM sys.databases WHERE name = N'DB1')
DROP DATABASE [DB1]
-- create a new database
CREATE DATABASE [DB1] ON PRIMARY
( NAME = N'DB1', FILENAME = N'D:DB1.mdf' ,
SIZE = 51200KB , MAXSIZE = UNLIMITED, FILEGROWTH = 30720KB )
LOG ON
( NAME = N'DB1_log', FILENAME = N'D:DB1_log.ldf' , SIZE = 2048KB , MAXSIZE = UNLIMITED , FILEGROWTH = 30720KB )
COLLATE Latin1_General_CI_AS
CREATE TABLE [DB1].[dbo].[SALES](
[PERIOD] [int] NOT NULL,
[LOC] [nchar](3) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
If i run the above statement one after one, they work; however, if I run all of them together (or in sp), the following error raised:
Msg 2702, Level 16, State 2, Line 43
Database 'DB1' does not exist.
May I know how can i create a database and then immediately the tables in sp!
Thanks
Transferring Objects Form Schema A To Schema B In One Shot....!
May 27, 2008I have 35+ tables and 15+ stored procedures with SchemaA, now I want to transfer them to SchemaB.
I know how to do one by one...!
alter schema SchemaB transfer
SchemaA.TableA
but it will take long time...!
Thanks,
How To Implement?
Apr 12, 2005Hi all,
I had many groups of data which column A store number & column B store location. My syntax as below :-
select count(columnA) as no, columnB from table group by columnB
No columnB
20 A
10 B
5 C
How can I select 5 rows for Each ColumnB? (total 15 rows of record)
Thanks!
How To Implement Cursors In Sql
Feb 29, 2008hi friends....... I have one doubt. how can we use cursor in sql. in oracle they implement cursors on stored procedure, can we implement same concept in sql stored procedure...regards Samuel chandradoss . J
View 3 Replies View RelatedCannot Implement Mirroring
Apr 1, 2008Hi,
I have place an question, but in some other place in the same forum.
My apologies for that
I wanted to implement mirroring
I hereby let u know the steps
1. Created a database in Principal server named Mirror1 and one table named tblMirror1.( no values inside the table)
2. Repeated the same in Mirror in Witness
3. Selected the Principal server's database -->right click-->tasks-->mirror
4. from the left hand panel selected Options -->recovery model-->full
5. selected Mirroring from left hand panel-->configure secuirty-->entered mirror and witness name--Success
6. When I click on start mirroring I have an error stating
" Alter failed for database mirror1"
"Database mirroring cannot be enabled because Mirror1 database may have bulk logged changes that have not been backed up etc...."
7. followed this one
BACKUP database mirror1 TO DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'
got the answer as
Processed 160 pages for database 'mirror1', file 'Mirror1' on file 2.
Processed 1 pages for database 'mirror1', file 'Mirror1_log' on file 2.
BACKUP DATABASE successfully processed 161 pages in 0.318 seconds (4.147 MB/sec).
According to sources
Run a restore of this backup on your mirror.
This can be done through the GUI or using a T-SQL command.
The database restore must use the NO RECOVERY option, so the database stays in a loading state.
Also the database name on the mirror must be the exact same name as the principal
RESTORE TestMirror FROM DISK='C:Backup TestMirror_FULL.BAK' WITH NORECOVERY
Hence did the below
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY
ERROR
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
HENCE MODIFIED AS
use master
go
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Please let me know what shuld i modify
regards
cmrhema
Implement One Is To Zero Or Many Relationship
Sep 19, 2013Just wondering if there was a way to implement a one is to zero or many relationship with sql or can you only have a one is to one or many?
View 2 Replies View RelatedHow To Implement This As A Function?
Jul 6, 2007Hi all,
I've been using a piece of transact code to generate random strings of characters in a lot of scripts and I wanted to wrap it up all nice and neat into a function. I came up with the script below.
However, this fails with the following error..
quote:Invalid use of 'rand' within a function.
I've allready tried using dynamic sql and sp_executesql inside the function hoping that a new scope would let me use rand() but that isn't allowed either.
I'm Using sql server 2000. Any ideas?
Charlie.
-- snip ----
CREATE FUNCTION dbo.randstr (
@lengthINT)
RETURNS VARCHAR
AS BEGIN
DECLARE @outputVARCHAR(8000)
DECLARE @allowedVARCHAR(8000)
SET @allowed = '234679abcdefghjkmnpqrstuvwxyz234679ACDEFGHIJKLMNPQRTUVWXYZ'
SET NOCOUNT ON
DECLARE @charmapTABLE (charpos INT IDENTITY (1,1), symbol CHAR)
DECLARE @counterINT
DECLARE @characterINT
DECLARE @maplengthINT
SET @maplength = LEN(@allowed)
SET @character = 0
SET @output = ''
-- Insert the allowed characters into the character map table
SET @counter = 1
WHILE (@counter < @maplength + 1) BEGIN
INSERT INTO @charmap SELECT SUBSTRING(@allowed,@counter,1)
SET @counter = @counter + 1
END
-- Start the loop to generate @output
SET @counter = 1
WHILE (@counter < @length + 1) BEGIN
-- RAND() should output a floating point number between 0 and 1 however...
-- Sometimes the rand() function spits out a number greater than 1
-- or the multiplication results in 0
WHILE (@character < 1) OR (@character > @maplength) BEGIN
SET @character = CAST(@maplength * RAND()+1 AS INT)
END
-- Add the random character to @output
SET @output = @output + (SELECT symbol FROM @charmap WHERE charpos = @character)
-- Increment and Reset the @character variable
SET @counter = @counter + 1
SET @character = 0
END
RETURN @output
END
-- end snip ---
How To Implement This Scenario
May 11, 2006Hi,
i hav a text file in this format..
currency,exchangerate(INR),date
dollar,45,20/04/2006
dollar,46,22/04/2006
britishpound,65,20/04/06
dirham,12,20/04/06..etc..
now,i want that using this as source.. 2 tables should be created and filled with appropriate data..
CurrencyMaster..Currencyid(PK),Currencyname
CurrencyDailyRate..ID,Currencyid(FK),rate,date
how can i do it using SSIS?
thks
How To Implement This In SSIS
May 22, 2006Greetings SQL friends!
I have the following transact SQL code which I want to change to a set of SSIS components.
SELECT blah, blah
FROM PSTAGE..[stage_OFFER_PRICE_DIVIDEND] AS SOPD
LEFT OUTER JOIN PSTAGE..[stage_PRICE_GRP] AS SPG
ON SOPD.PRICE_GRP_ID = SPG.PRICE_GRP_ID
LEFT OUTER JOIN PSTAGE..[stage_type] AS TYP
ON TYP.TYPE_CD=SPG.PRICE_TYPE_TYPE4_CD
and TYP.TYPE_CL_CD = '0017'
I know I can join two data sets using a merge join (left join) but how do I combine a third merge join? Should I be doing this or should I just stick my code in a SQL Task instead?
Your help would be appreciated.
How Do I Implement If Then Else Conditions
May 28, 2007Hi All,
I'm very new to Integration Services. Self Learned this ETL tool based on my prior ETL tool knowledge.
Can you tell me how do write IF Then Else conditions for every column in my source and redirect to a single output?
Hey correction here ... i'm using flat file as my source
Thanks in Advance,
Suresh N