select substring('\Beverages\Soda Pop\Mountain Dew',patindex('%\%',substring('\Beverages\Soda Pop\Mountain Dew',patindex('%\%','\Beverages\Soda Pop\Mountain Dew')+1,100))+1,100)

might be permissions.

the downside to 2 IMHO, is that the drop will succeed and the the create will fail....

in option 1, if the alter fails, no harm no foul.

also, an alter does...

do you have a .fmt (format) file defined?

an account must be specified to "connect" to the instance that the plan runs on.

in the Maintenance plan designer, look up the top for a tab that says "Manage Connections..."

are the connections to the local instance using 'sa'?

if they are, you will have to update the connections properties to use the new sa password.

with 10 instances, i would also be concerned about how much RAM is on the server plus what each instance has its Maximum server memory settings to.

if you are asking...

yes, change your code a bit to do as Gail suggests.

DECLARE @ESTRecords TABLE

(

ESTime TIME(7) NOT NULL,

ESTDate DATE NOT NULL,

ESTDateTime AS ( CONVERT(DATETIME,...

Msg 402, Level 16, State 1, Line 6

The data types datetime and time are incompatible in the add operator.

What is the default? - Zero

10 is a little low, isn't it? - depends on how many blocks you want to see. if a block last longer than 10 seconds,...

Look under Errors and Warnings.....

well, if you want to use Profiler to capture blocks, you have to first turn it on via sp_configure.

SP_CONFIGURE'blocked process threshold',10 ;

GO

RECONFIGURE

;

GO

this sets the process to run...

for reporting, Right Click on the database you want to look at. Choose Reports --> Standard Reports --> All Blocking Transactions.

exec sp_who2 will also show Blocks in SSMS.

Unauthorized access is in the control of the DBA, no? If I say user1 can access the DB, then user1 can access the DB.

If i do NOT add user2 as...

esitmates are estimates and should be taken as such.