Viewing 15 posts - 37,441 through 37,455 (of 39,818 total)
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
Haven't seen it, but you might try posting this with another description in the T-SQL forum.
Steve Jones
July 18, 2002 at 5:54 pm
Pls don't cross post. All forums are checked by many people (using Active Threads at the top). We see all these posts.
Steve Jones
July 18, 2002 at 10:14 am
It's a gredy human issue. E Coli outbreaks in Colorado meat packers and USDA is somewhat either in bed or influenced by them.
Enron (need we say more), Worldcom, etc.
Greed in...
July 18, 2002 at 10:13 am
Viewing 15 posts - 37,441 through 37,455 (of 39,818 total)