Viewing 15 posts - 37,081 through 37,095 (of 39,461 total)
A few thoughts:
v6.5 has conneciton limits. This is enforced regardless of the state of the connection. Architectural limit, so you have to live with it. You can write a job...
July 23, 2002 at 4:23 pm
Can you post your code? Basically you have to code your trigger as though you are joining a table, not a single value.
Steve Jones
July 22, 2002 at 1:11 pm
sysindexes holds this information. In Enterprise Manager, each table will also have this information. What verison of SQL are you using?
Whatver verion, right click a table and choose indexes or...
July 22, 2002 at 1:07 pm
However, ErWIN doesn't use NT Auth, which is incredibly annoying. It is also expensive, but works well. I prefer ERStudio from Embarkadero Technologies. Less cost and most of the functionality...
July 22, 2002 at 11:32 am
I prefer to generate a unique name for each backup so I can keep more if I need them. I then trim the previous ones with a script.
Steve Jones
July 22, 2002 at 9:22 am
Excellent article.
I tend to agree with Andy, however, because I can also use a couple tables to specify not only which business rules are needed, but the ordering for different...
July 19, 2002 at 1:09 pm
Do a "save as" and choose structured storage file. This will give you a .dts that you can copy to the remote server and then "open" it in EM. Then...
July 19, 2002 at 12:51 pm
Maybe serveradmin?
Or build some job to extract the info into a table every xx minutes.
Steve Jones
July 19, 2002 at 9:55 am
I agree. No reason to get the mdf/ldf. Just get your backup flat files.
As far as MSDB, who knows. The only thing that's annoying is any maintenance plan that includes...
July 19, 2002 at 9:44 am
I'd follow Andy's suggestion for troubleshooting. Be sure you don't have a commit inside any of hte procedures or it may be committing without you expecting it.
Steve Jones
July 18, 2002 at 6:01 pm
Part 4 links to the others:
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
July 18, 2002 at 5:59 pm
Don't think that will work, but when you say duplicates, I assume you mean duplicates outside the PK? Or does the original table not have a PK?
Steve Jones
July 18, 2002 at 5:58 pm
I've always had one db per device. I suspect the only issue is really with backup and restore. I would move it, but that would be for better organization and...
July 18, 2002 at 5:56 pm
Vote 3 = Can't be done
Steve Jones
July 18, 2002 at 5:55 pm
Viewing 15 posts - 37,081 through 37,095 (of 39,461 total)