Viewing 15 posts - 3,391 through 3,405 (of 6,216 total)
You can get the database name by using the db_name() function, something like this:
select db_name(dbid) from sysprocesses
More info on the other columns in books online. Not that it probably matters...
August 24, 2002 at 7:50 am
I dont see anything there that is obviously wrong/weird. I'll set up a simpler test scenario to see if I can see anything. Have you double checked what NetIQ is...
August 23, 2002 at 5:34 pm
Yes. Typically backing up once a day is plenty unless you have a lot of changes going on.
Andy
August 23, 2002 at 5:34 pm
Depending on the detail you need, wouldnt be hard to put together a UI to build the trace. Not going to get the real time display (anyone know how Profiler...
August 23, 2002 at 5:23 pm
Agree. Not going to see a lot of growth there, not hardly worth worrying about.
Andy
August 23, 2002 at 2:59 pm
Has to be a better way and ridiculous not to be able to do a solution using the OS tools. Right up there with the disk defrag that you cant...
August 23, 2002 at 12:20 pm
In general and perhaps obviously, the faster your system the better, in any regard you care to measure. The biggest difference between a server and a desktop is reliability/quality. Not...
August 23, 2002 at 12:19 pm
No decent way except to buy Log Explorer by Lumigent.
Andy
August 23, 2002 at 12:15 pm
Not a bad solution.If you're doing some sort of standard profiling, you could set it up as a job, maybe add a table to configure it.
Andy
August 23, 2002 at 8:15 am
Probably should be. We use a 3rd party discussion tool, so came with the package. Considering a change anyway, we'll have to finish that discussion before deciding on other related...
August 23, 2002 at 5:38 am
We'll add it our list of possible improvements. No promises yet!
Andy
August 23, 2002 at 5:37 am
August 23, 2002 at 5:36 am
No other way that I know of. No direct way to tell its running either. Possibly some kind of hack sending keystrokes to it. Be interested if someone has a...
August 23, 2002 at 5:34 am
Not sure about merge, what I do with transactional is to stop the job which stops the logreader/distribution agent.
Not sure the customer understands the impact of what they are asking....
August 23, 2002 at 5:33 am
You'll have to build up a string and use Exec().
Andy
August 23, 2002 at 5:28 am
Viewing 15 posts - 3,391 through 3,405 (of 6,216 total)