Comments
Sort by recent activity
Thank Tanya, is there a better description of what this layout functionality provides?
Thanks. / comments
Thank Tanya, is there a better description of what this layout functionality provides?
Thanks.
I must be a little slow this morning, but I can't seem to find anything on red-gate's site that lists the differences between pro and standard.
I'm told I can upgrade to pro, but I haven't found a reason as to "why" I would want to.
Could someone point me in the right direction please? [image] / comments
I must be a little slow this morning, but I can't seem to find anything on red-gate's site that lists the differences between pro and standard.
I'm told I can upgrade to pro, but I haven't found a ...
When I click on a tooltip for a sproc/view/etc, the window that opens does not respond to the scroll wheel, instead - the main query window rolls up and down.
I hate to say I'm a creature of habit, but ever since that wheel has been introduced, I'd have to say that now I use it to move up and down in a page more than anything else. So I find myself scrolling faster and faster trying to figure out why the window isn't moving. [image]
I tried clicking within the window just in case, or highlighting some of the text, but no dice. If that could be made to work, it would be GREAT! / comments
When I click on a tooltip for a sproc/view/etc, the window that opens does not respond to the scroll wheel, instead - the main query window rolls up and down.
I hate to say I'm a creature of habit,...
One thing that happened to me when I installed 3.8 RC was that the cache I had for all of my servers went away. Including all of my connections to each of the servers.
I was able to add the connections and have it rebuild the cache(s), but it was odd that they just disappeared.
Another thing that I noticed (and I don't remember if it behaved this way prior to 3.8) is that if I do an "execute sp_help "- I am not prompted with a list of tables. I get sprocs/functions, but not tables. / comments
One thing that happened to me when I installed 3.8 RC was that the cache I had for all of my servers went away. Including all of my connections to each of the servers.
I was able to add the connec...
Good news - I found that I can get this by installing one of the Feature Pack products. http://www.microsoft.com/downloads/deta ... layLang=en
This is the actual product needed, it's the Backward Compatability Pack: http://download.microsoft.com/download/ ... 005_BC.msi
Any plans on rewriting this so that it supports SQL 2005 natively? Or at least doesn't rely on SQL 2000 tool sets? I'm sure that it's because I uninstalled SQL 2000 that I lost this file. I wonder how many other people will loose this when then uninstall SQL2k from their machines?
At least it seems to be working - the SQL Backup Agent software started, so that's a good thing. [image] / comments
Good news - I found that I can get this by installing one of the Feature Pack products.http://www.microsoft.com/downloads/deta ... layLang=en
This is the actual product needed, it's the Backward Co...
this file doesn't exist anywhere on my machine. [image] / comments
this file doesn't exist anywhere on my machine.
I don't have this directory "C:\Program Files\Microsoft SQL Server\80\COM\" anymore. It looks like it went when I uninstalled SQL 2000.
Do I need to reinstall SQL 2000 now?
I also checked on that key and it's not in my registry. / comments
I don't have this directory "C:\Program Files\Microsoft SQL Server\80\COM\" anymore. It looks like it went when I uninstalled SQL 2000.
Do I need to reinstall SQL 2000 now?
I also checked on that ...
One thing I have noticed -is that I am not getting the table alias included with each of the fields. It did expand only the proper table where I had prefaced with cpia.* and hit tab, but only the first column got my alias.
I'd like to see the alias carried through the entire expand. / comments
One thing I have noticed -is that I am not getting the table alias included with each of the fields. It did expand only the proper table where I had prefaced with cpia.* and hit tab, but only the ...
That's absolutely brilliant! Now I don't have to wait for an update! [image]
Alright then on the hot key, what about either A) a button we can add to the toolbar, or just a menu item that says "Refresh Cache Current DB"? That's really all I need, just something that would save me the few extra steps.
One other question, how do I get SQL Prompt to show me objects in another database? I have two dbs that I use in production, and sometimes I want to query data from the other DB while still within my main DB. I do a select * from reporting.dbo. and instead of getting objects from that DB (which I know Prompt has cached), I only get objects from the DB I'm in. I looked at the options, but didn't see anything that leapt out at me. Of course you know that my next question will be regarding the prompts for linked servers (but we'll leave that for another day for now :lol: ).
Great job over all - your products absolutely ROCK! / comments
That's absolutely brilliant! Now I don't have to wait for an update!
Alright then on the hot key, what about either A) a button we can add to the toolbar, or just a menu item that says "Refresh C...
petey wrote:
Start Profiler, filter on the application name SQBCoreService.exe. Then start a backup using SQL Backup. You should see 2 backup commands, one identical to the one you issued, and another similar to the first, but using VIRTUAL_DEVICE = ... instead of DISK = ...
The command is getting to the server, however it just won't work. I tried stopping and restarting the SQBCoreService and that didn't work either.
Here is the command coming to the server:
BACKUP DATABASE [model] TO VIRTUAL_DEVICE = 'SQLBACKUP_1AF7352C-C01D-4FD1-8DBA-D5C93F3FE4D7' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (model), 3/28/2007 8:54:14 AM', DESCRIPTION = N'Backup on 3/28/2007 8:54:14 AM Server: PULSITY-SQL1 Database: model', FORMAT
I do see that it is testing to make sure the account it is using has rights to backup and it does. (This was working until a few days ago).
This is getting really upsetting - I haven't had a backup now since the 24th. That is NOT good. I'm going to try and manually run the SQLBackup program to see if it has any more luck backing up a db than the automated job. / comments
petey wrote:
Start Profiler, filter on the application name SQBCoreService.exe. Then start a backup using SQL Backup. You should see 2 backup commands, one identical to the one you issued, and...