How about something like this:

Declare @exec_sql varchar(max);

Set @exec_sql = '';

Select @exec_sql = @exec_sql + 'Execute master..xp_logininfo @acctname = ''' + sp.[name] + ''', @option = ''members'';'

From sys.server_principals sp

...

Yes - that is the idea. Glad I could help out.

If you drop and recreate the destination table every time, then you also have to recreate the indexes and re-apply all security to the table. Then, what happens when...

Once you connect to your VPN - your test server is no longer accessible.

You need to use a case expression, as in:

SELECT USER

,SUM(CASE WHEN (NOT (STATUS= '90R')) AND (NOT (STATUS= '99I')) THEN 1 ELSE 0 END)...

These are the steps I use for this type of process:

1) Disable all NC indexes on destination table

a) ALTER INDEX IndexName ON table DISABLE;

2) Truncate destination...

Okay, when you run this script - add a print statement to print the @stmt variable before trying to execute it. Let's see exactly what is being built and...

All that command does is reads the file details of the selected backup file and load that information into a temporary table. I would assume that the information is...

That is great - glad I could help and thanks for the feedback.

In Object Explorer - right click on the server name and select properties. Select the Memory page and post back what the min/max memory settings are.

Another question comes to...

I see - you are actually doing this in Access and I gave you SQL Server T-SQL syntax. At least you were able to see what was happening and...

You would select all the records with a datetime greater than 4 days ago first, then filter based upon the time.

Something like:

SELECT {columns}

FROM yourTable

WHERE datecolumn >= dateadd(day,...

This is really going to depend upon the server that you are linked to. If that server is SQL Server 2005 or 2008, you could use the following:

SELECT {columns}

...

You can try rebuilding the indexes:

ALTER INDEX ALL ON yourtable REBUILD;

If that doesn't work, verify that you have a clustered index on the table. If you don't have a...

Reviewing this article http://support.microsoft.com/kb/828339 tells us that we may not see errors using CHECKDB for an intermittent hardware problem.

Since you are getting these on a regular basis - you are...