Creating a group is a great idea. I'll do that for the new server that is being built. For this old server, this is a one time thing. ...

Thanks for responding. Is there a server role to give db_owner permissions to a user that excludes all of the additional access of sysadmin?

It is working perfectly now with the * in the middle of the file name. Thanks so much for your help.

Yes, I found if I type UPD.TXT into the File: box it works, if I do it using that expression, it does not find the file.

Thanks for helping me figure...

Thanks Craig. I thought maybe it was not interpretingthe * in the middle of the file name as a wildcard through the variable. I'll keep trying to narrow...

Thanks Craig.

Yes, CCYY is a way of indicating 4 digit year.

The file is called

20120705_112233_UPD.TXT

and I have

Right("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+

Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +

Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2)...

Does anyone know what the map checkbox does?

Yes, the user exists ahead of time.

Thanks Lutz,

Using your OUTER APPLY example, I put together something that works. The extra rows all have the same datetime stamp so I can find them by querying the...

Table structure matches the error log with the additional of a server name column.

Server,LogDate,ProcessInfo,Text

I've already made several attempts to modify your example using ROW_NUMBER to assign a number to each...

Thanks for the reply and explanation. I'm sure that your example works in the wErrorlog table that is created on each server prior to writing to the table on...

The MS technician that is onsite this week gave me some clarification. After looking at my findings, he told me that AWE reaches into the OS reserved area which...

Still using the defaults. Min 0 Max 2147483647

This is what I have found on a test server. Windows Server 2003 R2, x86, 4gb ram, SQL Server 2005

The first three columns are clear. The last column is...

I'll try it with just AWE and see what the VAS space indicates. If it isn't as I hope, I'll enable /3gb and reboot.

Was hoping that the AWE setting in...