Comments
Sort by recent activity
That's some interesting behaviour! Not having keyboard shortcuts would make me very sad [image]
A quick google threw up this : http://blog.hoegaerden.be/2009/01/25/ss ... t-working/ which might be worth a go? Which version of SSMS are you using? / comments
That's some interesting behaviour! Not having keyboard shortcuts would make me very sad
A quick google threw up this : http://blog.hoegaerden.be/2009/01/25/ss ... t-working/ which might be wort...
Ohh, I didn't know you could do that! Sounds handy. Thanks for reporting the bug. I've raised it in our issue tracking system and we'll look at fixing it in a future release.
Simon / comments
Ohh, I didn't know you could do that! Sounds handy. Thanks for reporting the bug. I've raised it in our issue tracking system and we'll look at fixing it in a future release.
Simon
Thanks for pointing this out. I'm afraid we don't support fully the aliased syntax for updates. I've raised the issue in our bug tracking system and we will look at fixing it in a future release.
Thanks again
Simon / comments
Thanks for pointing this out. I'm afraid we don't support fully the aliased syntax for updates. I've raised the issue in our bug tracking system and we will look at fixing it in a future release...
Currently we show errors when we can't cache the database it looks like you're writing a query against. Management studio is clever enough to switch your query onto master in the case of offline databases, prompt isn't quite clever enough to realise this yet!
I've raised the issue in our bug tracking system, and we'll consider changing the behaviour in a future release.
Thanks
Simon / comments
Currently we show errors when we can't cache the database it looks like you're writing a query against. Management studio is clever enough to switch your query onto master in the case of offline d...
It's an interesting idea. I can see that keeping long frequently edited scripts as snippets might not be ideal, apart from anything else you can't use prompt whilst editing them! I'll record your asking for some management of templates, and we'll see if there's anything that could be done to help. Access to recently executed queries is something we've heard a few people asking for, and this idea seems like it might partner nicely with that.
Thanks for the feedback
Simon / comments
It's an interesting idea. I can see that keeping long frequently edited scripts as snippets might not be ideal, apart from anything else you can't use prompt whilst editing them! I'll record you...
Thanks for the feedback. Would it be possible to get you to send me the log file ( located in C:\Documents and Settings\<User>\Local Settings\Application Data\Red Gate\SQL Prompt 4\ ) to
simon <dot> jackson <at> red-gate.com so that I can look into the issue further.
It would also be useful to know which version of SSMS and SQL Server you are using, and whether you have, or have had, any other add ins installed in SSMS.
Thanks
Simon / comments
Thanks for the feedback. Would it be possible to get you to send me the log file ( located in C:\Documents and Settings\<User>\Local Settings\Application Data\Red Gate\SQL Prompt 4\ ) to
simon <do...
Oops, sorry. Email to
simon <dot> jackson <at> red-gate <dot> com
Would be excellent. / comments
Oops, sorry. Email to
simon <dot> jackson <at> red-gate <dot> com
Would be excellent.
Would it be possible to send me one of these (in descending order of preference):
- A backup of the database
- A SQL Compare snapshot of the database
- The SQL used to create the schema of the database / comments
Would it be possible to send me one of these (in descending order of preference):
- A backup of the database
- A SQL Compare snapshot of the database
- The SQL used to create the schema of the data...
Ah, the equivalent query for SQL 2000 is
SELECT sysobjects.* FROM sysobjects LEFT JOIN sysusers ON dbo.sysusers.uid = dbo.sysobjects.uid
WHERE sysusers.name is null / comments
Ah, the equivalent query for SQL 2000 is
SELECT sysobjects.* FROM sysobjects LEFT JOIN sysusers ON dbo.sysusers.uid = dbo.sysobjects.uid
WHERE sysusers.name is null
Thanks for the feedback.
It doesn't look like an insufficient memory problem, but rather a problem with cacheing your database.
It would help us solve your problem if you could answer a few questions:
- Which version of SQL Server were you connecting to
- Does this error occur repeatedly, on all databases, or was it just once on one database?
- If the error occurs repeatedly on one database could you run this query against it and post/pm me the results (if any):
SELECT sysobjects.name ,
schemas.name ,
id ,
uid ,
type ,
xtype
FROM sys.sysobjects
LEFT JOIN sys.schemas ON sysobjects.uid = schemas.schema_id
WHERE sys.schemas.name IS NULL
- Is it likely that the database schema changed whilst it was being cached by prompt? / comments
Thanks for the feedback.
It doesn't look like an insufficient memory problem, but rather a problem with cacheing your database.
It would help us solve your problem if you could answer a few questio...