Script to look at all articles in all publications in a DB to find replicated columns of certain data types. I used this to find BLOB columns that we wanted to remove from the articles.
2004-08-09 (first published: 2004-02-19)
444 reads
Based on moffan76's script to GRANT EXEC to all sprocs and UDFs (that EXEC) and GRANT SELECT to views and UDFs (that SELECT). This script uses that same general technique of selecting the object names from sysobjects, but does it in one step w/o using a cursor. It is also not wrapped in a sproc […]
2003-12-30
188 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...