Viewing 15 posts - 3,796 through 3,810 (of 7,499 total)
SMO stands for SQLServer Management Objects.
Meaning a layer with a number of methods and properties specifically made for managing sqlserver.
You wouldn't want to use that layer for your "normal" querying...
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 15, 2009 at 2:01 am
New Commer (4/15/2009)
for a process the time frame is
-StartDate-|-EndDate-|--Starttime-|-EndTime-
-15/04/09-|-16/04/09-|---10:00---|--14:30--
both days the total hrs spent on the process is 9 hrs
Now how to get the result via query...
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 15, 2009 at 1:53 am
Typical for a child object is that it cannot exists without a parent object.
So the parent object has to exist first, only then you can use that parent key in...
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 15, 2009 at 1:42 am
I downloaded it last Friday (2009-04-10) and just wanted to let you know it the install on my 32-bit Dev Edtn instance went fine.
Initial test seem OK.
We currently don't have...
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 14, 2009 at 5:03 am
FYI Lynn also posted a nice overview of common date routines.
http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.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 14, 2009 at 1:55 am
If you have the dba edition, you should be able to do far more then reverse engineer and forward engineer.
http://sqlblogcasts.com/blogs/simons/archive/tags/Data+Dude/default.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 14, 2009 at 12:27 am
Indeed, must have been a dyping error 😉
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 11:59 pm
INFORMATION_SCHEMA views also work with pre sql2005 versions.
To only select actual tables you need to add the where clause
Where TABLE_TYPE = 'BASE TABLE'
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:28 pm
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
Viewing 15 posts - 3,796 through 3,810 (of 7,499 total)