Viewing 15 posts - 8,596 through 8,610 (of 9,244 total)
what ADI posted is not what the OP required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 23, 2008 at 8:39 am
do you have database mail configured correctly?
check BOL for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 23, 2008 at 8:33 am
Paresh Prajapati (12/23/2008)
Bac i don't have deep knowledge and confuse to it.
I simply know that in Active/Passive alustering one is active at a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 23, 2008 at 5:24 am
certainly will
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 3:27 pm
check this link
scroll down and find the MSI package
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 1:51 pm
Jeff Moden (12/22/2008)
Thanks for the kudo, J. :blush:
better than a pork chop 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 1:46 pm
try manually installing the backward compatibilty tools from the CD.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 1:43 pm
samsqlserver (12/21/2008)
Now i am want to know what query did sql server recieve to find that there is a missing index.
the query optimiser will add an entry if it finds...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 1:37 pm
disable any constraints,etc and rename the table. Create the new table with the column order and then pump the data across. But why, as pointed out already it doesnt matter...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 11:01 am
msalmaan (12/22/2008)
very huge transaction log in size.
msalmaan (12/22/2008)
size is about 1GB
wow, as big as that 😀
msalmaan (12/22/2008)
and unable to open it.
not advisable
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 10:48 am
use the generate scripts option to script of the indexes, constraints, triggers,etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 10:45 am
ah see it now.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 9:53 am
Ahmad Osama (12/22/2008)sqlcmd -S BUILDSERVER -E
is BUILDSERVER the correct instance name?
restart the instance and login through SSMS and open a new query window then run
select @@servername
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 8:38 am
it should be possible to dump the RESTORE FILELISTONLY to a temp table and then build a restore command from the data in that temp table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 8:33 am
yeah, you'd expect a named instance to have a unique servicename
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2008 at 8:24 am
Viewing 15 posts - 8,596 through 8,610 (of 9,244 total)