Viewing 15 posts - 3,841 through 3,855 (of 7,499 total)
Your query returns duplicates !
SELECT adv.A_AdvertiserID
,'Mobile'
,ab.[Telephone2]
FROM [MSCRM].[dbo].[AccountBase] ab
JOIN [DIGADV].[dbo].[Advertiser] adv
ON ab.[Name] COLLATE DATABASE_DEFAULT = adv.A_AdvertiserName COLLATE DATABASE_DEFAULT
Solution ?
- Check PK on names ?? (In my home town we had 3...
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
April 5, 2009 at 10:08 am
We use this one at sql2000.
Select @@servername as Servername, getdate() as RunDate
/*
* Show members of serverrole sysadmind
*/
exec sp_helpsrvrolemember @srvrolename = 'sysadmin' -- =SA
go
/*
* show members of the...
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
April 5, 2009 at 10:00 am
indeed ... an authorzation issue to the linked server BRENTREPODB02.
How did you set up the linked server usage security ?
BTW: nice view ... using the mixture of right and...
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
April 3, 2009 at 1:51 pm
maybe stupid, but did someone use any form of compression ? (drive/LUN level)
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
April 3, 2009 at 1:45 pm
of course that also depends on what your udf is doing !
is it just a split/string function or does it perform access to other objects ?
if you post it we...
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
April 3, 2009 at 1:41 pm
Actually the install of sql2000 shouldn't cause a technical problem.
Who detached your database ?
Where has it gone to ?
Did someone just uninstall the sql2005 engine ?
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
April 3, 2009 at 7:10 am
and off course there is a difference in Red Cross junior camp first aid, Paramedic first aid and combat first aid 😀
According to their trained skills, you may have a...
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
April 2, 2009 at 1:42 pm
Well ... your indexes also need space !
So depending on the size of the columns you used in the index ddl, they will be smaller or larger combined with the...
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
April 2, 2009 at 1:27 pm
Outrageous for any software to be implemented in that way !
Complain to your manager that this simply is not acceptable !
Have him complain with the software vendor and make 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
April 2, 2009 at 1:15 pm
ldave (4/2/2009)
I have created a view with code that looks like below.
use testprd;
SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
QUOTED_IDENTIFIER, ANSI_NULLS ON;
create view test wtih schemabinding as...
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
April 2, 2009 at 1:07 pm
I think "discovery"' doesn't function on 64-bit environments.
You should be able to just enter the sqlserver name (server\instance) and connect with ssms !
If that doesn't work...
Did you enable the SQL...
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
April 2, 2009 at 6:36 am
Your trigger tries to execute sprocs in the [Changes] database !
EXEC [Changes].[dbo].[ik_ChangeLogInsertI]
Does that database exist on the sql instance ?
OR
Does the user executing the update have the needed...
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
April 2, 2009 at 6:30 am
Nice approach list :w00t:
The "Remain Calm / Keep your head cool / Keep on breathing" should actually be put after every major point.
In case of urgency, that is vital...
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
April 2, 2009 at 6:12 am
It depends !
With an upgraded database, the default schema will be the userid.
This script needs to be executed with sysadmin auth because of the "execute as" and "Revert".
Don't forget to...
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
April 2, 2009 at 12:46 am
As Greg stated, it is an add on component after your sqlserver has been installed.
You can download it from Feature Pack for Microsoft SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
The component 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
March 31, 2009 at 11:43 pm
Viewing 15 posts - 3,841 through 3,855 (of 7,499 total)