For 2005 - SQLServerManager.msc

For 2008/R2 - SQLServerManager10.msc

Hi,

The code seems valid and works fine on my system, try printing @results from the trigger to check if there is any issue while sending mail.

Hi,

AFAIK, this is not possible.

The partition key - the column used for partitioning must exist as a single column in the same table.

it will return accurate results, it is a dynamic management view.

Also, Add another condition as:

"index_id < 2"

Try This:

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count

FROM sys.dm_db_partition_stats st

WHERE OBJECT_NAME(OBJECT_ID) = N'TableName'

My Bad!..

you need to launch un-installation from Control Panel > Programs and Features

Start an uninstall of "Microsoft SQL Server 2008" (or R2), you will get the option to remove features.

🙂

Hi,

That's correct steps. You can deselect components you wish to remove on "Feature Selection" screen.

It is not actually a service pack for Management Studio, but full installation of Management Studio with service pack applied.

That is there because, if you do not have installed Management...

Just the normal service pack need to be applied.

Hi,

If you have SSMS installed on the system, SQLServer2008R2SP1-KB2528583 will also update it, you do not need to install SSMS again.

Hi Virendar,

You can generate scripts for DROP and CREATE using SSMS. but you will need to manually edit the script to change the ON clause.

Hi,

Upgrade Advisor is for upgrading editions from earlier versions of SQL Server.

Hi,

From BOL:

Memory usage is increased as needed by SQL Server until reaching the value specified in max server memory. SQL Server cannot exceed this memory usage unless the value of...

Does the file exist in specified location?

Are you able to access the file?