|
Hi Hulicat,
Thanks for your helping hand. Is Transactional replication bidirectional? i need to do sync for both side, that mean either D1 or D2 update, then both of them are update. And the interval time is my piority concern, i have to do it as fast as possible to allow user to use the latest data, may be in 30sec or even per transaction.
thankx in advance.
regards
cocoonwls
|
|
|
|
|
You need to use "merge" if either database can be updated,
Regards,
Hulicat
|
|
|
|
|
Hi Hulicat,
Thanks for your information.I got it .But then is there any solution/suggestion to prevent the problem you were mentioned in your first post?
regards
cocoonwls
|
|
|
|
|
Not to my knowledge; it's one of the caveats of using "merge" replication.
Regards,
Hulicat
|
|
|
|
|
I have a storedprocedure in oracle,in that am using
begin
OPEN RCT1 FOR
SELECT REPLACE(SelectStatus.SelectCommand, '@Location',
SelectStatus.Location) INTO
SelectStatus.SelectCommand FROM DUAL;
end;
My output is :-
Select * from area_master where location = '001' order by area_name
what is want is instead of getting this query as output,i want the result of this query as output..
how can i execute this query inside the SP?...
Any help will be appreciated
thanks in advance...
|
|
|
|
|
I have done it using cursor....
now its working...
|
|
|
|
|
i have a tow server one of theme i set the main database and the ather i set the the application the target of the application is to get data from 50 site to main database i can't change this structure
and i can't access to main database server except from application
i want to use syncronization service to sync data between main db and 50 site can syncronization service help
|
|
|
|
|
Hi I am New To SSRS.
I Have Gone through the Wikipedia about SSRS In That I have seen two ways
The ReportViewer control processes reports in one of two ways: (a) server processing, where the report is rendered by and obtained from the Report Server; and (b) local processing, where the control renders the RDL file itself.
Please Can Any one Give me the links to work in the second way ie
local processing, where the control renders the RDL file itself
Any Help is Greatly Appreciated
Thanks
If It Helps Click It as Answer
|
|
|
|
|
Hi !
I want to create a stored procedure for Search keyword with UNION, Sub query.
My DataBase includes same types of Board Tables. (Such as board_a , board_b ...)
I tried to make as below.
CREATE PROCEDURE sp_Search
@page int = 1,
@pageSize int = 10,
@keyword varchar(50)
AS
Declare @Sql varchar(3000)
Set @Sql = "Select Top " + Str(@pageSize) + " no, subject, content from "
Set @Sql = @Sql + " ( "
Set @Sql = @Sql + " Select tb, no, subject, content from ( "
Set @Sql = @Sql + " Select 'board_a' as tb, no,subject,content from board_a "
Set @Sql = @Sql + " UNION "
Set @Sql = @Sql + " select 'board_b' as tb, no,subject,content from board_b "
Set @Sql = @Sql + " ) As A "
Set @Sql = @Sql + " ) where no NOT IN "
Set @Sql = @Sql + " ( "
Set @Sql = @Sql + " Select Top " + Str(@pageSize * (@page-1)) + " no from ( "
Set @Sql = @Sql + " Select tb, no, subject, content from ( "
Set @Sql = @Sql + " Select 'board_a' as tb, no,subject,content from board_a "
Set @Sql = @Sql + " UNION "
Set @Sql = @Sql + " select 'board_b' as tb, no,subject,content from board_b "
Set @Sql = @Sql + " ) As A "
Set @Sql = @Sql + " ) "
Set @Sql = @Sql + " ) where subject Like '%"+ @keyword +"%' or content Like '%"+ @keyword +"%' order by no ASC "
Execute(@Sql)
But I got a Error Message.
I am having extreme difficulty in working time.
Please can someone help me?
|
|
|
|
|
I do not have the skills to help you, but it might help others to do so if you edit your post to include the full error message, rather than just say that you get one. Cut and paste if you can, to avoid typos.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
what is the error message ??
|
|
|
|
|
Try printing your sql (replace Execute(@Sql) with print @SQL), then paste it into query analyser and try running it from there to get more information on the error.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi all,
I want to convert a .mdb(MS-Access database) to .mdf (SQL Server 2005 database).How can i do it.
Thanks in advance.......
|
|
|
|
|
Hi,
If you got the SQL Server manager, you can "Import" the mdb-file. Create a blank sql-database, right-click within the object explorer and select "Tasks->Import"...
Regards
Sebastian
|
|
|
|
|
hi,
suppose i have 2 tables table1,table2 i wrote the following join query
SELECT * FROM table1 AS T1
JOIN table2 AS T2 ON T1.idtable1 = T2.idtable1
WHERE T1.idtable1 > 10
My Question:
Is the WHERE condition applies in the JOINED result ? Or the where is used before JOINing?
My small attempt...
|
|
|
|
|
It does apply in the JOINED result
|
|
|
|
|
It is applied to the result of the join.
In the past I have tried to "optimize" such statements as:
SELECT * FROM table1 AS T1
JOIN table2 AS T2
ON T1.idtable1 > 10
AND T1.idtable1 = T2.idtable1
but saw no improvement.
|
|
|
|
|
I think that depends on the database you are using. MS SQL would apply the where clause before the join. And you caan check this by getting the query-plan.
Wout Louwers
|
|
|
|
|
AFAIK SQL Server applies it before or after the join depending on what it thinks would give you the quickest result.
|
|
|
|
|
hi
i want to login with a unique password and access my database in person
that no one can access my database even addmin or sa and etc
i dont want any body meet my database tables and structures
i want to have some thing like database password in MS_Access
what can i do?
thanks in advance!
|
|
|
|
|
CREATE one user and give that db permissions to that user only and remove grants for other users
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Then use MS_Access.
If not, what database do you intend to use?
|
|
|
|
|
Hi
There are a lot of free databases. I am using Firebird right now. But it does not have password protection to its database files itself. Anybody can open database file to view it. Anybody can give me a suggestion for firebird database security problem.
Is there any database that has password protected? Especially for the embedded application.
Best regards,
modified on Sunday, September 13, 2009 4:12 PM
|
|
|
|
|
What exactly do you mean by password protected?
You can download SQL Server Express for free (4Gb data file limit). It has security - i.e. you need a login to get into the database.
Anyone can pick the MDf (data) file and attach it and use the data.... unless you encrypt the data with or write your own encryption algorithm.
|
|
|
|
|
Thank you very much for reply.
I want to protect my database structure. So nobody can easily open my user database to view my table structure. Minimum there is a password protection to open the user database file.
Which database can do it? MySQL? ACCESS?
Thanks,
|
|
|
|