They don't automatically have access to the tables unless cross database ownership chaining is on... but in that case the function would also work. Does the public role have access...

After the fact you're out of like. Prior to, you can set up appropriate traces using Profiler or the trace stored procedures. You can key on object creation/deletion as they...

Create a database role in the Enroll database. Call it the same, AppReports, if you'd like. Make the user a member of this database role. Grant the database role EXECUTE...

Blocker puts out a lot of info. Have you tried just using sp_lock to determine the locking info when this problem occurs? This system stored procedure goes syslockinfo and gets...

Did you uninstall the .NET Framework components as well?

Please do not cross post. Most of us check all forums and if you cross post answers and information are likely to get split up between the multiple threads. See...

Please do not cross post. Most of us check all forums and if you cross post answers and information are likely to get split up between the multiple threads.

You can use something like Process Explorer from SysInternals to see what process has it open. It may not be SQL Server, after all.

SysInternals Web Site

Microsoft Script Repository:

Services Scripts

You can configure a .wav file to play when a query is completed. If you make it a unique sound, you'll hear it sound when the query completes.

The short answer is: it depends. There is a time and place to use functions, especially when you need a scalar value, but ultimately it has to be balanced with...

What you can do is run Profiler and have it put the information into a trace table or trace file (with rollover). Then give the developers access to the trace...

I would have thought so, too, but I've heard of others having similar experiences. Research in general she was very weak on... but the public school curriculum where she's at...

Did the "writer" understand the implications of plagiarism? Only reason I point this out is my wife helped tutor a student (7th grader) this year who hadn't been taught what...

Handling of NULLs. Primary Key can only have one particular combination with a NULL (consider the NULL a value like you would "1" or "Me"). Unique index can have multiple...