when next RDC'ed onto your SQL server box, run the SQL config tool

C:\WINDOWS\system32\SQLServerManager.msc

and check the SQL Server 2005 Network Configuration, Protocols for xxx

- you should see NamedPipes and/or TCP/IP enabled...

You may have registered several SQL server instances in SSMS  (View, RegisteredServers) which are probably dormant, or even be connected in the ObjectExplorer window.

The significance of the green arrow shows...

I had assumed that you had MS Access [on your PC] so you could do client-side uploads

- ie all part of MS Access product (or part of Office/Professional suite)

Yes, it is...

I concur that a job should only run iff the job is enabled and the job schedule is enabled.

The wider picture is that SQLServers can be federated together so each...

using MS Access-2003 and the Tools menu to launch Upsizing Wizard, the first page of the wizard offers "use existing" or "create new" db. Later pages ask about table attributes,...

when creating a linked-server [with SSMS in ServerObjects, LinkedServers], the default on the security page is "connections will be made without using a security context" so you attempt the "Guest" credentials...

sounds like you should explore the MS VSTS/DataDude

http://msdn2.microsoft.com/en-us/teamsystem/aa718807.aspx

You can script out [from LIVE] and create sandboxes [on developer's PC] with the metadata. You would normally use the data generate...

glad you managed to finger the bad table and get the db back together [from backup].

Don't forget the latest Service Pack !

Dick

If you do a sp_who2 to see what people are running, but inevitably it is an immediate snapshot and you may miss activity.

Suggestion is to use Profiler (Trace in old...

agree with Antares686 to DBCC checkdb/checktable as first step. If you have any corruption in a non-CI then you should be able to drop and recreate it.

I would bodge cursor...

Dharma is basically wrong! See extract from BOL below

IMHO it is very rare to [have/want to] run sp_recompile since this would happen next actual usage. This is just as well...

within MSSQL no, it is effectively synchronous [excepting parallelism so several CPUs can simultaneously work on a complex query].

There is nothing to to prevent YOU from having multiple connections to...

MS has a SQLIOStress utility (aka SQL70IOStress) - see URL

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B231619

which has replaced the earlier SQLHDTST [in MSSQL RK but doesn't work with W2K] at

http://download.microsoft.com/download/sql65/Utility3/1/WIN98/EN-US/Sqlhdtst.exe

either way these...