move the transaction logs to the new array.

when was last time all indexes were rebuilt? rebuilding indexes might solve all of your problems right there. was is Cache Hit Ratio...

if u restore, can then execute following script in query window.

change output to text, execute it, then copy paste back in and execute

SELECT 'Exec sp_rename ''' + name + ''',...

see linked servers in BOL. then use 4 part naming convention

update MyTable

set field1 = b.field1

FROM myTable a

JOIN serverName.databaseName.ownerName.MyTable b

On a.id = b.id

your approach is certainly acceptable. i would approach it slightly differntly though.

if u want all phone #s in one table, then i'd do it like this (with the disclaimer that...

not sure i completely understand u. here is the basic:

insert tableB (col1, col2, col3, col4, col5)

SELECT col1, col2, col3, col4, col5

FROM tableA

but if u are passing 5 params to...

yes you can. when multiple versions participate in replication, the distributor is generally the lowest common denominator -- cant be lower than publisherr.

see this article for complete details

LOL. TRUE TRUE

sp_detach_db 'dbname'

then copy/paste files to desired location

then

sp_attach_db 'data file path', 'log file path'

when u see everything working right, delete original files that u copied.

see here as well

your SAN (almost certainly) has tools to do this seamlessly

but as Steve says...make sure u have backups -- and make sure u know they are good

u will learn a ton. keep msdn links and forums handy.

try to get email addresses of some other experienced dba's u meet on this or other forums.

read everything u can...

also see http://technet.microsoft.com/en-us/library/ms178569.aspx

GRANT CREATE PROCEDURE TO User1

what version sql 2000 and SP level? as said, works for me. i tried using sql2k SE SP4

need to script the logins from a different server u trust to be right. there aren't "default" permissions per se.

by the way, dbo has permission to modify any object in...

you need to backup tran log