No, it's available in any version but not editable via SSMS

You just have to run :

ALTER DATABASE YourDb SET TRUSTWORTHY ON

to try if it helps

I'm not sure this is something new with iis7 but recently we had some problem with some application when failover occured.

This was due to a not explicit enough error given...

you could create a stored procedure your application is allowed to execute and use the EXECUTE AS option in that SP so that it is executed with a sysadmin account.

- Do you execute msdb.dbo.sp_start_job @job_name = 'job_name' being connected as 'domain\login' ?

- What about trustworthy option in the database where the stored procedure is ?

Hi

Use sql profiler.

Track all "statement completed" events having a high duration and then tune the bad query.

Perry, replication in my eyes is the most effective of all Redundancy and Availability when set up and monitored correctly. It offers the best value for money for hardware usage...

Did you try this :

telnet your_ft_server 22

?

(22 = default port used for ftp.)

Ping and ftp use different port numbers.

Maybe your network administrator has to open something so that...

Use this :

sp_MsForeachdb '

Use ?

select db_name(), * from sys.objects where name = ''your_object_name''

'

then you will see in which db youyr object is and what type it is :

U = user...

It looks like a distributed query, ie. a query or stored procedure being executed on another server via a linked server (DTC is the Distributed Transaction Coordinator service).

You can...

Hi

Are you sure this is the exact command you use :

SELECT fileds FROM LS_DBF...dbf_database

?

I don't see anything about 'MB1928_201111_1' which is in the error message.

Change

$Output = Get-WmiObject Win32_logicaldisk Format-Table DeviceId, MediaType, Size, FreeSpace -auto

to

$Output = Get-WmiObject Win32_logicaldisk | Format-Table DeviceId, MediaType, Size, FreeSpace -auto

First, you can retrieve information about current autogrowth parameter in sys.database_files

if is_percent_growth = 1 or growth <> 655360 (it means 655360 pages of 8 kb = 655360 * 8...

What information do you have when you run

KILL your_spid WITH STATUSONLY;

GO

?

You should have something like this :

spid 54: Transaction rollback in progress. Estimated rollback completion: 80% Estimated time left:...