139 reputation
13
bio website twitter.com/wescrock
location Fresno, CA
age 28
visits member for 1 year, 4 months
seen Mar 12 at 19:02

I hold my MCITP in Database Development. Currently, I am working on learning as much about replication as possible... specifically, troubleshooting it when things go wrong. I work for a software firm that provides a solution for city and county health inspection agencies and I fill a role that is a hybrid of development and client services.


Feb
6
awarded  Popular Question
Jul
17
awarded  Popular Question
Jun
3
comment Create database role to allow read access to all tables; write access to some
Easy enough. Glad we have a community like this.
Jun
3
accepted Create database role to allow read access to all tables; write access to some
Jun
3
comment Create database role to allow read access to all tables; write access to some
That actually might be the simplest way... Is there a way to script that? I need to keep a set of scripts for whenever we refresh one of these databases, I can get all setting back instantly.
Jun
3
asked Create database role to allow read access to all tables; write access to some
Apr
17
comment Querying number of subscription to each publication
Yes, it was....
Apr
17
answered Querying number of subscription to each publication
Apr
17
asked Querying number of subscription to each publication
Apr
12
comment How database administrators can see my requests to SQL Server?
Someones trying to get himself fired...
Feb
4
comment é being converted from database to site
I'm assuming that I need to set it to UTF8 then... would this have any implications to other areas of the database?
Feb
4
comment é being converted from database to site
the result: CREATE DATABASE DBNAME /*!40100 DEFAULT CHARACTER SET latin1 */
Feb
4
asked é being converted from database to site
Jan
25
comment sp_startpublication_snapshot Parameter(s)
I am using EXEC sp_executesql to execute under the other database.
Jan
25
comment sp_startpublication_snapshot Parameter(s)
This might work... I'll give it a go.
Jan
25
asked sp_startpublication_snapshot Parameter(s)
Jan
24
revised SP for Restoring Database and performing other tasks on it
added 120 characters in body
Jan
24
accepted SP for Restoring Database and performing other tasks on it
Jan
24
comment SP for Restoring Database and performing other tasks on it
Marian, Thank you... this is what I was expecting. As far as CREATING a new backup, that won't be necessary... I have 2 backups that are going to be our bases. I appreciate your input and I'm going to call this solved. I will post another comment with a link to the script.
Jan
24
comment SP for Restoring Database and performing other tasks on it
@Zane Also, I found a method online that seems to work well, but I have only tested it with a sample, 3mb database... It restores from a .bak... I am wondering how it will perform with a 1.5gb database... off to testing! :D