|
|
-
Latha Posted 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
Latha Posted 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
Latha liked 2 Years ago through Interview Questions
Suppose we have a table whose structure is given below
Create table addcounter( counterid int identity(1,1))
Now how can we insert values in the table?...
|
-
Latha Posted 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reused,
|
-
Latha Learned 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
Latha Learned 2 Years ago through Just Learned
If you come across the following error while running a T-SQL query or executing a stored procedure or in a SSIS package execution which states:
"The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reuse...
|
-
Latha liked 2 Years ago through Interview Questions
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
-
Latha Commented 2 Years ago through Interview Questions
Permissions needed to perform TRUNCATE or DELETE operation:
1. To truncate a table, you need at least ALTER permissions on the table (which is granted by default to the table owner, members of the sysadmin fixed server role, and the
db_owner ...
|
-
Latha Posted 2 Years ago through Just Learned
Here is the script to select all the table constraints and tables to delete:
[code]
SELECT 'ALTER TABLE ' + TABLE_NAME + ' DROP CONSTRAINT ' + CONSTRAINT_NAME AS SQLStatement
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAI...
|
-
Latha Posted 2 Years ago through Just Learned
Here is the script to select all the table constraints and tables to delete:
[code]
SELECT 'ALTER TABLE ' + TABLE_NAME + ' DROP CONSTRAINT ' + CONSTRAINT_NAME AS SQLStatement
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE CONSTRAI...
|