Viewing 15 posts - 4,441 through 4,455 (of 7,499 total)
You have to open the needed port(s) clientside in the firewall.
HowTo ? That depends on the firewall software that is installed.
more info: http://support.microsoft.com/kb/287932
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
October 8, 2008 at 2:24 am
Since this is a clean install, I would upgrade to SP2 + CU9 or 10
and only then try debugging this
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
October 7, 2008 at 1:59 pm
Did you enable sqlserver for his firewall (client side) ?
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
October 6, 2008 at 7:02 am
with db mirroring, every action on the primary database is sent to the mirror db.
It is not active, so no one else can tamper with it.
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
October 6, 2008 at 12:31 am
Keep in mind a backup file can contain more than one backup !
Are you creating log backups using the NOINIT parameter ? That's the way you can add a backup...
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
October 5, 2008 at 3:15 am
check the ms website for more info and prereqs.
http://www.microsoft.com/sql/solutions/migration/oracle/default.mspx
and
http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx
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
October 4, 2008 at 12:36 am
That should be ok.
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
October 3, 2008 at 11:54 am
Chris Morris (10/3/2008)
...but - without checking - it's probably expensive.
Yep, checking is what makes this job worth the while :hehe:
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
October 3, 2008 at 10:52 am
Chris Morris (10/3/2008)
[font="Courier New"]DECLARE @StringIn VARCHAR(200), @StringOut VARCHAR(200)
SET @StringIn = 'The Quick Brown Fox Jumps Over The Lazy Dog.'
SET @StringOut = ''
SELECT @StringOut = @StringOut +...
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
October 3, 2008 at 8:06 am
There is a MS white paper called "MS WP DatabaseMirroring.doc"
It contains a nice overview of all sqlserver replication techniques and when to use them.
This is a "hear say" :the only...
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
October 3, 2008 at 4:53 am
Our best friend ... BOL ... guided me on this one :w00t:
/*
http://www.sqlservercentral.com/Forums/Topic579917-338-1.aspx
ROT13 ref http://en.wikipedia.org/wiki/ROT13
*/
CREATE FUNCTION dbo.ufn_ROT13 (@inputvar varchar(128))
RETURNS varchar(128)
AS
/*
declare @inputvar varchar(128)
set @inputvar = 'abcdefghijklmnopqrstuvwxyz'
select @inputvar = @inputvar + upper(@inputvar)...
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
October 3, 2008 at 12:38 am
mtassin (10/2/2008)
Yes this is the SQL 2005 forum. But... what I'm working on needs to run 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
October 2, 2008 at 2:03 pm
As I've read from our "SQL Obi-wan Kenobis" (Jeff Moden & Matt Miller 😉 ) this would be a typical case to use a CLR module.
Don't use the xp,...
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
October 2, 2008 at 1:50 pm
Your problem is you use
NestedSel.*
This part already contains a mkt_rate column.
You generate a new mkt_rate column right next using
mkt_rate =...
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
October 2, 2008 at 1:03 am
Nice ... the N-th datetime solutions payback time :hehe:
Just for correctness ...
can you elaborate and split your bigint into the date part and the timepart ?
1196100822809
1196 = NoDays
10= HH
08 =...
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
October 2, 2008 at 12:42 am
Viewing 15 posts - 4,441 through 4,455 (of 7,499 total)