Question : I have an old SQL Server 2000 machine in a clustered environment. The data files are on Disk […]
Tag: sql-server-2000
GRANT permissions to all tables, views, procedures in SQL Server 2000
Question : I was wondering if there was a fairly efficient way to use T-SQL with SQL Server 2000 syntax […]
I have a database backup (.bak) from SQL Server v7, how do I convert it for load into v10?
Question : A client has given me a backup (.bak) from a SQL Server v 7 database. I am trying […]
Simplifying query by adding Computed Column, performance impact?
Question : The dev team came across the following query (might be incomplete; it’s retyped from a screenshot) which had […]
Breaking database replication
Question : I am trying to break replication between two SQL 2000 databases. Can this be done while the databases […]
SQL performance issues with remote query across linked server
Question : This sproc create proc dbo.Get_Accounts as begin declare @current_date datetime set @current_date = dbo.fn_currdate() select [fields] into dbo.current_accounts […]
Cleaning up transaction replication del/ins/upd stored procedures?
Question : I’m referring to the ones that start with: dbo.sp_MSdel… dbo.sp_MSins… dbo.sp_MSupd… I’ve noticed they are not removed when […]
Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?
Question : The sys.dm_os_performance_counters DMV introduced in SQL Server 2005 makes this task somewhat trivial. However, my Google-Fu has been […]
GRANT permissions to all tables, views, procedures in SQL Server 2000
Question : I was wondering if there was a fairly efficient way to use T-SQL with SQL Server 2000 syntax […]
Cleaning up transaction replication del/ins/upd stored procedures?
Question : I’m referring to the ones that start with: dbo.sp_MSdel… dbo.sp_MSins… dbo.sp_MSupd… I’ve noticed they are not removed when […]