Viewing 15 posts - 5,371 through 5,385 (of 7,506 total)
A db-level security admin ( member of db_securityadmin db-group) can only grant db acces to logins that are allready being granted connect at server level (by server securityadmin or sysadmin).
--...
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
January 7, 2008 at 4:51 am
I've just received this article and thought it might also help you :
http://www.mssqltips.com/tip.asp?tip=1397
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
January 7, 2008 at 12:57 am
just a little remark:
If you post ddl with objects using UDT's, also post the UDT's ddl.
as allready stated, you just join all rows of both tables without a filter....
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
January 6, 2008 at 2:49 am
were they security admins at sql2000 side ?
if yes, add them to the serverlevel security admins group.
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
January 6, 2008 at 2:34 am
I don't have the answer to your question, but maybe you've choosen the wrong object to server your data need.
Why did you choose a clr-object ?
Why did you choose a...
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
January 4, 2008 at 12:45 pm
- can you post the results of xp_fixeddrives ?
- can you post the results of :
exec master..xp_fileexist 'D:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Search_AST430_log.LDF'
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
January 4, 2008 at 12:48 am
- is there a d-drive
- does the path exist ?
- does the sqlsever service account have the authority to read/write to that path ?
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
January 3, 2008 at 2:47 pm
- most applications actualy do NOT need sa, nor sysadmin privileges to run the application itself.
- most software installers do not know this, or are to lazy to alter 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
January 3, 2008 at 2:45 pm
- Solution 1: get rid of the linked servers ! 😀 Maybe the process can be performed asynchrone, so replaces by a sqlagent job or so. You might even consider...
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
December 28, 2007 at 5:41 am
move the backupfolder to your c-drive to avoid this kind of hassle !
So it will be able to use c:\backup\...
Also keep in mind it has to be able to write...
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
December 28, 2007 at 5:27 am
Basicaly two types :
- nonclustered ( max 254 / table) (shortcut access)
- clustered (max 1 per table) (physical dataorganisation)
Full-Text Indexes are a whole different story because of their implementation.
check...
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
December 28, 2007 at 5:20 am
SQLServer (like any rdbms) uses statistics to determine an accessplan for your query.
If there are no statistics available it will use predefined distribution assumptions.
At database level you can set autoupdatestatistics...
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
December 28, 2007 at 5:12 am
- check your sqlserver errorlog file at both servers !
- maybe the script can help you out :
Troubleshooting Service Broker (SSB) http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
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
December 28, 2007 at 4:58 am
follow Madhivanan's advise !
select fromdate
, convert(datetime,fromdate,100) as fromdate_datetime
, convert(char(23), convert(datetime,fromdate,100), 121) as frildate_datetimestring
from emp
where convert(datetime,fromdate,100) > convert(datetime,'2/16/2007',100)
order by convert(datetime,fromdate,100)
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
December 28, 2007 at 2:25 am
- with sql2005 it is advised to switch to DBMail.
- Can you find a error notification in the job history ?
- Can you find a error notification in the SQLAgent.out...
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
December 28, 2007 at 2:11 am
Viewing 15 posts - 5,371 through 5,385 (of 7,506 total)