Viewing 15 posts - 886 through 900 (of 1,069 total)
What are the suggetions for reducing the latency and bring both subscribers with in 1 or 2 hours latency
One of the suggestions is, defragment the indexes in publisher as well...
December 8, 2008 at 2:28 am
Is their any difference in access from Dot Net code in 2000 and 2005???
No. There is no differece in access from .NET code for 2000 and 2005.
However, there are...
December 8, 2008 at 2:14 am
im using an sql accoun "sa"quote]
1) Share the folder to which backups are copied.
2) SQL Server Agent service account should be a domain account, not local account.
3) Grant...
December 8, 2008 at 12:32 am
Give a different instance name while installing. It may work.
November 27, 2008 at 12:37 am
You can also fix this problem by prefixing database name to the table name in the query as follows:
qry="insert into DatabaseName.dbo.tbl_registration values(...
November 19, 2008 at 10:28 pm
Option is available to change the default database.
See the attachment.
November 19, 2008 at 10:07 pm
then 2 times next and then finish
test the connectivity.
Is all the above steps are perfect?
No.
Check "Change the default database to" then select the correct database from drop down...
November 19, 2008 at 4:18 am
Invalid object name 'tbl_registration'
The error message is clearly saying that the table is not found.
I think you are not pointing to the right database.
What is the default database? In the...
November 19, 2008 at 1:08 am
i want to connect sql express through asp 3.0 but unable to do it
What error message you are getting?
November 18, 2008 at 3:38 am
while deleting if any error occurs i need it to go into Eventlog of the system
Try RAISERROR WITH LOG
November 17, 2008 at 7:03 am
1. Server is dedicated. No other application is running on it.
2. Different hardware. More memory, Disk, CPU, etc.
3. Different setup. Data and log file, tempdb, etc.
4. Index, number of...
November 12, 2008 at 4:11 am
Kishore.P (11/7/2008)
set the isolation levels for database. So don't worry about whether record is commited or not.for more info see SQL BOL.
COMMIT matters, even if ISOLATION LEVEL is SET....
November 7, 2008 at 2:45 am
i checked the table...data is been inserted...
How did you check?
In the same connection it is possible to see the records without COMMITing.
In the other connection also it is possible...
November 7, 2008 at 1:08 am
Viewing 15 posts - 886 through 900 (of 1,069 total)