Hi Jeffry

I have downloaded the files but installing them gives me problems

Or the files stops when starting to initialyse, or I get the message "The update is not applicable to...

Thank you Jeffrey

I will download and install the files and will get back to you to inform you about the results

King regards

Hein

Hi Jeffry,

Thanks for your reply

I used the command:

cd d:\testdir

$directoryList = Get-ChildItem -Directory  | % { $_.FullName } | Sort-Object

foreach ($directory in $directoryList) {

$dirContents = Get-ChildItem -File -Path $directory | %...

Hello Brian,

I have made a directory (D:\TestDir) with some subDirs in it, as well as a number of files (aptly named file...).

I ran your code but keep getting errors that...

Thank you Brian for your reply

I am very new to Powershell and I am trying to learn it

I understand your suggestion (hopefully ?)

Except: how do I go from sub-directory to...

Sorry Sue
I need more time
This is all new for me, and a whole strange world opens when i look for clues to solve my problem
Time is running...

Thank you Sue for your reply.

I have tried to right click the ODBC data source and open it as an admin.
This gives me the same response as...

Thank you Steve for your advice.

On my previous computer I have worked with a linked server (for a while).
For small tables this was ok, for the larger...

Hi Ed,

Thanks for your contribution, appreciate it!

When I look in Windows Explorer I see that the .mdf file = 4.2Gb and the .ldf file is 3.8Gb

I have no need for...

Hi Scott and Jeff,

Thanks for your suggestions.

Maybe some answer to your suggestions:

I don't believe my databse is in full recovery mode, I turned it off. My database is a copy...

Thanks Michael,

In the meantime I tried some things.

I right clicked the SQL Server configuaration manager in the startmenu.

I saw that it is possible to pin this programm to the taskbar.

I...

Hi Michael,

Thank you for your reply.

It was very helpful. Using the << SQL Server Configuration Manager >> I stopped SQL Server from running.

After that I managed to move the 2...

Hi Lowell,

That is MUCH easier than the code I came up with, thanks.

1 question: if I want to join other tables to tbCompDistances, should I do that right behind /...

Hi Don,

Thanks for your reply.

What I am trying to do:

the field cdsDescription is filled automatically, using code I cannot reach since it is made by somebody else and which is...

Hi Lowell,

Thanks for your reply

If I change the code to (and add a select):

DECLARE @FirstBlankPosition INTEGER

SET @FirstBlankPosition = (SELECT CHARINDEX(' ', [cdsDescription], 1) FROM tbCompdistances)

SELECT cdsDescription, @FirstBlankPosition

FROM...