Posts
Sort by recent activity
Change Key during Update
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...
Remove all alerts for a Db
Hi Guys
We recently decommissioned some DB's, How do I stop ALL alerts for these (offline, backup overdue, etc.)
SQLMonitor4 user - Also evaluating Idera SQL Diagnostics man
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 ...
Datatype not supported in the target database version
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...
Dependency Resolution
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...
Cannot add database to Soruce Control - Setup tab corrupt
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.
Shared DB with multiple users
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...
Multiple DB's in VisualSVN Repository
Hi Guys
Just setting up source control on new server. We have a vendor supplied app which uses 7 databases (clearly they never heard of schemas or anything like that). Anyway, when I setup reposito...
Anyone Used SQLExpress2008 for the StatsDB
Hi Guys
I have a dedicated VM for SQLMonitor and few other utils. I like to get the DB's for SQLMon on here too. Anyone ever tried ti with SQLExpress2008 (will be monitoring regular 2005 and 2008 s...
Failure to detect/notify server offline
Hi All
We had a problem with out SQL server last night. The SQL server was offline (connections to it failed) from about 2:45am. I had a lot of messages about prior to this about long running queri...