Viewing 15 posts - 3,661 through 3,675 (of 7,499 total)
I guess you execute a sproc that has been created using "execute as login"
you may be able to actually perform stuff you normaly wouldn't be able to.
create proc usp_SSC_test
with execute...
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
June 11, 2009 at 10:23 am
We don't use any xprocs, so I didn't have to convert them.
We only used sp_oacreate with smtp mail. These have all been switched to dbmail in sql2005.
Maybe this link 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
June 11, 2009 at 2:31 am
did your sqlserver memory consumption grow contantly during this month ?
If yes, you may be suffering a leak and may need to plan reboots on a regular basis, unless you...
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
June 11, 2009 at 1:52 am
any DTA advise must be interpreted and tested before you deploy it.
You may even see quit duplicate indexes advised;
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
June 10, 2009 at 7:23 am
TheSQLGuru (6/10/2009)
ALZDBA (6/10/2009)
It cannot be sql2008 ...... the feedback registration date is 11/26/2006
I believe you are mistaken if you think that MS wasn't working on SQL Server 2008 in late...
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
June 10, 2009 at 7:22 am
I was still searching to get things back on track ... and got to the 32-bit issue after a while.
Thanks.
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
June 10, 2009 at 7:10 am
kittu123 (6/11/2008)
Initially I created on only Alias...
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
June 10, 2009 at 6:35 am
Hi Alif,
Did you ever got this issue solved ?
I'm having issues exporting to access.mdb with SSIS sql2005 x64 EE.
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
June 10, 2009 at 6:31 am
It cannot be sql2008 ...... the feedback registration date is 11/26/2006
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
June 10, 2009 at 5:07 am
That's normal.
SQLServer will only wait for its standard timeout value of time.
The OS will still complete the extention after sqlserver has raised its 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
June 10, 2009 at 4:51 am
marees.inspire (6/10/2009)
When i am executing the following query
select count(*) from LinkedServer.SourceDatabase.dbo.sourcetable
It is running more than 3 hours to complete...
Pls let me know why this scenario happening...
Thanks 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
June 10, 2009 at 2:17 am
We use the same attitude Grant Fritchey posted.
To support your "support teams" requirements to be able to restore any backup on any given time and database, I would provide them...
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
June 10, 2009 at 2:09 am
Without knowing the tb / ix definitions and stats, i would say to modify all in-lists to @temp objects and rewrite to join with those ! (of use a split-function...
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
June 10, 2009 at 1:43 am
Hmm ... Books online is a good resource to figure this out.
But anyways...
If you can, create a last Log backup !
then:
hmm ...
1) restore the latest FULL backup with...
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
June 10, 2009 at 1:29 am
You should install SSIS server components to schedule the package!!
Apparently adding SQL2008 (devedtn + bids) messed up my settings.
I'll have to figure out a workaround.
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
June 9, 2009 at 7:11 am
Viewing 15 posts - 3,661 through 3,675 (of 7,499 total)