must be a routing issue.

Check the path ( tracert ) which your connection has to follow to be able to connect to your instance.

- router/switches/vlans/Wirewalls/...

• does it also need that...

Double check if the target backup location hasn't been switched to a (windows) compressed volume !

Have a look at : "clustered-and-nonclustered-indexes-described"

and /  or "Effective Clustered Indexes"

There is a nice "Stairway" series about XML

Did you searched SSC for a split string article ?

"Tally OH! An Improved SQL 8K “CSV Splitter” Function"

Execute the sproc in PlanExplorer ( free tool ) to record its full execution plan en explore the marvels of that tool.

DEVOPS is a buzzword !!!!! Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO ! ... Multiple projects /...

Check Shutdown

DEVOPS is a buzzword !!!!!

Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO !

The only guideline you get is: "start small...

Why on earth would you use data type FLOAT ????  ( especially if smallint / tinyint ) would do !

Does it hold blobs ? ( of tables that reside in other filegroups TEXTIMAGE_ON yourtroubledfilegroup)

or indexes of tables/views that reside in other filegroups ?

• This reply was modified 3 years, 6 months ago by Johan Bijnens.

Generate your test code:

Select 'DECLARE @test VARCHAR(5) = ''€'';
SELECT convert(char(100),'''+name+''' ) AS DBCollation, @test collate ' + name + ' AS VarcharText;
GO
' SelectQueries
from fn_helpcollations()
where name like '%latin%'
order...

have a look at "SET options"

have a read at: "Encrypt a Column of Data"

Great example on how naming variables ( etc ) can be confusing and lead you totally out of focus