Viewing 15 posts - 4,951 through 4,965 (of 7,502 total)
- is your sqlserver "member" object a view or a table ?
If it is a view, can you post the ddl ?
-Are you using a linked table 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 18, 2008 at 11:09 am
did you check http://www.sqlservercentral.com/Forums/Topic459602-148-1.aspx ?
or
http://www.sqlservercentral.com/Forums/FindPost328227.aspx
or http://www.sqlservercentral.com/articles/OpenDataSource/61552/
or http://www.sqlservercentral.com/Forums/Topic475347-8-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
April 18, 2008 at 5:11 am
I'm glad you found the issue and were able to fix it.
You could also have granted full control or the service account to the folder that contains the logfiles.
But that...
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 18, 2008 at 5:05 am
The little test ...
/*
use master
alter database SSC_TestBU set read_only with rollback immediate;
drop database SSC_TestBU;
alter database SSC_TestRcvr set read_only with rollback immediate;
drop database SSC_TestRcvr;
...
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 18, 2008 at 3:56 am
- What do you use to read the xls file ?
- did you try using DTS ?
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 18, 2008 at 3:00 am
- keep your head cool ( if you don't, no one else will do it for you !)
- have a look a sqlserver errorlog file and search for anomalies
- take...
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 18, 2008 at 2:58 am
- off course you cannot apply previous log-backups to the new full backup.
- every full backup starts a new recovery "cycle".
- For SQL2005 there is this new "copy_only" parameter that...
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 18, 2008 at 2:49 am
Marios Philippopoulos (4/17/2008)
...invoked from a SQL job ....
Especialy in that case, put it in a effective .net application or SSIS package and don't poison your db-server with it !
Prepare 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 17, 2008 at 7:54 am
you may want to have a look at fn_split kind of functions .
Maybe they may provide what you look for without using dynamic sql.
have a look at :
http://www.sqlservercentral.com/scripts/Miscellaneous/30225/
http://www.sqlservercentral.com/scripts/String+Manipulation/61509/
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 15, 2008 at 1:26 pm
Is someone using the "copy database" wizard ?
It proposes a "detach - attach" scenario. :sick:
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 15, 2008 at 6:29 am
Be happy it's only the clr going down.
I've had a whole instance going down when activating a memory hog CLR function.
http://www.sqlservercentral.com/Forums/FindPost457289.aspx
IMO This is one of the reasons to avoid CLR...
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 15, 2008 at 6:25 am
This is the way we implemented it ...
http://www.sqlservercentral.com/articles/Security/3203/
maybe that can be a good starting point for 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
April 15, 2008 at 12:09 am
Why materialize it in two tables ?
- I prefer small objects
- Adaptability.
Maybe there are even other columns that may be related to the relationship.
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 14, 2008 at 11:50 pm
- one problem is that most of the time there will be two parents :blink:
some kind of biology or tube issue.. 😉
- build a "parent2Child" table having a double...
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 14, 2008 at 10:49 am
Thank you for pointing to this "flaw".
That may be one of the reasons _not_ to use information_schema stuff.
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 14, 2008 at 6:03 am
Viewing 15 posts - 4,951 through 4,965 (of 7,502 total)