|
|
-
RKA Liked 10 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
RKA Posted 10 Months ago through Just Learned
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 <columnname>
F...
|
-
RKA Posted 10 Months ago through Just Learned
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 <columnname>
F...
|
-
RKA Posted 2 Years ago through Just Learned
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
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 Learned 2 Years ago through Just Learned
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
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
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
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
Inorder to change the owner of the table to dbo, we can do like this.
[code]
sp_changeobjectowner '<tablename>', 'dbo'
GO
[/code]......
|