Forum Replies Created
Viewing 15 posts - 7,396 through 7,410 (of 7,498 total)
-
RE: Tools question
I don't know such a tool.
IMO changing the system-date might be no issue on a TEST server, but on a production environment ???
Provide the date with a parameter to your...
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
-
RE: Change Object Ownership
kknudson,
Did you have DRI (foreign keys) ?
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
-
RE: Change Object Ownership
Select 'print '' object : ' + u.name + '.' + o.name + ''' ' + char(13) + ' go '+ char(13)
...
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
-
RE: Windows server name from T-sql
Maybe this can get you on tracke:
CREATE TABLE #tInfo (SQLServerComputerName nvarchar(500))
insert into #tInfo (SQLServerComputerName)
exec xp_cmdshell 'net name'
select SQLServerComputerName from #tInfo
drop table #tInfo
Don't open your cmdshell...
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
-
RE: Windows server name from T-sql
are you lookig for xp_cmdshell 'net 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
-
RE: Migrated Servers, Now Windows Authentication Fails
This is "nice to know"-stuff
that helps to get you good credibility. But because it all gets more integrated, the "nice to know" tends to be...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
-
RE: Feedback - Upgrading 7.0 to 2000
I know this might be regarded as prejudiced source, but anyway :
- http://www.microsoft.com/sql/evaluation/compare/default.asp
- http://www.aw-bc.com/catalog/academic/product/0,4096,0201752832-TOC,00.html
- http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/73F96D35618BBF56852568D0007691CC
- http://www.benchmarkresources.com/?cat=3&Sel=Database
Edited by - alzdba on 07/31/2003 08:17:57 AM
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
-
RE: Migrated Servers, Now Windows Authentication Fails
Did you check the sqlserver-server's local (nt/w2k)-group members for guests and/or users to contain the needed domain-usergroups ? (e.g. yourdomain\domain users)
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
-
RE: Feedback - Upgrading 7.0 to 2000
You're in deep sh**. This is mainly about politics.
Unless there are some issues you can only solve with oracle, there is no reason to migrate. (guess not because now...
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
-
RE: Migrated Servers, Now Windows Authentication Fails
Regarding windows-authentication, check if the 'Developer'-group is added to the local\groups\guests or users of your sqlbox (or a group they are member of).
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
-
RE: How to get the real USER_NAME?
Check the IIS anonymous login setting. Maybe someone did put an overauthorized user-account overthere.
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
-
RE: Doing Short Circuiting in WHERE clause
Seems fine, but check this :
(You'll need to grant read access to all needed objects in stead of only to the sp(s))
-- TESTSCRIPT based on Northwind
-- create SQL-user-login
sp_addlogin @loginame =...
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
-
RE: Doing Short Circuiting in WHERE clause
If you're going for dynamic sql, your statements will always have to be compiled, optimized, security-checked, .... So you'll have to provide more access rights to the user(s).
When 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
-
RE: SQL Agent won't start
is agent running on "local system" and did you remove "builtin\administrators" ?
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
-
RE: Doing Short Circuiting in WHERE clause
you've got the solutions. Remember that "short circuits" overheat ! If you use to much short circuits, your box might fireup. Do some performance checks as to what costs your...
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
that helps to get you good credibility. But because it all gets more integrated, the "nice to know" tends to be...Viewing 15 posts - 7,396 through 7,410 (of 7,498 total)