You could try creating a view on the remote server/db and specifying nolock in the view I believe. Then just select from the view.

In 2005 Management Studio you can right click the database, Tasks -> Generate Scripts.... Follow the instructions and in the "what to script" section set everything to false except...

Use Dateadd...

UPDATE schedule

SET start_time = DATEADD(hh, 4, start_time)

WHERE DATEPART(hh, start_time) = 5

AND class_id = 100

I remove BUILTIN\Administrators from the SQL Server.

Make sure you add your own login to SQL first, however.

sp_msforeachdb 'SELECT ''?'' AS db_name, name as table_name from ?..sysobjects where xtype = ''U'' order by name asc'

Try that...

Exactly... When the buffer/cache hit ratio falls it means that the system was able to find the data it needed in the buffer and not have to go to...

But yes... 1GB of total server memory is really low.

Use performance monitor and watch the Memory -> Pages/Sec counter. This should be right around 0 most of the time. Also SQLServer:Memory -> Buffer/Cache hit ratio is good...

Use the full naming convention, i.e. "EndoCohort.dbo.Endo_Cohort_DHQ". You can reference table objects like this:

[ServerName].[DBName].[Owner/Schema].[Table].[Column]

Well, therein lies the difficulty.

I tend to err on the side of the more "academic" approach, personally. Though I do try to take into account whether the tables will...

I'm of the opinion that you should review your indexes regularly to ensure they are helpful and useful and add/remove indexes where necessary. That being said... data grows.

Placing an...

Windows authentication is never "switched off" per se. SQL Server supports either Windows authentication only (more secure) or Windows + SQL authentication (less secure).

It can always be changed over,...

from the command line:

nslookup 123.45.67.89

sp_msforeachdb will allow you to execute the same block of code using each database.

What you want to do is substitute in a question mark for the name of the database....

sp_msforeachdb...

Try Tools -> Options -> Results tab -> Maximium characters per column...

see if that works?