Truncate data from all tables in a database
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
478 reads
Grant EXECUTE permission to users
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
213 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
DOP_FEEDBACK in SQL MI
I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...
index analysis help
Hi All, We see some tables in Prod are having 20-30 indexes and we...
Accessing SSAS Cubes on Mac
Hi, Can someone please let me know if it will be possible to create...
Ask SSC