MSSQL, SELECT statement, SQL 2000, SQL 2005, SQL 2005 Database, SQL 2008, SQL Database, SQL error messages, SQL Express, SQL Plus, SQL scripts, SQL Server 2000, SQL Server 2003, SQL Server 2005, SQL Server 2005 Database, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 R2, SQL Server 2012, SQL Server administration, SQL Server Agent, SQL Server backup, SQL Server backup and restore, SQL Server clustering, SQL Server connectivity, SQL Server database, SQL Server databases, SQL Server error messages, SQL Server errors, SQL Server Express, SQL Server installation, SQL Server Management Studio, SQL Server migration, SQL Server performance, SQL Server performance tuning, SQL Server Query, SQL Server replication, SQL Server Reporting Services, SQL Server security, SQL Server stored procedures, SQL Server tables, SQL Server upgrades, SQL stored procedures, SQL tables, SSIS Package, SSRS, SSRS 2005, Stored Procedures, T-SQL, T/SQL VIEW ALL TAGS
To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.
hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part. When the snapshot is created and the...
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?
Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just...Thanks! We'll email you
when relevant content is
added and updated.