The best way to accomplish your task is to use Dynamic SQL.  You'll have to create a variable to store your SQL Statement and your variable in and then execute...

The only way I know of to get the name of the SQL Server hosting Sharepoint is to find the Sharepoint administrator and ask him/her for the SQL Server name,...

Litespeed has been most effective for my team.  Recently, however, we used Beyond Compare 2 when upgrading our server hardware.  It came in handy to make sure all our new...

Am I correct in reading that you're checking for a file name which is always consistent?

I'm beginning to think my issue has to do with the wildcard character.  It doesn't...

That was the first thing I checked.  I have \\MyServerName\Sharename\path\ in my gsFilePath variable.  That's why I put in the MsgBox stuff, so I could verify the path &...