SSDT: Unable to connect to master or target server.
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
2,985 reads
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
2,985 reads
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
55 reads
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
55 reads
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing is that the description never matches the actual cause...
2017-06-12
18 reads
I like it when I get referred to speak at various functions. Whether it’s a user group, conference or just...
2017-06-12
103 reads
I like it when I get referred to speak at various functions. Whether it’s a user group, conference or just...
2017-06-12
314 reads
The best way to learn any software is to start using it. There are a bunch of software tools in...
2017-06-12
1,141 reads
I wrote recently about the Release agent using the hosted queue as the default, which is sometimes a problem. The...
2017-06-12
552 reads
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In this post, we’re going to leverage that configuration and...
2017-06-12
8 reads
In our previous post we discussed how to implement OpenSSH (the plumbing) as the transport layer for PowerShell remoting. In...
2017-06-12
764 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers