Looking at the error messages/warnings it pointed me to be an application error...

What is the command that the user executes and what is the error/warning returned?

Membership of DB_DDLADMIN should give sufficient...

I don't know Flyway, but maybe this link can point you to the right connection.

Did you already try to connect from your host to the SQL server without using Flyway...

Please provide us with some DDL (create table) commands and some sample data (insert). Also specify the desired output based on the provided sample data.

You also need to specify the...

create table table1(Date date,A int)

insert into table1 values('01-01-2016', 10)

insert into table1 values('02-01-2016', 12)

create table table2(Date date,B int)

insert into table2 values('01-01-2016', 9)

insert into table2 values('03-01-2016', 5)

create table table3(Date date,C int)

insert into...

This code will read the default trace and extract the...

sgrimard (2/5/2016)

---

I don't think we have activated that policy. And it did not specify if it was the LDF or MDF.

So turn off Auto-Growth on LDF? What would you set...

sgrimard (2/5/2016)

---

My questions are;

1) Why did this start happening now when the application has been live for more than a year?

2) What causes this issue?

3) Is backing up transaction log...

patla4u (2/2/2016)

---

Hi All,

I got one task where I need to bring data from SQL server which is on citrix server to our local sql server. We have only access...

In this article https://msdn.microsoft.com/en-us/library/bb510680(v=sql.120).aspx you'll find a comparison between compatibility level 110 and 120.

I am not sure but I guess it's due to the setting of the international locale in Windows. For the Windows account it will take the setting from this account...

Have you tried the parameters listed in the samples on this blog:

Export Data AS CSV from Database Using SQLCMD[/url]

sorry, replied to the wrong post :w00t:

The queries below will give you the desired information:

declare @nr_of_files int

-- determine the number of max. available SQL ERROR files

EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\MSSQLServer'

, N'NumErrorLogs'

, @nr_of_files OUTPUT

-- when value is NULL,...

take a look at this link Tutorial: Signing Stored Procedures with a Certificate

edit: corrected the link