What you are describing looks like the cache is being cleared when the database property is changed.  The execution plan and data were removed from the cache and it will...

• This reply was modified 1 year, 7 months ago by  Sal Young.

This is a bit late and I hope you already figured it out.  In the case that you have not, here is how I do it.

1. From my laptop, I...

Here is what I use to see data & log file growth

/*
-------------------------------------------------------------------------------------------------
   NAME: DB_RecentFileGrowth.sql
MODIFIED BY: Sal Young
   EMAIL: saleyoun@yahoo.com
DESCRIPTION: Displays...

This is a promising script but I'm having some issues. 

1. If there are other file(s) or folder(s) in the drive that match the pattern "ERRORLOG" it may go to...

I will assume you are using a programming language that is more efficient with patterns and string search to collect all these RSS feeds. Why not do your search...

Here is my list of recommended steps

1. Develop a plan to learn the basics. The recommendations provided in this thread about your T-SQL skills are key and should be at...

Help up help you by executing the code below on your server and replying to this conversation with the result. Replace the "YourDB" values with your database name.

SET NOCOUNT ON

USE...

charipg,

You can take a look at the blog entry at the link below. Let me know if it helps!

How Do You Remove Logins From Your SQL Environment[/url]

[font="Verdana"]Adam,

I read your article and enjoyed every bit of it. Your writing style is superb and is consistent with the word “Introduction” from the title. I have read...

Can someone tell me why I can't execute the Get-InvalidLogins. I set-location to the folder with all the SQLPSX code and execute as follow

PS [TPT60P]>.\Get-InvalidLogins

Unexpected token 'foreach' in expression...

You could also use the system stored procedure sp_spaceused 'YourTableName' .  I actually saved...

All you need is the "SQL Server Business Intelligence Development Studio" (included in the SQL 2005 installation DVD) or "Visual Studio 2005".  Create a connection using the Server Explorer.  Then,...

Found the answer!

In MS SQL Server Management Studio, you have to give yourself exec rights to the dbo.sp_sdidebug extended stored procedure.  This procedure is located in master > Programmability > Extended Stored...

Wayne,

I'm going through the same thing right now and the only thing that comes up is the "Output" window with the result from executing the stored procedure.

I'm still researching & will...