Viewing 15 posts - 4,441 through 4,455 (of 7,502 total)
Yet another query 🙁
Maybe you'd be better off just copy/paste-ing the actual thing you want...
What is this selects giving you as a result:
Select count(*)
from myTable
where [CAR1] IS 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
October 8, 2008 at 10:52 am
metalray (10/8/2008)
Issue solved,I just changed the order of columsn in my INSERT statement from
INSERT INTO dbo.myTable(Code,Amount, Car)
to
INSERT INTO dbo.myTable(Code,Car, Amount)
Hey, hey, ..... that's not what you posted first...
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 8:04 am
metalray (10/8/2008)
I am down to one column that causes a problem. I have a simple INSERT:
INSERT INTO dbo.myTable(Code,Car, Amount)
SELECT
[AR] As [Code], --Year
[SDF] As Car , --Vendor
[SVB] As Amount...
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 5:11 am
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
Viewing 15 posts - 4,441 through 4,455 (of 7,502 total)