Forum Replies Created
Viewing 15 posts - 5,581 through 5,595 (of 7,499 total)
-
RE: SQL Server and SOX
thanks for the missing link notification :blush:
It used to work befor SSC got to this new version.
I'll ask Steve to fix it.:cool:
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: host running SQL Server -- how to configure its windows server role?
I got this from last years SQLPass conference:;)
Potential for enormous filesystem cache on 64-bit can create external memory pressure !
Configure OS to favor memory for programs, not filesystem.
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: Can sql2000 and sql2005 running on a w2k3 cluster?
In stead of keeping fingers crossed, because it should be possible.
Maybe it's better to just grab a spare DESKTOP, pop in a 500Gb disk and install a w2k3 server on...
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 Server login
steevlee (9/28/2007)
...could you please explain more "Login Triggers" ..? :w00t:
Keep in mind logon triggers have only been implemented with SQL2005 as from SP2 and off course they are at instance...
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 2000 Reattaching Database issue
I'd go with GilaMonster's advice.
Keep in mind that when you are going to restore, you can actualy move the log-file to a new location during the restore itself. Nomore hassle...
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: 500,000th member mark
At next SQLPass, this may be the banner on the backside of the T-shirt:
500000 and growing ! (Update the number active at the time) :w00t::cool::cool::cool:
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: Memory warnings
so your solution would be:
1) correct your /pae and AWE settings.
Only use the /3Gb in boot.ini and do NOT enable AWE in sqlserver
2) I'd...
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: Datum Count - Count of records in Column wise for Null and Actual data
maybe the better way is to use the INFORMATION_SCHEMA views, but you'll get the idea using :
declare @Tabelname varchar(128)
set @Tabelname = 'T' -- Adjust to filter !!
-- print 'set...
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: SQLServerCentral.com - V3
Nice thing, these upgrades, it's a pitty you didn't migrate the forum-reply-counters. So all of a sudden I'm back to 3.:doze:
Joined: 5/27/2001 11:00:00 PM... 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: Cluster failover not happening..plse help
been there, done that, burned the fingers too
I'm glad you're back on track 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: Cluster failover not happening..plse help
just a wild guess, but did you remove builtin\administrators and forgot to give login auth to the cluster service account ?
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: SSSI and DTS Packages
tell him to use Visual Studio , create a new SSIS project and use the migration wizard for DTS 2000. (he must be able to get to the SQL2000 package...
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: creating linked server
can you script and post your "create linked server" DDL (and the details) ?
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 Sever 2005 Data Audit tool
Did you check ApexSQL Audit ?
If you have full recovery model enabled, there are also log-analysers on the marked. e.g. Red Gate Log rescue (btw free for sql2000)
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 do you troubleshoot SQL Server Agent in SQL 2005?
What level is your SQL2005 (sp2 with CU3 ?)
- check the job-owner for the jobs.
- if you want to run dts-packages, you'll need ssis
SSIS needs to be installed separatly...
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
Viewing 15 posts - 5,581 through 5,595 (of 7,499 total)