Viewing 15 posts - 37,336 through 37,350 (of 39,720 total)
Has to do with the severity and the errors. Some cannot proceed with processing. Which errors are cuasing issues?
Steve Jones
July 23, 2002 at 4:33 pm
pause maybe? Can you connect with EM and check?
Steve Jones
July 23, 2002 at 4:32 pm
To get a list of tables, columns, etc. More stable than sysobjects, syscolumns, etc which might change.
If you wanted to update all columns named "MyID" with a default, you could...
July 23, 2002 at 4:30 pm
a)Get a copy of Inside SQL Server, it will explain this complicated topic in detail.
b)yes
c)not really fragmentation to me, but an intersting idea. Not something you can do anything about...
July 23, 2002 at 4:26 pm
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
Viewing 15 posts - 37,336 through 37,350 (of 39,720 total)