meta user
network profile
| bio | website | twitter.com/wescrock |
|---|---|---|
| location | Fresno, CA | |
| age | 27 | |
| visits | member for | 5 months |
| seen | Apr 18 at 14:11 | |
| stats | profile views | 17 |
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.
|
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 MSSQL 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 |
|
Jan 24 |
comment |
SP for Restoring Database and performing other tasks on it @Zane Yes, we have 2 different .bak files that they will choose from. We are going to be setting up a box with SQL Server 2008 and Server 2012. The 2 backups they will be using will not be changing, they will only be changing the DB's they create with the script. |
|
Jan 24 |
asked | SP for Restoring Database and performing other tasks on it |
|
Jan 2 |
revised |
SQL Server 2005 merge replication failure reignite question |
|
Jan 2 |
awarded | Benefactor |
|
Dec 31 |
comment |
Upgrade SQL Server 2005 to SQL Server 2012 It's making me wait 10 hrs. before I can award the bounty. I'll post it when it's available. |
|
Dec 31 |
accepted | Upgrade SQL Server 2005 to SQL Server 2012 |
