Tag Info

New answers tagged

2

sys.sql_modules isn't going to help you - you won't know which one is causing a specific update, or who's calling it. Here's a start - create a logging table: CREATE TABLE dbo.UpdateLog ( EventType SYSNAME, Parameters INT, EventInfo NVARCHAR(MAX), EventDate DATETIME NOT NULL DEFAULT GETDATE(), AppName SYSNAME NOT NULL DEFAULT APP_NAME(), ...


1

I'm going to list a different option here, having come from a development background. At one point, we had developed a client/server application, where we wanted the DDL (for the most part) to be the same between the client and the server. The challenge was the client and the server used different database engines. So what we did was use XML. We defined all ...


4

The best way to support multiple database types is to optimize the sql statements for each on of them. Otherwise you will one day end up with huge performance problems on one or the other database types. Additionally to that it's unfair for your customers to tell them "I support Oracle, DB2, MSSQL, etc.) and not optimizing the SQL for each one of them. Why? ...



Top 50 recent answers are included