One reason for it can be that the application and SSMS are using different set options for the connections. Most of the time it is the setting of arithabort....

I have to admit that I have no idea how to check it using the GUI, and I don't know where you got the data. In any case the...

It could be that the constraint is not trusted. If you ever modified the constraint so it won't be checked and didn't changed it so it will be checked...

In many of the databases that I work with, we have a configuration table, that store information that is needed for various tasks. You could create such table and...

This is an orphaned DTC transaction. Unfortunately it still holds locks and causes blocking. The fallowing URL contains explanations and the way to kill this process ...

I think that first you need to define what you are looking for. For example if your application is slow due to slow I/O, you'll might want to check...

As far as I know it should work if the server's default directory for new databases is not the on the same drive that cannot be accessed anymore. Personally...

I would say that the best choice in this case is to start the server in minimal configuration. Why would you want to use undocumented trace flags instead of...

If you start the server using minimal configuration, the tempdb is created at the default directory instead of the directory that it is configured to use. It will also...

You can run the following statement in order to find out the procedure's creation date, last modified date and creator:

select create_date, modify_date, suser_sname(principal_id) from sys.objects where name = 'structuralcheck_mfs'

...

The procedure's execution plan has to generate a plan for all the DML statement that can be used regardless of the value of parameters and variables. Since the first...

This would work as long as it is guaranteed that that each number will...

Just run the installation software. Instead of selecting new installation at the first screen, you should choose maintenance and then "Edition upgrade".

Adi

You can still do it without joining the tables:

INSERT INTO TableName (Value1,value2)

select

(select value1 from table1),

(select value2 from table2)

Adi

Maybe there is a better way, but here is one way:

declare @Num numeric(8,7)

set @Num = 0.0000001

SET @Num = CASE WHEN CAST(@Num AS NUMERIC(3,2)) = @Num THEN @Num ELSE CAST(@Num AS...