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...