Dynamic Query

Dynamic Select Generator

Query to generate a dynamic Select statement from any table for moving data between servers.

Active Directory OPENQUERY Syntax

I have a query that will use a linked server to the Active Directory to get a list of email addresses for a list of users. What I would like to do is get a list of users within a group. I haven't been able to find much on this except that "multivalued properties cannot […]

RE: Too many messages on opening and closing data file

Hi tyang, quote: Will the log size be increased if I uncheck the auto close option? autoclose just means, that this db will automatically close when the last user disconnects. Default is, that SQL Server keeps all db files open all the time. I don't think, this will affect log files, though it will affect […]