Viewing 15 posts - 5,401 through 5,415 (of 7,506 total)
Thanks for yoru replies.
- Indeed the goal is to offload the applications from the db server.
- the spn's should be ok for now as we've set it up using 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
December 24, 2007 at 12:49 am
- with sp2 at least implement up to Cumulative Update 2 to fix the first issues with sp2.
We have installed Cumulative update package 4 for sp2.
- I also advise 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
December 24, 2007 at 12:33 am
Jeff Moden (12/23/2007)
... I finally broke down and installed the Dev Edition of 2k5 on my home machine.
Now .... unleash the beast :w00t::smooooth:
btw: No problems overhere after switching db_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
December 24, 2007 at 12:24 am
- IMO this post is placed in the wrong forum (discuss content posted by BockWoody ??)
- Start with MS SQL2005 upgrade advisor (analysis your sql2000 db)
- fix the problems 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
December 24, 2007 at 12:17 am
Indeed, domain service accounts are in use.
The SSIS service account has been granted privileges on MSDB.
My windows account has sysadmin auth at the db-server (sqlserver).
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
December 21, 2007 at 7:32 am
- Maybe creating a DTS package to load your tables may be the way to go, because it has the option "keep identities"
-If using set identity_insert on, keep in mind...
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
December 19, 2007 at 5:46 am
If I recall correct there has been a web based MS application for sqlserver that was able to script out the ddl and then insert statements for sqlserver 2000. (SQL_Server_2000_Web_Services_Toolkit...
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
December 19, 2007 at 4:32 am
-As long as you dont forget to migrate and sync the users, it should be OK.
-Also keep in mind te perform full db maintenance after the migration.
(rebuild indexes,...
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
December 19, 2007 at 4:23 am
colin Leversuch-Roberts (12/18/2007)
... I don't find the partial restore / filegroup restore quite as functional as I'd actually like it to be....
Indeed, for the moment we're doing some test 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
December 18, 2007 at 1:38 pm
Maybe even a view can help out, pointing to a staging table where your active inserts happen during migration time.
Selecting from both the "old" table and the staging table.
Copying data...
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
December 17, 2007 at 12:30 pm
check out convert(datatype, yourcol, format)
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
December 17, 2007 at 12:13 pm
Thanks for the ref. I'll check it out in the weekend.
It was some part of the dotnet framework 2.0 that got messed up.
I unstalled it and tried to reinstall (from...
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
December 14, 2007 at 8:54 am
- your sqlserver instance will be able to run on both nodes.
- You'll have to perform an extra install if you also want to have SqlServer Management Studio available at...
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
December 14, 2007 at 6:08 am
if someone has dropped the index/table during your operation, it is obvious your statement fails.
set nocount on
declare @OnlineRebuild char(1)
Set @OnlineRebuild = 'Y'
print '-- Begin ' + db_name() + ' ...
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
December 14, 2007 at 5:59 am
One way of handling that in vb or .net is to use variables declared as DateAndTime.
Don't stuff it into strings, ... but use the corect variable-datatype.
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
December 14, 2007 at 5:55 am
Viewing 15 posts - 5,401 through 5,415 (of 7,506 total)