tigersbh,

Can you copy and paste the error messages from QA after your execute the sp_attach_db statement?

SQL Scan runs on Windows 2000 or higher and can identify instances of SQL Server 2000 and MSDE 2000 running on Windows NT 4.0, Windows 2000, or Windows XP (Professional)....

You may encounter problem when try to backup the SQL Server databases that are being used. In order to backup open files like databases, you need OFM (open file manager)...

Columns per table is 1024.

Example from BOL.

B. Use FETCH to store values in variables

This example is similar to the last example, except the output of the FETCH statements is stored in local variables rather...

Each variable in the list, from left to right, is associated with the corresponding column in the cursor result set. The number of variables must match the number of columns...

See example in the link below.

http://www.asp.net/Tutorials/quickstart.aspx and click 'Server-Side Data Access' on left panel.

Edited by - Allen_Cui on 05/07/2003 09:34:37 AM

Read this KB articles.

http://support.microsoft.com/default.aspx?scid=kb;en-us;316989

http://support.microsoft.com/default.aspx?scid=kb;en-us;815154

Edited by - Allen_Cui on 05/07/2003 08:05:49 AM

Try this.

select spid, hostname, program_name, nt_domain, loginame from sysprocesses

Sure.

Create the procedure with prefix 'sp_'. For example, sp_new_spaceused.

Profiler your database for quite period time and feed the result into Index Tuning Wizard to identify the columns that need to be indexed. And then inentify the long run...

quote:

---

I am using SQL Server 2000. So I should able to drop the columns in this case, isn't it?

---