Viewing 15 posts - 5,401 through 5,415 (of 7,502 total)
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
it just creates the table with username as schema
IMO the behaviour you describe is applicable when you run a :
create table mytable (col1) ;
in that case no...
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 2:46 am
So he gets an error when executing :
create table dbo.mytesttable (col1 int not null)
:unsure:
Very strange.
How many schema are defined in the db ?
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 1:15 am
And this guy is connecting using windows authentication ?
Or is he using SQL authentication ?
Which db groups is this user member off ?
(ddl_admin, ...)
If this user gets auth via 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 13, 2007 at 8:01 am
If they connect with the same credentials using OSQL and SSMS, it should work in the same way.
What's the default schema for the user ?
SQLCMD has more features than OSQL,...
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 13, 2007 at 5:08 am
Viewing 15 posts - 5,401 through 5,415 (of 7,502 total)