So the next...

Someone ask me if Kaplan's Self Test Software and Transender violate the NDA?

Your input is greatly appreciated.

http://www.selftestsoftware.com/generic.asp?page_id=p00579

sqlquest2575 (7/10/2011)

---

When i open MS access file and i see there is a tab says queries and when click on that i see 8 queries and two of them are(qry_Reports...

http://blog.sqlauthority.com/2009/11/08/sql-server-stored-procedure-are-compiled-on-first-run-sp-taking-longer-to-run-first-time/

http://msdn.microsoft.com/en-us/library/ms190439.aspx

http://sqltutorials.blogspot.com/2008/03/with-recompile-re-compile-execution.html

Functions are not pre-compiled.

http://www.sql-server-performance.com/2006/stored-procedure-function/

I take it that you resolved you problem since it has been months from your initial post? 😀

I agree that the Microsoft Training Kits are very good and you get a 15% discount on the exam

I usually supplement the Microsoft Material with most of the Sybex Books.

I...

Couldn't you add a task with @@SERVERNAME.

If the correct server is not returned then exit the package, otherwise continue or execute a child package.

I think that something like Lowell option would work for...

I was wondering how you can prevent a member of the db_owner from from disabling or altering the trigger?:-)

What permissions does the Account that was used to create the DSN?

When you created the DSN did you select the default database as the on with the table that you...

I had a situation where an Admin was installing a Vendor Database application.

He was setting all of the users and the Vendor Instructions instructed him to make all users members...

In my opinion it is good that if your an Admin on a box you no longer inherit the sysadmin role.

Every System Administrator had full control of SQL Server by...

By default, the local Windows Group BUILTIN\Administrator is no longer included in the SQL Server sysadmin fixed server role on new SQL Server 2008 installations.

Regards,

WC

Suggested Max Memory Settings for SQL Server 2005/2008

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

Does the role that she belongs to have a deny to that object or is that role a member of the db_denydatareader or something to that effect? What happens...