sql-server-2005 Archives

Is it possible to do a ALL SERVER DML Trigger?

By adminPosted on September 21, 2023

Question : My department works on converting a client’s database when a client switches from another company to us. We […]

By adminPosted on September 18, 2023

Question : I’m assuming CU4 will be the last update for SQL 2005. We intend to stay on 2005 for […]

By adminPosted on September 16, 2023

Question : I’m running sql server 2005 and I’ve made a simple backup script that backs up all the databases […]

By adminPosted on September 12, 2023

Question : I have performed SQL Server upgrade from 2005 to SQL Server 2008. Is there any tools/possibilities to check, […]

By adminPosted on September 11, 2023

Question : I’m still struggling to understand SQL’s backup jobs. We currently have a SQL Server 2005 instance using the […]

By adminPosted on September 5, 2023

Question : I have a problem with an UPDATE statement that contains a nested SELECT statement in combination with LEFT […]

By adminPosted on September 3, 2023

Question : For these specifications: Publisher: (prod OLTP DB server) SQL Server 2005, database size : 220 GB also acts […]

By adminPosted on September 1, 2023

Question : I am working with a legacy database that has implemented query notifications against a table called ColorList. While […]

By adminPosted on August 31, 2023

Question : I would like to create computed index on a table if SQL Server is 2008 or newer and […]

By adminPosted on August 30, 2023

Question : In my sql server log (2005 SP4) I have this message every couple of seconds : “AppDomain XXX […]