Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
Salespeople often spout the Ford Motor Company mantra, "The customer is job one." No doubt, keeping customers happy is a key factor in every company's well-being. However, customer satisfaction isn't—and shouldn't be—the primary job responsibility...
When I try to set up merge replication in SQL Server 7.0, the replication works fine, but I experience an ownership problem. Here's the scenario. A user named System owns all the database objects in an application named system. I set up...
I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the...
Can I calculate the number of rows in a SQL Distributed Management Objects (SQL-DMO) bulk copy data file without importing the data?
I don't know a way to use SQL-DMO to calculate the number of rows in a data file. But all you need to do is co...