Johan Bijnens

Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 7,502 total)

RE: Collation Codes

When you use "restore db" to put your db on SQL2005, then it will still have and use it's own collation. That could already be done in SQL2000.
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 5:27 am

#622872
RE: Alert on available space in datafile

I have this query running every 15 Minutes with sqlagent.
It writes a message to winnt-eventlog which is captured by HPOVow
Primitive, but it works.
declare @DB_Criterium int
/* ** criterium % must be...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 5:14 am

#622869
RE: automatically notify when running on low harddisk space

we us HP ovow to monitor the physical disks, not the sqlserver infrastructure.
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 3:06 am

#622847
RE: Scheduled Job started bud nothing happens

Here's Freud again
Aha-erlebness

Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 2:49 am

#622841
RE: A little help on Alerts

there are some pittfalls with alerts
first of all, an alert only responds when it is enabled
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 2:28 am

#622834
RE: AD Security Group Access Problem

You can check if sqlserver finds the group using Query ananlyser.
connect to the server position in the database
and execute :
use yourdb
go
EXEC master..xp_logininfo @acctname = 'yourdomain\yourgroup',@option = 'members' -- who belongs...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 2:14 am

#622831
RE: moving procedures to other filegroup ?

this would be like pulling a cat insideout (in a matter of speaking )
If you don't...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 1:51 am

#622826
RE: Scheduled Job started bud nothing happens

Can you try running the dts in the job with its proper name in stead of the guid ?
dtsrun /Npackage_name

Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 23, 2006 at 1:42 am

#622823
RE: suppressing osql column padding

Yes it has.
In fact, you can prepare and save your package (if you used the wizard, you must have seen the panel where it asks "run immediate , save as...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 22, 2006 at 11:48 pm

#622812
RE: Scheduled Job started bud nothing happens

Is this package password protected ?
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 21, 2006 at 5:13 am

#622223
RE: suppressing osql column padding

it's _the_ way for importing / exporting data.
Even the wizard is intuitive
EM (enterprise manager) \ databases \tables got to the righthand side, right-click...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 21, 2006 at 12:03 am

#622170
RE: Scheduled Job started bud nothing happens

did you put the jobowner to SA (and not a windows account) ?
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 20, 2006 at 6:02 am

#621984
RE: Error: 7105

can you perform a dbcc checkdb ?
Read about it in Books Online to check the options?
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 20, 2006 at 5:59 am

#621983
RE: Scheduled Job started bud nothing happens

just to be sure ...
- you know EM does _not_ refresh automaticaly. You have top position on the...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 20, 2006 at 5:43 am

#621979
RE: Scheduled Job started bud nothing happens

so you can login and execute using _that_ (sqlagent) domain-account ?
Can you enable the jobstep's outputfile to capture windows output ?
jobstep\advanced outputfile
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

February 20, 2006 at 5:02 am

#621975

Viewing 15 posts - 6,346 through 6,360 (of 7,502 total)