See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;135268

How to Use CACLS.EXE in a Batch File

http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/xcacls-o.asp

Xcacls.exe

Also older tools for listing NTFS and Share permissions: from resource kits:

showacls and rmtshare

Jasmine,

You would want to send a message on that using the link at the top of each forum page. The link is "Report a Problem" and it is located at...

You can get a CD media for SQL Server Reporting Services for $5 (five) from Microsoft. The price reflecs shipping and handling, the license for the Reporting Services is included...

You can not restore database structure for 2005 on the 2000 server because of a difference in the system table structure.

Workaround: restore 2005 to 2005 server and use DTS to...

Alex,

You may want to check the size of your TempDB and if any growth restrictions are applicable and how much disk space is available.

Also if DTS package explicitly specifies a...

Diwakar,

there are 2 independent issues:

1. You are correct with the first one. The query in a Query Analyzer will execute in the context of the executing user, not in the...

Additionally when looking up the topics to answer the QOD, I found the following for SQL Server 2005 in BOL topic "Execute As Clause (T-SQL)" :

"...........If the SQL Server (MSSQLSERVER)...

Optimization jobs are performed in the databases that are in SQL Server. The backup files are like the text files, they are in the file system. To find out which...

Domain Controller may not be available for the authentication

Agree with Phil and Rudy. Additionally think about other sysadmins when you are on vacation or decide to take another job. Consistent backup file names reflecting the database names in...

I created 2 roles: Role1 and Role2. I was able to use sp_addrolemember to add role2 to the members of role1 and after executing this statement I could see role2...

The question did not specify what did they want: consecutive places with 2 people sharing the first place, 3 people sharing the second place etc. or places with the gaps....

You probably need to add troubleshooting code to the packages and maybe implement some logging.

You have to see what is your server registration in the Enterprise Manager. When  you are working with DTS Wizard from the start menu it is you - administrator who...

If the server trace shows that the procedure was running more the 30 sec it has nothing to do with network. I too would monitor the available memory but meanwhile I...