Posts
Sort by recent activity
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...
Source Control Production Server
Hi Guys
We are working with several vendor supplied databases and have many stored procedures, etc. that cross DB's (and a growing number that cross linked servers). The license for the main produc...
Prevent Formatting
Hi Guys
Is there a way to prevent a section of SQL code being formatted?
I have some long case statements with very short when clauses and I'd prefer not to format these as a normal case statement....