Trying to test that and see strange error 🙂

Msg 6517, Level 16, State 1, Line 2

Failed to create AppDomain "master.sys[runtime].37".

Exception has been thrown by the target of an invocation.

Good one!

I think yuo should plan your SQL Server installation in such way that log shrink is never needed (ok in some extreme cases - yes)

So - if your database is...

Hi, two things (in where clause)

1.

select name from sys.databases where database_id not in(1,2,3,4)

should be

select name from sys.databases where database_id >4

2.

Convert(varchar(10),id_updt,101) >=Convert(varchar(10),getdate()-3,101)

should be

Despite the question is not so precise :). We do not know what do you mena by 'database is full'. Maybe you think of it as a 'disk is full'?

About...

Try to do it that way:

UPDATE T

Set t.column_in_table = V.column_in_view

FROM Table T join View V

on T.a_table_column = V.a_view_column

WHERE <conditions>

great topic. no chance to test the code right now (have only mobile phone now) but how does the script behave if we have to specify the schema? we could...

Good one but it was not a question about the CMS but rather if you can read the text carefully 🙂

Kamil

super - przynajmniej znowu jestesmy znani na calym swiecie - nie tylko z milosci do cudzych samochodów

True - apps should inform about their perf counters.

But in the other hand - it is not common 🙂

Best regards

Damian

Have you enabled the OA in the server? Please check this via sp_configure:

sp_configure 'show advanced options',1

GO

reconfigure

GO

sp_configure 'Ole Automation Procedures'

You should see the run_value as 1. If not - set...

Hi, a general rule for saying if a parameter i optoionl or not is the business that the stored procedure must do. For example if you need to fill a...

You have 2 other options: use CASE a_column when null then 'the date' else a_column end

also - coalesce(a_column,'the_date') - maybe you need to cast

IMO this should be the service name taken from tnsnames.ora

Agree - I always teach my students to start with Express. It is really good enough to start the SQL Server journey 🙂

You can download also version with SSMS so...