How can we help you today? How can we help you today?
mark_anderson_us
Activity overview Badges (0) Posts (12) Comments (13)

Activity overview

Latest activity by mark_anderson_us

Change Key during Update
  1. Community
  2. SQL Data Compare 11
I am inserting data from a source table (several actually). The PK is an int (60 in the source table), but in the target 60 has been used, so I need to change anything with 60 in the source field t...
1 follower 1 comment 0 votes
Remove all alerts for a Db
  1. Community
  2. SQL Monitor Previous Versions
Hi Guys We recently decommissioned some DB's, How do I stop ALL alerts for these (offline, backup overdue, etc.)
1 follower 1 comment 0 votes
SQLMonitor4 user - Also evaluating Idera SQL Diagnostics man
  1. Community
  2. SQL Monitor Previous Versions
Hi All I've been using Red-gate SQL monitor for a few years and was at a conference recently where I got to see Idera's SQL Diagnostic Manager. I have a trial installed alongside Red-gate. This is ...
1 follower 1 comment 0 votes
Brian Donahue wrote: Hi Mark, It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself? Never thought to check compatibility level. Will take a look next time I connect / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Datatype not supported in the target database version
Brian Donahue wrote: Hi Mark, It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself? N...
0 votes
Datatype not supported in the target database version
  1. Community
  2. SQL Compare Previous Versions
Severity: High Object: SG_WIP_BI Title: The datatype of the parameter @ EndDate of stored procedure [dbo].[SG_WIP_BI] is not supported in the target database version. Hi guys Any idea why I'm getti...
2 followers 2 comments 0 votes
Dependency Resolution
  1. Community
  2. SQL Dependency Tracker
Anyone goy any ideas why I'm getting this: Category Parsed Dependency Resolution Received 8/22/2013 12:04:33 PM Unable to resolve object '[Live_Customers].[dbo].[Company]' in unknown database '[SER...
2 followers 2 comments 0 votes
Cannot add database to Soruce Control - Setup tab corrupt
  1. Community
  2. SQL Source Control Previous Versions
Hi All Trying to a dd a DB from a remote server to source control. When I go to setup tab the top section (where the buttons should be) is virtually blank.
2 followers 2 comments 0 votes
Hi Steve I did try that with one of the DB's but it wanted tme to drop a ton of stuff. Tried again this monring and it worked fine Thanks for answer Regards Mark / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Shared DB with multiple users
Hi Steve I did try that with one of the DB's but it wanted tme to drop a ton of stuff. Tried again this monring and it worked fine Thanks for answer Regards Mark
0 votes
Shared DB with multiple users
  1. Community
  2. SQL Source Control Previous Versions
Hi Guys I'm just setting up source control with a shared database. I connected to SQLServer with SSMS and Linked a database to Source Control. Another user connected to same SQL server, but DB does...
2 followers 2 comments 0 votes
peter.peart wrote: Thanks for your post. You're going to need a separate repo for each DB, I'm afraid. Pete Thanks Pete Not a problem. Will just group them under a single folder / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Multiple DB's in VisualSVN Repository
peter.peart wrote: Thanks for your post. You're going to need a separate repo for each DB, I'm afraid. Pete Thanks Pete Not a problem. Will just group them under a single folder
0 votes
Total activity
32
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
7