This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2004-05-12 (first published: 2001-05-01)
10,962 reads
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,460 reads
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,995 reads
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,782 reads
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,841 reads
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,739 reads
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
7,045 reads
The fourth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-22
6,032 reads
Nothing is more annoying than having to disconnect users one by one. With this script, you will be able to quickly disconnect them with a few keystrokes.
2001-04-21
18,289 reads
The third part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-20
11,360 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers