|
|
-
Ashraf Liked 2 Years ago through Just Learned | 1 Point
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Ashraf Learned 2 Years ago through Just Learned | 1 Point
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Ashraf Learned 2 Years ago through Just Learned | 1 Point
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Ashraf Liked 2 Years ago through Just Learned | 1 Point
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLA...
|
-
Ashraf Liked 2 Years ago through Just Learned | 1 Point
In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view.
[code]
DECLARE
|
-
Ashraf Liked 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
91
·
2% ·
598
|
|
-
Ashraf 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
91
·
2% ·
598
|
|
-
Ashraf 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
91
·
2% ·
598
|
|
-
Ashraf Liked 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
91
·
2% ·
598
|
|
-
Ashraf Liked 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> SET O
|
|
RKA
91
·
2% ·
598
|
|