or this;

select profile_id, name from [msdb].[dbo].[sysmail_profile]

/*

update [msdb].[dbo].[sysmail_principalprofile]

set is_default = 1

where profile_id = --Enter the profile_id number you want to make default

*/

like this. (uncomment the --exec (@deletecmd) )

USE AT YOUR OWN RISK!!!

create table ##table ([DB_Name] varchar(128) DEFAULT NULL,[Name] varchar(100), [Type] char(1), Default_Schema_Name varchar(128), Type_Desc varchar(128))

declare @DB_name nvarchar(250)

declare db_crsr_DBS cursor for

select name...

here is your select command from the above script;

select 'USE ['+[DB_Name]+']; DROP USER ['+[Name]+'];' from @table

try something like this to populate a table variable that you can use to create your PRINT command for execution.

declare @table table ([DB_Name] varchar(128) DEFAULT NULL,[Name] varchar(100), [Type] char(1), Default_Schema_Name...

yep, your script will delete users but only if they do not own any schemas.

your script will fail if it finds 'USER1' and 'USER1' owned a schema. This happens when...

this would be possible, however, it gets complicated if you are doing it on a SQL 2005+ server.

if the user owns a schema, you can't drop it until the schema...

removed reply.

i wouldn't do that in PROD. you could run that command in a lower enviroment and TEST, TEST, TEST.

you also never set @x or @z to start you while loop.

from a quick look, you are only trying to shrink databases that EQUAL 8500.

maybe you meant > 8500

I'm really curious as to HOW a dbcc checkdb runs cleans whilst a select query returns the I/O error...

if that is possible, then how would one know when the last...

SQL does this by design because reading memory is faster than reading from disk.

the bigger concern would be not HOW much memory is being used, but how WELL is the...

Hi Kim,

thanks for sharing. i would have to agree that this info you are after is easily gathered from the SQL Server Logs.

Also, you can get what you are after...

duplicate post.

http://www.sqlservercentral.com/Forums/Topic1311359-364-1.aspx

i think you mean the column in which you choose to partition by.

in partitioning, you choose a column in which to define the partition range. so if you have a...