Viewing 15 posts - 2,926 through 2,940 (of 7,502 total)
I doubt order is of any concern with the current versions (2005/2008).
You need to keep in mind the total length of fixed data types is still restricted to 8060...
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
August 2, 2010 at 2:46 pm
- I would start with the SQLServer upgrade advisor (SQLUA).
This will point to potential issues with your database(s).
- I would also run the Best practice tool, to see how...
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
August 2, 2010 at 2:39 pm
$partacu$ (8/2/2010)
...If we specify only table_name, then the information returned from the query would be for the table under 'dbo' schema only...
One small addition to Gails reply:
If you have db-access...
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
August 2, 2010 at 7:50 am
You could have fetched the schema using:
select object_schema_name(parent_object_id) as TheParentSchema
, object_name(parent_object_id) as TheParentObject
, object_schema_name(referenced_object_id) as TheRefSchema
...
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
August 2, 2010 at 2:52 am
does your service account have the authorities to read the attached file(s) ?
edit: yes, or it should have provided the error:
Msg 22051, Level 16, State 1, Line 0
Attachment file <filename>...
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
August 2, 2010 at 2:46 am
Thank you for your feedback.
Strange indeed that removing the pk would "solve" the issue.
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
August 2, 2010 at 12:46 am
- Can you find messages (that you can relate to your setup) in the sqlserver errorlog file ?
- did you run the troubleshooting scripts ? http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
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
August 2, 2010 at 12:45 am
Jeff Moden (8/1/2010)
Alvin Ramard (8/1/2010)
This may be too much for the forum, but it would not be too much for a homework assignment.
I actually don't believe it's a homework assignment...
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
August 2, 2010 at 12:40 am
Remote connections ?
- to linked servers ?
- for your applications ?
Did you enable TCP/IP for your instance ? Use Server configuration manager to enable tcp/ip.
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
August 1, 2010 at 4:42 am
bitbucket-25253 (7/31/2010)
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
July 31, 2010 at 3:07 pm
Perry Whittle (7/31/2010)
the failover partner connection string parameter is only required if confuring automatic failover. You need to be using either the SQL native client or ADO.NET
Correct ... but ...
What...
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
July 31, 2010 at 12:20 pm
The way you're trying to handle the problem seems a bit awkward to me from an DA perspective.
- Why don't you just ad a "presentation_order" column and update that one...
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
July 31, 2010 at 12:10 pm
can't you just drop the FK constraint on the dependant table(s) ?
Make sure you have scripted all PK/FK constraints you need for this operation.
play it safe, start...
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
July 31, 2010 at 1:59 am
I've seen that with offline databases being dropped, the files weren't removed. (I should test with which version this was)
I've also seen that when dropping a big database, but...
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
July 31, 2010 at 1:56 am
Don't use 'sa' for ANY login !! This is a worst practise !
If this is within the same domain, just use a windows service account to configure the mirroring stuff.
Use...
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
July 30, 2010 at 10:04 am
Viewing 15 posts - 2,926 through 2,940 (of 7,502 total)