Viewing 15 posts - 3,136 through 3,150 (of 7,499 total)
BOL states:
ComputerNamePhysicalNetBIOS
NetBIOS name of the local computer on which the instance of SQL Server is currently running.
For a clustered instance of SQL Server on a failover cluster,...
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, 2010 at 12:37 pm
as you know usage of xp_cmdshell is to be avoided.
We don't use xp_cmdshell out of sysadmin context, but I believe you can grant it by altering settings for sqlagent.
SQLAgent properties...
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, 2010 at 12:28 pm
Did you try to design your form row based.
I'm not an access specialist, but I've done some access 2003 things and didn't have issues with that.
I used 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
February 22, 2010 at 12:19 pm
ZeeAtl (2/22/2010)
A question I have is this about removing BUILTIN\Administrators from Security->Logins on SQL Server [2005] instance.
If I remove this account from Logins, but the domain users remain as Local\Administrator...
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, 2010 at 11:33 am
Should come to something like this.
SELECT T1.col1
, T3.col3
FROM T1
inner join T2
ON 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
February 19, 2010 at 8:02 am
KISS !!
Just use an alert to launch the job !
Have a look at my little article "help to tighten use of cmdshell or sp_start_job"
http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
This way, you get all...
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 19, 2010 at 7:30 am
If you really need to intervene ... use a ddl trigger
If you only need a notification, you might consider the asynchrone path.
example ddl trigger :
create TRIGGER [ddlDatabaseTriggerNonSA]
ON DATABASE...
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 19, 2010 at 7:22 am
Did you try his ?
UPDATE E
SET oprefno = R.ReturnValue
from dbo.#Encrypt E
, @ResultSet R
where E.ccno = @ccno
and R.ReturnValue is not null
Maybe even...
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 19, 2010 at 7:11 am
Check out %SystemRoot%\Cluster\CluAdmin.exe
it has a command line version ...
Topic "Managing a server cluster from the command line" at Technet:
http://technet.microsoft.com/en-us/library/cc779044%28WS.10%29.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
February 19, 2010 at 7:03 am
We are using sql server event notifications to capture the audit_login events.
cfr: http://www.sqlservercentral.com/articles/Administration/64974/
This works fine on all our servers, except for one that has +50 logins per second.
If you want...
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 18, 2010 at 7:46 am
there is also notification services which allows your application to cache the data locally and only refresh it when it receives a notification message from sqlserver.
I'm not a .net specialist,...
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 18, 2010 at 3:48 am
Lamprey13 (2/17/2010)
Jeffrey Williams-493691 (2/17/2010)
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 18, 2010 at 12:47 am
Just keep in mind extending a file is an expensive operation for your system.
Depending on your db usage, 50% free space may be desired state because of processing needs.
How many...
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 17, 2010 at 2:02 pm
Also state which columns you want to select.
- Only from table1 or from both tables ?
- How can you differentiate both result sets ?
I have a slight impression...
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 17, 2010 at 1:55 pm
Keep in mind there is more to service broker than meets the eye !
First read a bit about it, so you know what it is all about and 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
February 17, 2010 at 2:49 am
Viewing 15 posts - 3,136 through 3,150 (of 7,499 total)