Forum Replies Created
Viewing 15 posts - 7,396 through 7,410 (of 7,502 total)
-
RE: A virtual drink for everyone !!!
this EOM-thing , does that mean you have to stand on a chair/table and that everyone else has to sing to you ? ended by 3 times hurray
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: Identity skipping numbers when foreign key violate
identity just generates a (sequenced) number, but it does not generate it by recalculating it using the table itself, but it keeps it in a systemtable. It should be no...
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: sqltrace.dll error
The only time I ran regrebuild, I did not supply a parameter and it did the job. The reason I did not supply a parameter is because I did not...
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: sqltrace.dll error
Check "registry rebuild" in books online.
(regrebld utility)
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: 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
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,502 total)