Viewing 15 posts - 2,806 through 2,820 (of 2,903 total)
I really like this site and have just lived with it's slowness. I am also active on another site (www.tek-tips.com) and use both to get the answers I need. What...
January 31, 2003 at 1:25 pm
Are you looking to do it manually or through a script?
Manually, you can use Enterprise Manager and go to Management > SQL Agent > Jobs right-click on the job and...
January 31, 2003 at 1:19 pm
Have you checked out sp_spaceused in the BOL? Also, there is an 'undocumented' procedure called sp_MSforeachdb which executes up to 3 commands for every db on the system (from Guru's...
January 31, 2003 at 1:05 pm
Another site that I enjoy is
It's not just for SQL Server or Win2K or anything else. There are several different forums and they cover just about anything computer...
January 30, 2003 at 5:43 am
quote:
Sorry for the daft question buy what is a hibernating lap-top?
I have heard this term...
January 30, 2003 at 5:37 am
With this data:
Salesman Date Amount
A 12/12/2002 5000
B 1/01/2003 10000
C 1/11/2001 8000
A 1/1/2003 3000
A 5/1/2002 11000
B 25/12/2002 8000
Limits table
Salesman Limits
A 10000
B 15000
How are you getting these...
January 29, 2003 at 8:14 am
Lazy, not necessarily. I work on a contract with the Federal Government. Before we can apply a Service Pack (to anything, not just SQL) it must be approved by a...
January 29, 2003 at 6:07 am
Converting to a string does work, but only if you use the yyyy-mm-dd format. This should work for you if you want to use CONVERT:
CONVERT(CHAR(10), getdate(), 20)
-SQLBill
January 24, 2003 at 1:28 pm
To my knowledge, you can't do what you are trying. I believe the backups are all or nothing.
-SQLBill
January 24, 2003 at 1:24 pm
Check out the Books OnLine (BOL) for backing up a log with truncate only. I believe the syntax is:
BACKUP LOG <database_name> TO <device_name> WITH TRUNCATE ONLY
That will truncate your log,...
January 24, 2003 at 1:20 pm
I don't believe you can cluster without a shared drive and SQL Server needs to be on the shared drive.
-SQLBill
January 24, 2003 at 11:12 am
quote:
I must be missing something. I am using EM. I can restore the full backup and differential but I cannot restore the...
January 24, 2003 at 6:59 am
Something to remember....
WITH RECOVERY (which is the default) means this is all that I have to restore. WITH NO RECOVERY means I have more files to restore.
-SQLBill
January 23, 2003 at 12:04 pm
Chandu,
I'm wondering if we are missing the point of your question. It appears you have now tried most of the suggestions and are still not happy. I'm thinking that you...
January 23, 2003 at 12:02 pm
quote:
I'd like some debate, however, so I'd like to state 2 extremes, and ask where people's tradeoffs are?1. Critical system, 24...
January 21, 2003 at 12:31 pm
Viewing 15 posts - 2,806 through 2,820 (of 2,903 total)