|
Dear All,
I am in doubt with Simple Recovery Mode in SQL 2005.
My Case follow bellow.
I have two server located in different location which uses merge replication.
Server A which is publisher uses Simple Recovery Mode.
My question is If transaction in SERVER A is succesfull and yet data is not replicated to SERVER B or the transaction fails to occur in SERVER B which is a subscription.
what happens with that log? does it occurs in SERVER B or its ommited from log? this is where i doubt in simple recover mode.
As I said that I am using Simple Recovery Mode in SERVER A which is publisher.
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
hi
i want to have an stored procedure that retrieve the file path of the Specific database as a parameter
i used to use sp_helpDB and fetch the data as in table but i can not return its file path as a parameter
simply i want to check the path of the "Logic_database_name" and return it as in nvarchar parameter
what can i do?
thanks in advance
|
|
|
|
|
You can use sp_helpfile stored procedure or you can query sys.master_files table.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Try the following....
USE master
GO
DECLARE @DB_Path nvarchar(256)
SET @DB_Path= (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
FROM master.sys.master_files
WHERE database_id = 1 AND file_id = 1)
SELECT @DB_PathA S PhysicalPath
It uses the built-in “master” database, finds the physical path to it from the “master.sys.master_files” view, then takes a substring to get just the path portion.
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
Hi,
How to run a query in the backend SQL Server automatically as soon as a entry happens in the table from frontend?
|
|
|
|
|
Use Triggers.
|
|
|
|
|
Hi ,
i created an Windows application using C#.net and used Backend as Sql Server2005 (where i have only one table) and know i want to deploy the project and send it to an client.so when he install the project he is unable to get the database in the client system. so what to do? and how to deploy the application using database. so that their is not need for me to install the sql server in client system and create the tables..
Just send u r views
|
|
|
|
|
The client machine will have to have SQL Installed in order for the application to be able to read the data. You would specify this in the prerequesites.
Alternatively, use SQL CE or SqlLite or another embedded database.
I don't speak Idiot - please talk slowly and clearly
I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury
Driven to the arms of Heineken by the wife
|
|
|
|
|
Use Sql Server 2005 express edition. which gets saved as .mdf format in your application path. Connect to it. Express edition is best suit for small business.
vijayaraya
|
|
|
|
|
My asp.net project database is MS SQL 2008, i want to convert it to MS SQL 2003.
How can I do this ?
Please help ....
Apurv
“Never trust a computer you can’t throw out a window.”
(Steve Wozniak)
“There are only two industries that refer to their customers as ‘users’.”
(Edward Tufte)
|
|
|
|
|
In MySQL I can export/import table definitions and contents; I would expect SQL Server has that too.
And there must be ways to backup and restore; I would hope those aren't too picky about version numbers.
Luc Pattyn
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Generate Script Compatible to older version
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
Hi,
I am inserting records into ms access using vb.net.
insert into data(F01,F02)values(" & F01(k) & "," & IIf(Double.IsNaN(F01TA(k)), DBNull.Value, F01TA(k)) & ")"
Showing syntax error in the insert statement.
the output query is like below
insert into Data(F01,F02)values(221,);
Please share your ideas...
Thanks,
Sivakumar.M.
|
|
|
|
|
check the value of the given parameters... your generated query probably like ...
....Values(1,2,,3)
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
Thanks
Md. Marufuzzaman
|
|
|
|
|
What is the Error that you are getting ?
Your insert is incorrect, Your expected number of parameters is less than the Supplied Parameters.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
When you concatenate DBNull.Value into your query expression, it calls the DBNull.ToString method. This is defined to return an empty string, so your insert statement is missing a parameter after the final comma.
Use the literal "null" in your SQL insert instead of DBNull.Value, that should work. Or use a DbCommand with query parameters, as someone else suggested.
|
|
|
|
|
Hi all,
I need to insert a record in to a table automatically on every day at 12 PM.How can I achive this.Will trigger help me in this regard.If not how can I achive this.Please help me.(I want to perform this action in backend only)
Thanks in advance,
Srinivas Mateti
|
|
|
|
|
You can create a Job , which db are you using ???
Best Of Regards,
SOFTDEV
If you have knowledge, let others light their candles at it
|
|
|
|
|
I will be using both MSSQL and MySQL data bases.
Thanks,
Srinivas Mateti
|
|
|
|
|
MSSQL you can create a stored procedure to do the insert and then schedule a job to execute the procedure when required.
MySQL - I don't know.
As suggested you could use a windows service to do both inserts.
|
|
|
|
|
Thanks for the reply.Here the constraint is I cannot use Windowse services.So, I will schedule a job whichi will fire on each day at specific time.In this job i will call the SP which will insert or update the desired record.I hore in MYSQL ALSO it will works.Right....
Thanks,
Srinivas Mateti
|
|
|
|
|
If MySQL does not support jobs then you may be able to trick SQL Server into doing the job on MySQL as a remote server or a linked server, nasty but it may be possible.
|
|
|
|
|
Oho..This will create more problem for me.I cannot use SQLSERVER to trigger MYSQL.I canot use windowse services.But I need the auto insert action...Is there any other option in MySQl which is similar to MSSQL jobs feature.Please guide me.
Thanks in advance,
Srinivas Mateti
|
|
|
|
|
MySQL has an event scheduler which can be used to fire off tasks at specified times or intervals.
|
|
|
|
|
Triggers execute in response to certain events when INSERT, UPDATE or DELETE
|
|
|
|