Sp_detach_db and sp_attach_db. Remeber to run sp_updatestats after upgrade db to the SQL Server 2000.

select name from sysdatabases.

Or

Grant guest account to the 'LimitedAccess' database but don't grant any permissions to it to access any user's objtecs.

Try this.

update #t set address = replace(address, substring(address, charindex(' ', address) - 1, 1) + ' ' + substring(address, charindex(' ', address) + 1, 1), substring(address, charindex(' ', address) -...

Can you post your original data? If the original data looks like following, You will get exactly what you want.

270 05 76TH AVENUE

133 38 41ST RD #C01

After running the update,...

Here is the question and answer to your question from Microsoft Q315886.

Q11: Why does SQL Mail only work when I am logged into the server?

A11: This suggests that you do...

What is the version of your SQL Server and OS? What mail clients you use with SQL Mail?

Can you try this.

update #t set address = replace(address, substring(address, charindex(' ', address) - 1, 1) + ' ' + substring(address, charindex(' ', address) + 1, 1), substring(address, charindex(' ',...

Have you tried to just select few columns in select statement?

Have you tried Microsoft Baseline Analyzer?

Open the client network utility from your machine, choose alias tab and click add button, fill in 'LS-IMRIE\SILFW' in server alias and server name boxes, select TCP/IP from network library,...

The population job can also be started using sp_start_job by someone or application. The execution of sp_start_job permissions is default to the public role.

Suggest you to use profiler to...

It can also be populated manually from Full-Text catalogs in database. By the way, how do you know it was be populated during the day?

Have you configured alias to the SQL server instance LS-IMRIE\SILFW with client network utility?

Check your population job schedule to see how it is scheduled. It may be scheduled to run many times a day.

Don't think it is possible without re-install. You may have to work around with the backup solution.