Viewing 15 posts - 37,516 through 37,530 (of 39,818 total)
It will capture all statements run against the server.
Steve Jones
July 8, 2002 at 5:06 pm
A great suggestion for something to write about 🙂
I don't have a resource, but the basics would be the same for each server:
1. hardare
2. software, including current settings (SPs, what's...
July 8, 2002 at 5:02 pm
I agree with danw. Set a standard port per instance for your company and use it.
Steve Jones
July 8, 2002 at 4:58 pm
look in msdb.dbo.sysjobschedules. You can query from here.
Preferred: sp_help_job
Steve Jones
July 8, 2002 at 2:16 pm
Not having had this situation, take this with a grain of salt.
I try to "loosely couple" things together. Why? So failures to not cascade. Also, updates, upgrades, etc. do not...
July 8, 2002 at 1:51 pm
One would think so. It may depend on what you are changing. I'd guess that 100 int cols is similar to 10 int cols. For varchar, you may introduce page...
July 8, 2002 at 1:41 pm
Profiler will work.
Not aware of anything else that is "select" based. Log Explorer will capture the INSERT, UPDATE, DELETE stuff.
Steve Jones
July 8, 2002 at 1:39 pm
if it's the same structure, write a query to get the data you want to move, i.e.,
select Col1, Col2, Col3
from BigTable
where Col1 >10
Once you have your queries,...
July 8, 2002 at 1:38 pm
Nice article, however I think some of the lesser experienced might like some more commentary on how it works. For me, however, its nice to see how someone else does...
July 8, 2002 at 1:33 pm
You can also write some script to remove them manually.
Steve Jones
July 8, 2002 at 1:29 pm
Wow, someone is doing there job. I had assumed this was some sort of MD5 or other one way hash, but apparently not.
I guess NT Auth is starting to look...
July 8, 2002 at 10:22 am
Reinstall Visio. Haven't had issues with this, but I don't like it as a tool for modeling because it gets cumbersome and is not reliable for reverse and forward engineering.
ER/Studio...
July 8, 2002 at 10:08 am
Viewing 15 posts - 37,516 through 37,530 (of 39,818 total)