leancz

Frankfurt Am Main, Germany

Age: 48

May
6
answered How to minimize log operations in SQL Server to avoid "log full" error
Apr
20
awarded Caucus
Mar
13
awarded Yearling
Mar
13
awarded Yearling
Mar
9
answered JSON read from sparkcore to python
Mar
2
awarded Notable Question
Feb
13
comment SQL Job used as JobScheduler
Any reason why you don't create one job with a number of job steps?
Jan
2
answered SQL First capital letter - Function bad performance
Nov
5
awarded Student
Oct
29
revised powershell failing to import module
Added extra detail to this answer to clarify why and to offer a couple more solutions applying to the same underlying cause.
Oct
16
answered How can I configure a default server connection in SSMS for when I open any .sql script file?
Oct
6
reviewed Needs Improvement Is the golden rule considered childish in philosophy?
Oct
6
reviewed Needs Improvement What a "Bismarckian realist"
Oct
6
awarded Custodian
Oct
6
reviewed Satisfactory Who owns the means of production?
Aug
7
comment SQL Server : trigger to retrieve duplicates and stop them from being entered whilst inserting new values
If you try to insert with a duplicate key you should get an error: Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row in object 'dbo.Bob' with unique index 'IX_Bob'. The duplicate key value is (1). Check for this exception/error in your code.
Jul
25
awarded Commentator
Jul
25
comment Apache 2.4.7 on Ubuntu 14.04 will not connect to MSSQL through PHP 5.5
Does the database test exist? Does "myuser" have rights to the test database? Can you connect to a different ODBC source? Can you post the SQL Server errorlog relevant messages (if any)?
Jul
23
answered Set Database Options in an Entity Framework Code First Database
Jul
22
answered Trouble connecting tsql to SQL Server
1 2 3 4 5