Index_L

L

Languages installed, listing, 462

Latency, replication and, 421

Lazy Schema Validation option, 328

left() function, 193

len() function, 231

Licenses, for multiple SQL Server instances, 27

Licensing models (SQL Server), 14, 27

Linked server names, uppercase for, 302

Linked Server Properties

Catalog, 304

Data Source, 304

Product Name, 303, 305

Server Type, 303

Linked server security, 307-310

configuring in Enterprise Manager, 307-308

configuring in T-SQL, 309-310

Linked servers, 300-324

to an Access database, 306

actions never delegated, 322

actions that can be executed remotely, 322

architecture of, 300

between heterogeneous databases, 312-315

configuring in Enterprise Manager, 310-312

configuring in T-SQL, 312

creating to an Access database, 306

creating in Enterprise Manager, 302-304

creating on demand, 319

creating through T-SQL, 304-307

data flow of, 300-301

to DB2, 314

deleting, 315

executing stored procedures on, 318

listing users of, 465

to Oracle, 313

for pass-through queries, 319

provider types for, 304

querying, 316

vs. remote servers, 301

troubleshooting, 322-323

tuning and supporting, 321-324

uses for, 301-302

viewing metadata on, 322-323

viewing and selecting, 301

Linked Servers group, refreshing, 309

LMHOSTS file, 214

Load Delay option (transaction log), 358

LoadFromSQLServer method (DTS), 205

Local Server Jobs group, 114

Local system monitoring, 140

Local temporary table, 238

Locking down the job system, 110-112

Locking down SQL Server, 80-82

Locks being granted, listing, 463-464

lodctr.exe utility, 139

Log files

list of, 471

setting up in System Monitor, 146

Log Files tab (System Monitor), 146

Log Package Execution to SQL Server option, 130-131

Log Record for Connections trace flag, 156

Log shipped database not backed up error, 364

Log shipping, 346, 348-371

basic architecture, 349

behind the scenes, 350-351

components of, 348

database selection, 353

explained, 348

monitoring and troubleshooting, 361-364

process, 348-351

role changes, 365-371

role reversal, 365, 371

step by step, 351-364

stored procedures for, 351

synchronizing logins for, 367

Log shipping destination out of sync error, 364

Log shipping monitor, setting, 359

Log Shipping Pair Properties dialog box

Destination tab, 362-363

Source tab, 361-362

Status tab, 361

Log Shipping Schedules screen, 357

Log shipping tables, 350

Log shipping thresholds, setting, 358

Logging

commands that minimize, 242

in System Monitor, 145-147

turning on, 73

Logging events to Event Viewer from T-SQL, 492

Logical Scan Fragmentation, 249, 251

Login configuration, viewing, 492

Login timeout, for Enterprise Manager connection, 215

Logins

creating, 61

debugging performance problems of, 257

fixing broken, 290-291

listing assigned, 464

synchronizing for log shipping, 367

vs. users, 290

Logins security level, 60

Logins tab (Transfer Logins Properties), 366

Logouts, debugging performance problems of, 257

Logs

creating in System Monitor, 145

scheduling in System Monitor, 147

setting number of, 73

viewing in System Monitor, 147-148

LooksAlive check, 372, 410