|
|
-
Guru Samy Learned 4 Months ago through Just Learned
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Guru Samy Liked 4 Months ago through Blogs
Working with SQL Server logins and users is one of the most important and critical activities when moving databases from one SQL Server instance to another. The hash value for SQL Server logins created in SQL 7.0 or earlier are 16-bit values and are no ...
|
|
|
|
|
-
Guru Samy Liked 4 Months ago through Blogs
This blog will explain how we can create separate columns out of a delimited (Pipeline or comma) values...
|
-
Guru Samy Liked 4 Months ago through Blogs
DDL Changes Log additional changes in script to get client IP...
|
-
Guru Samy Liked 4 Months ago through Blogs
SQL Server has the ability to enforce organzational security policies for SQL login passwords. This can be bypassed by using the CHECK_POLICY clause in the CREATE LOGIN statement. However, when using hashed passwords, no such restrictions seem to apply....
|
-
Guru Samy Liked 4 Months ago through Blogs
How to create DDL Change Log using Service Broker,for multiple databases on a single instance....
|
|
|
-
Guru Samy Liked 4 Months ago through Blogs
If you use simple recovery model for your SQL database, you can do both database backups as well as file backups. Your restoration needs may vary depending on the scenario. ...
|