|
|
-
RKA Posted 10 Months ago through Just Learned | 5 Points
While writing a query with joining two tables from two different dbs, a collation error was encountered.
'Cannot resolve collation conflict for equal to operation.'
Fix:
add keyword `COLLATE DATABASE_DEFAULT` after join .
SELECT
F...
|
-
RKA Posted 10 Months ago through Just Learned | 5 Points
While writing a query with joining two tables from two different dbs, a collation error was encountered.
'Cannot resolve collation conflict for equal to operation.'
Fix:
add keyword `COLLATE DATABASE_DEFAULT` after join .
SELECT
F...
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SET O
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SE...
|
-
RKA Learned 2 Years ago through Just Learned | 1 Point
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SE...
|
-
RKA Learned 2 Years ago through Just Learned | 1 Point
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SE...
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Suppose, We need to block the access to current database and for that decided to make the db offline.
For this, right click db->task-> offline.
But it won't work, if some connection still open.
Fix:
[code]
ALTER DATABASE <dbname> SE...
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Inorder to change the owner of the table to dbo, we can do like this.
[code]
sp_changeobjectowner '<tablename>', 'dbo'
GO
[/code]
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Inorder to change the owner of the table to dbo, we can do like this.
[code]
sp_changeobjectowner '<tablename>', 'dbo'
GO
[/code]......
|
-
RKA Posted 2 Years ago through Just Learned | 5 Points
Inorder to change the owner of the table to dbo, we can do like this.
[code]
sp_changeobjectowner '<tablename>', 'dbo'
GO
[/code]......
|