That was...

madref (9/12/2016)

---

SQLite does not know TRANSFORM/PIVOT as in MS Access.

How can i make the next query/view in SQLite?

TRANSFORM First(IIf(IsNull([srt_afkorting]),"","x")) AS Afk

SELECT qry_Overzicht_Leden.Lid_ID, qry_Overzicht_Leden.Lid_Achternaam AS Achternaam, qry_Overzicht_Leden.Lid_Tussenvoegsel AS Tussen, qry_Overzicht_Leden.Lid_Voornaam AS...

Shaira (9/10/2016)

---

I have inherited a SQL 2000 database that the previous DBA archived data by removing the compound primary key used in the production table; unfortunately there are now thousands...

In my experience, putting the 'ON' clause on a new line is more of an 'old school' habit going back to the days when you could only fit 80 characters...

Did you copy the file into the two directories? Microsoft.SqlServer.Sqm.dll should be located in two folders.

Program Files (x86)\Microsoft SQL Server\100\Shared

Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

I think it can end up...

Michael L John (9/14/2016)

---

Concat null yields null.

One of the variables you are concatenating is null. So, you get nothing.

Add some print statements after you initialize each variable, and...

junk.mail291276 (9/14/2016)

---

I found three instances of sqlcmd.exe on my machine:

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\binn\sqlcmd.exe

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\binn\sqlcmd.exe

C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\sqlcmd.exe

Only 110 gave me the 1> prompt that you...

The script looks like it works - I was just messing with it.

Try changing your PRINTs to SELECTs - i.e. SELECT @cmd

Sue

When you open an issue on connect, I doubt you get an answer in a day. There are some bugs up there that have been active for years. When you...

DeWayne_McCallie (9/14/2016)

---

Starting with SSMS release 16 I have a bug where Security, Logins, User Mapping will not display the entire list of DB's due to the scroll bar not working...

You can use other machines and run it remotely as already indicated.

Another option is to just run a Powershell job step from SQL Server. It's pretty basic one to...

If it's the error log and not a log file and you want to read through it, it might be easier or faster (depending) to use xp_readerrorlog and filter it...

I've seen in with a lot of different versions and ran into the error at a couple of client sites as well. I don't think it's just limited to any...

I don't know either - I think there is a way using SqlLocalDB utility but I don't have a version to try.

See if you can connect to the...

junk.mail291276 (9/13/2016)

---

I'm attaching a screen shot of the results on this query.

The instance appears to be ACMCAL-LT160\LOCALDB#F1BD7ACE.

I put that into the backup command like so:

sqlcmd -S ACMCAL-LT160\LOCALDB#F1BD7ACE -E -Q "EXEC...