Activity overview
Latest activity by merk
sql compare 10.5 - change log?
Just wondering if there's a change log of what changed with the 10.5 update?
thanks
Thanks - is there a link to view all pending feature requests? / comments
Thanks - is there a link to view all pending feature requests?
Can i select only items that are dependent based on columns?
Is it possible using dependency tracker to select only related items if they read or update a specific column?
e.g. I have Table A and I only want to see other tables/sprocs/functions etc that do a...
I did run into some issues - there was one stored proc which is was listing as conflicting and would not allow me to tell it to just over-write the sproc in source control.
I had to delete the sproc from my db, get it from source control, apply changes and then commit it.
The folder structure did not change, it just moved down one level.
i.e. /project/sql became /trunk/project/sql
I think it might be nice to have an option to just be able to update the source control url, rather then having to delink/relink the db.
thanks / comments
I did run into some issues - there was one stored proc which is was listing as conflicting and would not allow me to tell it to just over-write the sproc in source control.
I had to delete the spro...
I guess this isn't a very high priority request considering that feature request is from may of 2011 ;)p I voted for it anyhow though. / comments
I guess this isn't a very high priority request considering that feature request is from may of 2011 ;)p I voted for it anyhow though.
setting up full-text index
It would be really cool if source control could handle setting up the indexing on any tables that have full text index set up. It makes a task that would otherwise be very quick an easy somewhat te...
SVN folder structure changed - how do i update source contrl
I moved my folder structure around in SVN. I need to update the folder that source control is pointing to.
This is the database repository url - i can see this setting when i click on the 'setup li...
here's the full sql USE [MachineSales]
GO
/****** Object: StoredProcedure [dbo].[spViewProductStatisticByUserID] Script Date: 8/3/2012 1:48:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spViewProductStatisticByUserID]
@ID INT,
@StartRow INT,
@PageSize INT
AS
BEGIN
SET NOCOUNT ON
SELECT p.[ID], p.[Title], p.[ShortDescription], p.[Price], img.[ImageThumbID] AS [ImageID], ps.[SearchResults], ps.[PageViews], ps.[PhoneClicks], ps.[EmailClicks], ps.[WebsiteClicks],
p.[Modified], p.[ModifiedBy], p.[Created], p.[CreatedBy]
FROM [Product] AS p
INNER JOIN [ProductStatistic] AS ps ON ps.[ProductID] = p.[ID]
LEFT JOIN [ProductImage] AS img ON img.[ProductID] = p.[ID] AND img.[SortOrder] = (SELECT MIN([SortOrder]) FROM [ProductImage] WHERE [ProductID] = p.[ID])
WHERE p.[Deleted] = 0
AND p.[UserID] = @ID
ORDER BY p.[Created],p.[ID] DESC
OFFSET @StartRow ROWS
FETCH NEXT @PageSize ROWS ONLY
END
/ comments
here's the full sqlUSE [MachineSales]
GO
/****** Object: StoredProcedure [dbo].[spViewProductStatisticByUserID] Script Date: 8/3/2012 1:48:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFI...
error parsing file right after CREATE statement
I'm trying to use sql source control. This is a new install on a new machine. I've linked my dev database to the source control (SVN). I'm on the 'get latest' tab and that is where i get the error....
cache permission issue with 3.9 and 2008 r2
I've tried specifying the SA login for this database, to no effect. I also tried specifying a false login for this database and i get the same results. So i'm wondering if sql prompt is actually us...