Viewing 15 posts - 3,811 through 3,825 (of 7,506 total)
did you test this ?
Select datediff(dd, dateadd(mm,-18,getdate(), getdate)
i.e. determine the number of days ( dd ) between the getdate minus 18 months (12+6) and the current date.
It will not hurt...
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
April 13, 2009 at 1:14 pm
here's an example we tested to restrict some non-sa (but dbo) actions.
In your case you'll need to check for event type "DROP_TABLE".
/****** Object: DdlTrigger [ddlDatabaseTriggerNonSA] Script...
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
April 13, 2009 at 1:10 pm
AFAIK, you cannot do this with the active job.
What I mean is that you can modify a job step using msdb.dbo.sp_update_jobstep
but those modifications will only get active with 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
April 13, 2009 at 1:04 pm
I haven't experimented with the migration assistant for oracle, but the one for access also has an option to migrate the data.
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
April 13, 2009 at 7:56 am
So you were able to create the tables (please create them in their own database, and not in any of the system databases (master, msdb, tempdb, model))
Maybe using the GUI...
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
April 13, 2009 at 6:42 am
great solution Bob.
Nice application of outer apply. Still have to get used to that feature 😎
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
April 13, 2009 at 3:44 am
start with:
Select ...
from information_schema.tables
where table_name like '%yourcryteria%'
order by table_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
April 12, 2009 at 11:07 am
Just like the others, I would suggest to first concentrate on TSQL, Management studio and sqlserver organisation (detailed if needed), then you'll get to sqlcmd for deployment facilities,...
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
April 12, 2009 at 11:06 am
If this is a single shot action (migration ?) it may be best to use Microsofts migration assistant for Oracle. It can be downloaded free from here :
http://www.microsoft.com/sql/migration/
This may...
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
April 12, 2009 at 9:32 am
barryocteau (4/11/2009)
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
April 12, 2009 at 9:29 am
bambang (4/11/2009)
Thanx for your suggestion, but it's not work yet.
The query result would be like this :
PrimaryKey1 PrimaryKey2 TitleOrder Title TitleDescription
1 1 0 Movies A great movies
1...
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
April 11, 2009 at 11:09 am
In many cases, problems start with people creating every column nullable - except for the primary key column(s) - without popping the questing of for that specific column NULL is...
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
April 11, 2009 at 10:04 am
bambang (4/11/2009)
I have a problem to update data from table.
The Source table looks like this:
PrimaryKey1 PrimaryKey2 TitleOrder Title ...
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
April 11, 2009 at 6:47 am
- Post the xml schema and we may be able to get you on track
- maybe my recent post can help a little.
http://www.sqlservercentral.com/Forums/Topic678236-21-1.aspx
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
April 10, 2009 at 11:13 am
Do you have access to visual studio team edition for database admins ?
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
April 10, 2009 at 11:06 am
Viewing 15 posts - 3,811 through 3,825 (of 7,506 total)