User profile for brucekillam

Yes, this seems be the problem and if you could add a link to this thread to the bug report, that would be much appreciated. / comments

Yes, this seems be the problem and if you could add a link to this thread to the bug report, that would be much appreciated.

0 votes

Generated script for Triggers

I've got a db where I've modified a ton of table triggers and am trying to get SQL Compare to Sync them. The compare window sees the differences and generates the script, but when have it do the sy...

2 followers 3 comments 0 votes

Without applying my workaround, if I put the cursor to the left of the * and try to force the candidate list with CTRL+SPACE it offers no suggestions. An example of this would be the following query (run from the ReportServer db): SELECT * FROM [ReportSchedule] P10tbl JOIN [Catalog] R17fk ON P10tbl.ReportID = R17fk.ItemID JOIN [Subscriptions] R18fk ON P10tbl.SubscriptionID = R18fk.SubscriptionID JOIN [Schedule] R19fk ON P10tbl.ScheduleID = R19fk.ScheduleID Copy from the first character of the query to the last and paste it into a new query window (I'm using SSMS) and put the cursor after the * and hit tab. What I get is the following (notice that it only gives columns for the first two tables - P10tbl and R17fk; R18fk and R19fk seem to be ignored): SELECT P10tbl.[ScheduleID], P10tbl.[ReportID], P10tbl.[SubscriptionID], P10tbl.[ReportAction], R17fk.[ItemID], R17fk.[Path], R17fk.[Name], R17fk.[ParentID], R17fk.[Type], R17fk.[Content], R17fk.[Intermediate], R17fk.[SnapshotDataID], R17fk.[LinkSourceID], R17fk.[Property], R17fk.[Description], R17fk.[Hidden], R17fk.[CreatedByID], R17fk.[CreationDate], R17fk.[ModifiedByID], R17fk.[ModifiedDate], R17fk.[MimeType], R17fk.[SnapshotLimit], R17fk.[Parameter], R17fk.[PolicyID], R17fk.[PolicyRoot], R17fk.[ExecutionFlag], R17fk.[ExecutionTime] FROM [ReportSchedule] P10tbl JOIN [Catalog] R17fk ON P10tbl.ReportID = R17fk.ItemID JOIN [Subscriptions] R18fk ON P10tbl.SubscriptionID = R18fk.SubscriptionID JOIN [Schedule] R19fk ON P10tbl.ScheduleID = R19fk.ScheduleID / comments

Without applying my workaround, if I put the cursor to the left of the * and try to force the candidate list with CTRL+SPACE it offers no suggestions. An example of this would be the following quer...

0 votes

Expand SELECT *

I have a script that generates queries and quite often these queries contain many joins. When I copy this query into a new query window in SSMS and place my cursor after the '*' and hit tab, only c...

3 followers 4 comments 0 votes

Snippets

When I type AU in SSMS, the popup window doesn't display anything. When I type a space after the AU, I get a whole list of choices starting with A. Shouldn't it recognize this and give me the snipp...

1 follower 1 comment 0 votes

How can we help you today?

brucekillam

Activity overview