Viewing 15 posts - 16 through 30 (of 148 total)
GilaMonster (8/13/2012)
If taking a backup with the option "Back up to new media set and erase all existing backup sets" cleared the list you are talking about, then that list...
August 13, 2012 at 2:24 pm
GilaMonster (8/13/2012)
tilew-948340 (8/13/2012)
BTW, I reset the "database" list by doing a backup with the option "Back up to new media set and erase all existing backup sets",
So the list...
August 13, 2012 at 1:47 pm
SQLRNNR (8/13/2012)
http://msdn.microsoft.com/en-us/library/ms177182.aspxThere is a maintenance plan option for backup history cleanup.
I can't do it...
From MSDN "Create a Maintenance Plan (Maintenance Plan Design Surface)", I found this:
To create a maintenance plan
1.In...
August 13, 2012 at 12:46 pm
GilaMonster (8/13/2012)
If the list that the SSMS restore dialog brings up, that's just the backup history in MSDB. You can use SQL Agent with the...
August 13, 2012 at 12:12 pm
I put the DB in "simple" recovery model and the error message is gone. I will still make some test with the backup from the networked virtual machine (just in...
August 13, 2012 at 11:36 am
GilaMonster (8/13/2012)
You need to either:
- Switch the database to simple recovery if you don't need point in time restores
...
Which you do depends how much you value the data in that...
August 13, 2012 at 9:40 am
GilaMonster (8/13/2012)
You backup the...
August 13, 2012 at 7:25 am
Perry Whittle (8/10/2012)
You are restoring over the top of an existing database and you have not checked the WITH REPLACE option.
If you want to replace the existing database completely check...
August 13, 2012 at 6:23 am
From the remarks in the sp_rename definition:
Renaming a stored procedure, function, view, or trigger will not change the name of the corresponding object name in the definition column of the...
July 30, 2012 at 7:19 am
HowardW (7/25/2012)[hr
Hmm, not sure I understand what you're asking. Yes, it would update if you changed a column in that row as any other deterministic function would - try it...
July 25, 2012 at 9:58 am
HowardW (7/25/2012)
July 25, 2012 at 8:13 am
Karthiart (7/25/2012)
Below is the entire script which will meet your requirement.
create table #test ( id int, col1 int, col2 int)
ALTER TABLE #test ADD computed_Max AS (CASE WHEN COL1< COL2...
July 25, 2012 at 7:59 am
tilew-948340 (7/25/2012)
HowardW (7/25/2012)
There's no built in function that gives you the maximum values from a list of column inputs (it's called GREATEST in some languages),[/code]
If there is no built in...
July 25, 2012 at 7:55 am
HowardW (7/25/2012)
There's no built in function that gives you the maximum values from a list of column inputs (it's called GREATEST in some languages),[/code]
If there is no built in function,...
July 25, 2012 at 7:45 am
I would agree on that if I was not looking for a computed column
My best way, would be to calculate the values while entering the data via the interface, but...
July 25, 2012 at 7:42 am
Viewing 15 posts - 16 through 30 (of 148 total)