Viewing 15 posts - 4,531 through 4,545 (of 7,502 total)
Sqlchamp (9/12/2008)
sp_help db test gave result test db does not exist.
Again in a nutshell I am trying to automate db and tran log restore via sql job.
I...
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
September 13, 2008 at 7:13 am
gomikem (9/12/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
September 12, 2008 at 10:47 am
I'm sorry, I've overlooked the fact I was using sqlcmd. :blush:
Copy / paste .. you know :ermm:
did you try using the column separator parameter ?
from bol:
http://msdn.microsoft.com/en-us/library/aa214012(SQL.80).aspx
-s col_separator
Specifies 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
September 12, 2008 at 10:32 am
well ... here's what I used...
http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html
-- how to determin SQLServer Uptime
-- Source: Tracking Uptime by Brian Moran http://www.winnetmag.com/SQLServer/Article/ArticleID/38042/SQLServer_38042.html
--
--
SELECT @@servername as ServerName, datediff(mi, login_time, getdate()) as SQLServer_UpTime_Minutes
FROM sys.dm_exec_sessions
WHERE...
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
September 12, 2008 at 7:48 am
If you log load isn't that much, you may want to consider making a full backup and use log backups.
Then you can restore the full backup (norecovery) (first...
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
September 12, 2008 at 7:34 am
Does anyone know what the terminology GDR and QFE means in the bulletin ?
It mentions SQL2000 GDR , SQL2000 QFE, SQL2005 GDR , SQL2005 QFE.
Am I having a weak...
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
September 12, 2008 at 5:31 am
Gayathri.Varadarajan (9/12/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
September 12, 2008 at 5:20 am
Many times, this kind of issue points to the upmost advantage of using surrogate keys (which don't have a symantic payload at all, but their strict value).
Change 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
September 12, 2008 at 3:09 am
That is indeed a valid workaround if this is a singleshot operation (upgrade, bugfix,...)
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
September 12, 2008 at 2:46 am
If you want datetime info, your best choice is a column of the datetime data type !
You'll get a bunch of datetime functions to surve you !
Rule number 3:...
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
September 12, 2008 at 1:02 am
Gayathri.Varadarajan (9/12/2008)
...The on update cascade is not a preferred option.....
Then don't update PKs !
If you have FKs pointing to that parent table (I sure hop so), and you realy need...
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
September 12, 2008 at 12:47 am
Isn't this one in Steves build list ? http://www.sqlservercentral.com/articles/Administration/2960/
info at http://support.microsoft.com/kb/934458
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
September 12, 2008 at 12:43 am
did the "restore database" step succeed ?
(what's it output)
can you perform sp_helpdb 'test'
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
September 12, 2008 at 12:18 am
Euhm.... no. It does not produce the same result as show client stats.
Test it and you'll see it reports on object base (stats io).
You can then compare that to 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
September 12, 2008 at 12:13 am
I have the impressions it comes to your output capturing way.
Use this:
SQLCMD -E -S .\SQL2000PE -d master -i ".\Osq_Test.sql" -o ".\Osq_Test.txt" -w340 -n -h-1
my Osql_test.sql contains:
/* just produce an output...
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
September 12, 2008 at 12:05 am
Viewing 15 posts - 4,531 through 4,545 (of 7,502 total)