Viewing 15 posts - 1,336 through 1,350 (of 7,499 total)
arch .. you posted in a SQL2008 forum, hence the refs to it.
Anthony already provided the link to your solution 😉
/* SQL Server 2000 - sa password changes */
USE Master
GO
SELECT...
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
June 27, 2012 at 8:37 am
just as a side dish ... why is column datekey not a date column ?
May avoid conversions to take advantage of date functions.
( maybe that's all been covered in 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
June 27, 2012 at 7:15 am
Did you check this article http://www.sqlservercentral.com/articles/Security/87159/
or this thread : http://www.sqlservercentral.com/Forums/Topic988899-149-1.aspx
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
June 27, 2012 at 6:46 am
why isn't there just a simple index on both date columns in the order you need them ?
create index X_yourtable_dates on yourschema.yourtable (date1, date2);
might be another solution to avoid...
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
June 26, 2012 at 7:51 am
according to BOL this should work with SQL2008..
select *
, SUM ( TranAmount ) over ( partition by Account order by Account, datetrans, uniqueID ) as RunTranAmount
from yourtable
order by 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
June 20, 2012 at 1:52 pm
durai nagarajan (6/20/2012)
hope i'll change cluster user access to public rather than sysadmin.any points about 3 & 4.
cluster service account only needs "login" on your sqlserver instance. That's all.
We remove...
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
June 20, 2012 at 5:36 am
yes, no.
We run cluster services using its own service account and use sqlserver (domain) service accounts for every sqlserver service.
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
June 20, 2012 at 5:19 am
please don't use the C$ share for this purpose ! It is supposed to be for administrative stuff.
Create your own backup share on your target server, grant the 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
June 20, 2012 at 5:15 am
wendy elizabeth (6/19/2012)
[dbo].[AT_Pln] can...
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
June 20, 2012 at 5:09 am
chris-320654 (6/19/2012)
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
June 19, 2012 at 12:47 pm
all.
have a look at Features Supported by the Editions of SQL Server 2008
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
June 18, 2012 at 11:47 pm
Koenraad Dendievel (6/18/2012)
This is not a replacement to track complete history of changes (who dunnit) but more a 'do i have the latest version'-tool(replication/synchronisation)...
Roy Ernest[/url] published a great series 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
June 18, 2012 at 6:46 am
Nice example of change tracking.
You mention
is designed to work with Sync Services for ADO.NET.
but the article lacks the example or refs to do so.
e.g. as a starting...
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
June 18, 2012 at 3:22 am
I like the solution Gail handed over.
Especially because it lets you identify the bogus information easily using "WHERE HardwareNumber is NULL".
So, unless you really need this column 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
June 17, 2012 at 11:55 pm
You're encountering one of the "little" mishaps known with msaccess db.
did you try something like this ?
Declare @mycounter int = 999999900
UPDATE tblAsset
SET HardwareNumber = @mycounter
, @mycounter +=...
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
June 17, 2012 at 9:36 am
Viewing 15 posts - 1,336 through 1,350 (of 7,499 total)