Activity overview
Latest activity by delbert
If I change the gui credentials to the same I use in the command line, I do get the same output. However, something is still not right because I get this in both:
CREATE TABLE [dbo].[User]
(
... Some Other Column definitions...
[IsActive] [bit] NOT NULL CONSTRAINT [DF_User_IsActive] DEFAULT -- Text was encrypted
)
As I said, if I'm using administrative credentials, I see the actual default value. This is a 2005 database, so I can't imagine there's an issue with the data actually being encrypted. / comments
If I change the gui credentials to the same I use in the command line, I do get the same output. However, something is still not right because I get this in both:
CREATE TABLE [dbo].[U...
This is a 2005 database, and as far as I'm aware, none of our objects are encrypted.
Now that you mention it, I am using my windows credentials when using the gui and more limited credentials when using the command line tool.
I'll use the same login information in both and see what I get. / comments
This is a 2005 database, and as far as I'm aware, none of our objects are encrypted.
Now that you mention it, I am using my windows credentials when using the gui and more limited credentials when ...
Command line vs gui snapshot creation
I came across something odd, and I'm not sure what's causing it.
I have a script that uses the command line to generate a snapshot of a database:
. $sqlCompare /server1:$sqlServer /database1:$sqlDb...