Complications in snapshot replication from a SQL Server database
I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?
View Answer
| Jul 22 2008 8:04 PM GMT
SQL Server snapshot backup, SQL Server replication, SQL Server database
I have done snapshot replication from my SQL Server database to another SQL Server database. After completing the replication, the replicated data is not present in the other SQL Server database. Why might this be?
View Answer
| Jul 22 2008 8:04 PM GMTSQL Server snapshot backup, SQL Server replication, SQL Server database
2445 pts.
Copy SQL Server Table
How do I copy a table into the same database without including the data? Thanks ken
How do I copy a table into the same database without including the data? Thanks ken
Implementing access from a remote site to a SQL Server 2000 database
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have...
I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have...
Recovering .mdf and .ldf files from SQL Server
I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...
I backed-up our SQL Server yesterday around noon, and we then added more data in. Today, when we tried to start our application, we found that the database is in SUSPEND mode. We stopped our SQL services and tried to copy the newer data, but there was a data error. It seems that our .mdf file is...
Eliminating duplicate rows in SQL Server 2000
I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?
I have a database I recently inherited in SQL 2000 that contains some duplicate rows. How can I identify the tables that have this problem (duplicate rows meaning ones that have the same “time_stamp” value, and “time_stamp” being used as a raw identifier)?
