SQL Server might not be the top database in terms of new license revenue, but neither is Oracle. According to Gartner Dataquest, a shake-up in the database market has yielded a new database champ: IBM. IBM's acquisition of Informix boosted Big Bl...
Match usernames and login names when you restore to a new server
I'm using snapshot replication in SQL Server 7.0, and I discovered that the referential integrity defined on the source table is lost on the destination tables at the subscriber. I've selected the Include declared referential integrity on the...
I'm using SQL Server Profiler to trace application activity, but the Profiler logs aren't showing some commands that I know the application issued. Is Profiler reliable? Why is it missing commands...
My SQL Server Profiler doesn't seem to be correctly processing SQL:StmtCompleted events. SQL Server Books Online (BOL) says that SQL:StmtCompleted will capture SQL statements as they execute within the body of a stored procedure. However, my...
Log backups are an important part of a full database backup. SQL Server backs up the transaction log as part of a full backup to make the full backup transactionally consistent when the full backup is restored. Before you can back it up, the...